This is best Fabric, Power BI, SQL and AI community event. How do we know? The last event sold out! Save €200 with code FABCMTY200.
Register nowA new Data Days event is coming soon! This time we’re going bigger than ever. Fabric, Power BI, SQL, AI and more. Don't miss out.
Dear all,
I have created a report in PowerBi desktop that is importing data from an excel file that is tored on a SharePoint page.
The excel file is updated by many different users. I need to have the PowerBi dashboard automatically updated every time a user is making a change in the excel file in Sharepoint. Is that possible?If yes, how? Thanks in advance.
Solved! Go to Solution.
On PowerBI service, you can do the schedule refresh, but I believe this has limits on how many times it can run per day. The best solution would probably be to set up a Power Automate flow to refresh the data every time it detects a change in the excel file. I think this site would give you a good place to start: https://powerbi.microsoft.com/en-us/blog/refresh-your-power-bi-dataset-using-microsoft-flow/
Tahnk you very much for your help. I will tray what you suggested
On PowerBI service, you can do the schedule refresh, but I believe this has limits on how many times it can run per day. The best solution would probably be to set up a Power Automate flow to refresh the data every time it detects a change in the excel file. I think this site would give you a good place to start: https://powerbi.microsoft.com/en-us/blog/refresh-your-power-bi-dataset-using-microsoft-flow/
Sign up to receive a private message when registration opens and key events begin.
If you have recently started exploring Fabric, we'd love to hear how it's going. Your feedback can help with product improvements.
| User | Count |
|---|---|
| 33 | |
| 26 | |
| 21 | |
| 20 | |
| 15 |
| User | Count |
|---|---|
| 63 | |
| 44 | |
| 28 | |
| 24 | |
| 22 |