Refresh from sharepoint

[Anonymous]

Hi there,

I have a dataset fetching a table from an excelfile on my sharepoint site. For some reason it is not possible to set up a standard scheduled refresh once per business hour. As far as I understand, it is supposed to automatically refresh hourly

However, it does not refresh hourly. It's now 15:35 and the last refresh was still

What am I missing here?

[Anonymous · Accepted solution]

Hi @Anonymous ,

You need Importing Power BI Desktop files from OneDrive or SharePoint Online into the Power BI service, and keep the OneDrive refresh setting On, expandSync with OneDrive and SharePoint setting, select Automatic updates, and then select Apply. Then upload a new version .pbix file to OneDrive or SharePoint to replace the older version, Power BI service syncs with those changes too, usually within about an hour.

For more details, you can read related document: Refresh a dataset from OneDrive or SharePoint Online - Power BI | Microsoft Learn

Best regards,
Community Support Team_Binbin Yu
If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.

[aj1973]

Hi @Anonymous 

The versions of the datasets that are sored in OneDrive and SharePoint that refresh the datasets in the service. This Pipeline features.