SharePoint Auto Refresh

[twhui]

Hi,

I created a report in Power BI Desktop with data from Sharepoint and published to service and share among the co-worker.
However, the report is not updated after published and manual update is the only way for me to have the updated report.
The schedule update is only daily or weekly, is that any way to have auto-update, at least once in an hour?

Regards,
Wen Hui

[GilbertQ · Accepted solution]

Hi @twhui 

You can configure the refresh schedule as per the link below.

Refresh a dataset from OneDrive or SharePoint Online - Power BI | Microsoft Docs

Or if you have imported the PBIX via Sharepoint it will auto refresh once every hour and you cannot change that as it currently stands.

[GilbertQ · Accepted solution]

Hi @twhui 

If you are using Power BI Pro you can only refresh a dataset 8 times a day.

You can configure this by using the Scheduled Refresh

Configure scheduled refresh - Power BI | Microsoft Docs

[GilbertQ · Accepted solution]

Hi @twhui 

You can configure the refresh schedule as per the link below.

Refresh a dataset from OneDrive or SharePoint Online - Power BI | Microsoft Docs

Or if you have imported the PBIX via Sharepoint it will auto refresh once every hour and you cannot change that as it currently stands.

[twhui]

Hi @GilbertQ,

Thank you for sharing. If the pbix file is stored in SharePoint, it updates the changes of the file but not the changes of dataset?

I need something like schedule refresh does, but I hope it can be auto-update once in an hour.
Any idea?


Wen Hui