How to get SharePoint/OneDrive to update Datasets on Power bi Service

[Roberto456]

Hello All.

I have a PBIX file connected through the web to a OneDrive Excel Document.

When the excel document is updated the Dataset is not.

How can I get people accessing the OneDrive Excel file to automatically refresh the Power BI Service dataset?

[lbendlin]

Ah, the eternal mystery.  Microsoft documentation states that datasets with Onedrive data sources are refreshed every hour automatically. We don't see that in our tenant. 

We advise our users to setup scheduled refresh in Power BI service, or API based refresh in Power Automate  (when a sharepoint file is modified, initiate a dataset refresh). NOTE1:  a refresh request is ignored/fails when a refresh is currently in progress. NOTE2: the number of permitted schedules and API calls is controlled by your Power BI capacity SKU.

[Roberto456]

Im not sure what any of that means lol, i dont work in IT or anyhting to do with infrastrucure 😞

I saw a video somewhere where you can load a data source into the power BI service only by doing the import data into the workspace, but I cant seem to load data that is only shared with me and not my own document.

[Roberto456 · Accepted solution]

I did a Check and changed the excel document and set the automatic refresh, and nothing happened to the PBI document.

Never mind it did update, just 15 minutes late.

[lbendlin]

Nothing will happen to the Power BI document . The change will be to the dataset on the service.