Forum Discussion
Automatic update excel from hospital database
Hi, I am working in a hospital and I have a folder where I have the Excel files of several databases. I have that folder with all those Excel files already in Power BI Desktop and the reports on the server. I would like that every time the Excel files are updated, they are also automatically updated in Power BI, all without pressing the refresh button since there are many people in the hospital who do not know how to do that.
Thank you very much.
Hello Manu2000 ,
well you need to set a schedual refresh in power bi service and at the same time you need to have a data gateway if the excel sheet is on premises so the refresh would take place.
https://learn.microsoft.com/en-us/power-bi/connect-data/refresh-scheduled-refresh
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 👍
1 Reply
- Idrissshatila
Super User
Hello Manu2000 ,
well you need to set a schedual refresh in power bi service and at the same time you need to have a data gateway if the excel sheet is on premises so the refresh would take place.
https://learn.microsoft.com/en-us/power-bi/connect-data/refresh-scheduled-refresh
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 👍