Forum Discussion

Anonymous's avatar
Anonymous
Not applicable
2 years ago
Solved

Refresh from sharepoint

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's avatar
    Anonymous
    2 years ago

    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.

2 Replies

  • aj1973's avatar
    aj1973
    Community Champion

    Hi Anonymous 

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

  • Anonymous's avatar
    Anonymous
    Not applicable

    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.