'%3e%3cpath%20d='M8%200C12.4183%200%2016%203.58172%2016%208C16%2012.4183%2012.4183%2016%208%2016C3.58172%2016%200%2012.4183%200%208C0%203.58172%203.58172%200%208%200ZM11.6162%204.38379C11.2257%203.99337%2010.5927%203.99338%2010.2021%204.38379L8%206.58594L5.79785%204.38379C5.40732%203.99334%204.77429%203.99329%204.38379%204.38379C3.99331%204.77429%203.99335%205.40733%204.38379%205.79785L6.58594%208L4.38379%2010.2021C3.99348%2010.5927%203.99341%2011.2257%204.38379%2011.6162C4.77426%2012.0066%205.40734%2012.0065%205.79785%2011.6162L8%209.41406L10.2021%2011.6162C10.5927%2012.0066%2011.2257%2012.0067%2011.6162%2011.6162C12.0067%2011.2257%2012.0066%2010.5927%2011.6162%2010.2021L9.41406%208L11.6162%205.79785C12.0066%205.40735%2012.0066%204.77429%2011.6162%204.38379Z'%20fill='%23080E17'%20fill-opacity='0.46'/%3e%3c/g%3e%3cdefs%3e%3cclipPath%20id='clip0_3761_713'%3e%3crect%20width='16'%20height='16'%20fill='white'/%3e%3c/clipPath%3e%3c/defs%3e%3c/svg%3e)
How to Fix Power BI Not Refreshing Data from a SharePoint List
Question details
Users are experiencing an issue where Power BI reports do not show newly added SharePoint list records, even when the data refresh completes successfully.
- Product
- Power BI
- Device & OS
- not provided
- Scenario
- Refreshing a Power BI report connected to a SharePoint list data source.
- Observed behavior
- The refresh completes and the refresh date updates in the dashboard, but the latest SharePoint list records are missing from the report.
Ensure you have the latest version of Power BI Desktop installed and verify your SharePoint list permissions before troubleshooting the data connection.
Report the Issue to the Power BI Community
Since this is often a backend connector or synchronization issue, contacting Microsoft Support or the Power BI Community is the most effective approach.
In some instances, the Power BI SharePoint connector may experience backend syncing anomalies where the refresh API call succeeds, but the payload drops newer rows. Because this is a server-side connector issue, escalating it allows Microsoft engineers to investigate connector behavior.
Navigate to the official Microsoft Power BI Community forums in your web browser.
Create a new topic detailing your specific SharePoint data source version (e.g., SharePoint Online) and the exact connector you are using.
Include screenshots of your refresh history and describe the exact missing records to help support diagnose the issue.
Wait for Power BI support or community experts to investigate the connector behavior using their internal diagnostic tools.
Verify SharePoint View Limits and Data Types
Power BI may silently fail to pull new data if the SharePoint list exceeds the view threshold or contains unsupported complex data types.
Manage and Analyze Your Data Easily with WPS Office
While complex BI dashboards require specialized tools, WPS Spreadsheet offers a powerful, lightweight, and free alternative for everyday data analysis, reporting, and list management. Enjoy full compatibility with Microsoft Excel formats without the heavy subscription costs.
- 1. Download WPS Office: Visit the official WPS website to download and install the free suite.
- 2. Import SharePoint Data: Export your SharePoint list as a CSV or Excel file, then open it directly in WPS Spreadsheet.
- 3. Analyze and Visualize: Use built-in Pivot Tables and chart tools in WPS Spreadsheet to analyze your records efficiently.
Frequently Asked Questions
Why does my Power BI refresh succeed but no new data appears?
This often happens due to caching issues, an outdated SharePoint connector, or the SharePoint list exceeding its item threshold, which prevents the API from fetching the latest rows even if the refresh command completes.
How can I force Power BI to clear its cache and pull fresh SharePoint data?
In Power BI Desktop, go to File > Options and settings > Options. Under the 'Data Load' section, click 'Clear Cache' for both Data Cache Management and Q&A Cache, then attempt the data refresh again.
Does the Power BI SharePoint connector support all list columns?
No, certain complex column types in SharePoint, such as multi-value lookups or specific calculated fields, might not synchronize correctly with Power BI. Sticking to standard text, number, and date fields ensures better reliability.
