How to Automatically Refresh Power BI Visuals from SharePoint Lists
Question details
The user needs Power BI visuals on a continuous display to update automatically when the underlying SharePoint List data is changed via Power Apps.
- Product
- Microsoft Power BI
- Device & OS
- not provided
- Scenario
- Displaying a Power BI report continuously on a screen, with data sourced from a SharePoint List.
- Observed behavior
- The dataset refreshes successfully in the Power BI Service, but the on-screen visuals do not update automatically and require a manual page refresh to reflect the new data.
Ensure you have the appropriate Power BI license (Pro or Premium) and Workspace Admin permissions to configure automatic page refresh settings.
Configure Automatic Page Refresh in Power BI Desktop
Enable the Automatic Page Refresh (APR) feature to automatically update report visuals at a specified interval without manual intervention.
Power BI dataset refresh and report-page visual refresh are two separate processes. Even if your dataset is updating, the visuals will not reflect the changes until the page itself is refreshed. Enabling APR bridges this gap.
Open your report in Power BI Desktop and click on an empty area of the report page to ensure no specific visuals are selected.
Navigate to the 'Visualizations' pane on the right side and click the 'Format page' icon (paint roller or canvas settings).
Scroll down to find the 'Page refresh' option and toggle the switch to 'On'.
Expand the section, ensure the refresh type is set to 'Auto page refresh', and input your desired refresh duration (e.g., every 5 minutes or 30 minutes).
Save your changes and publish the updated report to the Power BI Service for the continuous display screen.
Consult the Official Power BI Community
If capacity limitations or data-source constraints prevent Automatic Page Refresh from working as expected, seek specialized guidance from the Microsoft community.
Looking for a Lightweight Data Analysis Tool? Try WPS Office
While complex Power BI dashboards require specific Microsoft licenses and capacity management, WPS Office provides a free, lightweight alternative for everyday data analysis. With WPS Spreadsheet, you can easily manage lists, create dynamic charts, and analyze data without worrying about complex cloud refresh configurations.
- 1. Download WPS Office: Visit the official WPS website and download the free WPS Office suite for your operating system.
- 2. Install and Launch: Follow the straightforward installation prompts, then open WPS Spreadsheet.
- 3. Import Your Data: Open your existing .xlsx or .csv data files directly in WPS to immediately start creating charts and analyzing data.
Frequently Asked Questions
Why does my Power BI dataset refresh but the visuals don't?
Dataset refresh and report page refresh are two separate processes in Power BI. A dataset refresh updates the underlying data model, but the report visuals won't query that new data to display it until the page is reloaded manually or Automatic Page Refresh (APR) is triggered.
Can I use DirectQuery with SharePoint Lists in Power BI?
Power BI typically uses the Import mode for SharePoint Lists. DirectQuery is not natively supported for SharePoint Online lists, which means you must rely on scheduled dataset refreshes combined with Automatic Page Refresh to update visuals.
What is the minimum refresh interval for Automatic Page Refresh?
For Power BI Pro users on a shared capacity, the minimum allowed interval for Automatic Page Refresh is 30 minutes. If you have a Power BI Premium capacity, the workspace administrator can configure intervals as fast as 1 second, though this depends entirely on the capacity limits set by your organization.
