Fix Power BI Report Not Refreshing from SharePoint List
Question details
The user's Power BI report connected to a SharePoint list is not updating with new data despite refreshing the page or clearing the browser cache.
- Product
- Microsoft Power BI
- Device & OS
- not provided
- Scenario
- Attempting to view updated list data in a Power BI report generated via SharePoint's Integrate and Visualize List feature.
- Observed behavior
- The Data Updated timestamp remains unchanged, and new data from the underlying SharePoint list does not reflect in the Power BI report.
Ensure you have the necessary viewing or editing permissions for both the underlying SharePoint list and the associated Power BI workspace before attempting a manual synchronization.
Sync List Structure in Reading View
Manually synchronize the list schema and data connection directly from the Power BI Reading view to force a data update.
When using the Visualize List feature in SharePoint, standard browser refreshes or cache clearing will not update the report's dataset. The list schema must be manually synced from within the Power BI interface.
Navigate to your SharePoint list, launch the Power BI report, and ensure that the report is opened in the Reading view.
Click on the 'File' option located in the top navigation menu of the Power BI interface.
From the dropdown menu, select 'Sync List Structure'. This action will synchronize the SharePoint list schema and refresh the data connection.
Check the 'Data Updated' indicator at the top of the screen to confirm that the timestamp now reflects the current date and time.
Verify Dataset Connection and Refresh Settings
If syncing the list structure does not resolve the issue, verify that your dataset credentials and refresh settings are correctly configured in the Power BI Service.
Looking for a Reliable Office Suite? Try WPS Office
While WPS Office does not directly resolve Microsoft Power BI server-side refresh issues, it is a powerful, free, and lightweight alternative to Microsoft Office. If you frequently export BI data to spreadsheets for local analysis, WPS Office offers comprehensive tools with high compatibility and a familiar user interface.
Frequently Asked Questions
Why doesn't clearing the browser cache update my Power BI SharePoint report?
Clearing the browser cache only removes local temporary internet files. It does not force the Power BI service to fetch new data from the underlying SharePoint list. You must use the 'Sync List Structure' feature or trigger a dataset refresh.
What should I do if my SharePoint list data still isn't showing in Power BI after syncing?
If the 'Sync List Structure' option fails, verify your data source credentials in the Power BI dataset settings. Ensure the account used has active permissions to view the SharePoint list. If the issue persists, seeking help in the dedicated Microsoft Power BI Community is recommended.
Does the 'Visualize List' feature in SharePoint support automatic real-time updates?
No, reports automatically generated using the 'Visualize List' feature do not stream data in real-time. The dataset requires either a manual sync from the Reading view or a properly configured scheduled refresh in the Power BI Service.
