Forum Discussion
OneDrive synchronization instantly
- 1 year ago
While you can click Refresh Now in Power BI Service to refresh the dataset (reload data into your model from the source), this does not instantly sync the file from OneDrive; it only works if Power BI has already synced the latest version of the file. If you want Power BI to detect file changes immediately, you’d need to use Power Automate to monitor file changes in OneDrive and then trigger a dataset refresh using the Power BI REST API or Power Automate's built-in Refresh a dataset action.
Hi, it’s possible to manually or automatically force a refresh in Power BI Service.
For your first question, you can use the “Refresh Now” Button in Power BI Service. Please refer to the official document from MS and you will see it on the webpage.
https://learn.microsoft.com/en-us/power-bi/connect-data/refresh-data
For your second question, you would need to use Power Automate to trigger the Refresh. You will see a few YouTube tutorials about this topic, one of them here, fyi,
https://youtu.be/2J51rgnFMqs?si=GyQQqmNeXzNOhcQ7
and I think the logic would be: when your Power Automate detects a file change in OneDrive, it will call the Power BI REST API or Power BI “Refresh a dataset” action.
Hope this helps:)