OneDrive synchronization instantly

[julsr]

Hello everyone,

I configured my dev workspace and uploaded the files from a Shared Library from OneDrive. I noticed the option that refreshes the items hourly, so it ensures that we have the latest version in Power BI based on the Shared Library. However, I would like to know if there's an option to do this refresh on demand in Power BI (without uploading the file again to the workspace) or to ensure that every time we have a new version, Power BI synchronizes both. Is this possible?

Thanks

[BhavinVyas3003 · Accepted solution]

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.

[julsr]

Thank you all for your answers! @v-pnaroju-msft @MasonMA @BhavinVyas3003 .

[v-pnaroju-msft]

Thankyou @MasonMA, for your response.

Hi julsr,

We appreciate your inquiry through the Microsoft Fabric Community Forum.

We would like to inquire whether have you got the chance to check the solution provided by @MasonMA to resolve the issue. We hope the information provided helps to clear the query.
Should you have any further queries, kindly feel free to contact the Microsoft Fabric community.

Thank you.

[MasonMA]

@julsr 

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:)