Forum Discussion
data refresh to work, if other excel data source fails to refresh or is broken
Hi, If the PBI report is based on multiple data source then what could be the method for schedule refresh to work on the web service if other excel data source is broken or fail to refresh? Appr...
Idrissshatila
Super User
Super UserHello,
You should use a data gateway if you have a data source that is on premises not on cloud, and you should setup the data gateway in the service. Also the server which has the datasets should be turned On when the data is refreshing.
Here is a link on data gateway https://learn.microsoft.com/en-us/power-bi/connect-data/service-gateway-onprem
If I answered your question, please mark my post as solution, Appreciate your Kudos 👍
Idrissshatila data is on the cloud in my case. thank you.