This all depends on the work being carried out. For example, if it is a consumer unit upgrade, then yes the power will need to go off for several hours whilst the work and testing is being carried out. However most jobs such as a lighting install, only the power for that circuit will need to be isolated, but this is something that will be discussed with your beforehand.