Fix Power BI SharePoint List Report Not Showing Recent Created Dates
Question details
The user's Power BI report connected to a large SharePoint list is missing recent records from the current year, displaying only older data.

- Product
- Power BI / SharePoint
- Device & OS
- not provided
- Scenario
- Generating a data visualization report directly from a SharePoint list using the built-in Power BI integration.
- Observed behavior
- The report displays Created dates from previous years (2021, 2022) but omits newly created items (e.g., 2023 onwards) despite having over 3,000 items in the list.
Ensure that your Power BI Service account has the appropriate permissions to view all records in the SharePoint list and that no default list views are restricting the visible items.
Refresh Dataset and Verify Report Filters
Manually force a dataset refresh and inspect the visual filters to ensure recent dates are not being excluded.
Often, reports generated via the SharePoint integration do not automatically pull real-time data unless a refresh is triggered. Additionally, default report date hierarchies might inadvertently filter out the most recent year.
Log into the Power BI Service, navigate to the workspace containing your SharePoint list report, locate the dataset, and click the 'Refresh now' icon.
Open your report in Edit mode. Expand the Filters pane on the right side of the screen and verify that the 'Created' date filter is set to include all years or uses a relative date covering the current year.
Click on the specific visual that is missing data. Look at the Fields pane to ensure the date hierarchy isn't manually drilled down to exclude the current year.

Recreate the SharePoint List Visualization
Re-establish the connection to rule out temporary integration glitches between SharePoint and Power BI.
Seek Assistance from the Power BI Community
If standard troubleshooting fails, escalate the highly specific sync issue to Microsoft specialists.
Manage and Visualize Your Data with WPS Office
While Power BI is excellent for enterprise-level analytics, troubleshooting external integration issues can be time-consuming. For everyday list management and quick data visualization, WPS Spreadsheet offers a powerful, lightweight, and completely free alternative to Microsoft Office. Easily turn your exported lists into insightful charts and PivotTables without complex syncing.
- 1. Export your SharePoint list: From your SharePoint list view, click 'Export' and select 'Export to CSV' or 'Export to Excel'.
- 2. Open with WPS Spreadsheet: Launch WPS Office, open the 'Spreadsheet' module, and import your downloaded data file.
- 3. Visualize your data instantly: Highlight your data range and click 'Insert' > 'Chart' or 'PivotTable' to create your own reliable reports in seconds.

Frequently Asked Questions
Why does my Power BI report not update automatically with new SharePoint items?
Power BI datasets connected to SharePoint lists require either a manual refresh or a Scheduled Refresh configuration. You must set up scheduled refresh times in the Power BI Service settings to ensure new items appear automatically.
Does the SharePoint list view threshold affect Power BI data pulls?
Yes. If a SharePoint list grows beyond 5,000 items, the standard list view threshold may block data queries. You can resolve this by indexing the columns used for filtering or sorting, such as the 'Created' date column.
How do I check if my Power BI date filters are hiding new data?
Open your report in Edit mode in the Power BI Service. Expand the Filters pane and check the 'Filters on all pages' and 'Filters on this visual' sections. Ensure that the 'Created' date filter allows the current year or is set to 'All'.
Can I export my SharePoint list and analyze it locally?
Absolutely. You can click 'Export to Excel' or 'Export to CSV' directly from the SharePoint list. Once downloaded, you can open and analyze the file using lightweight spreadsheet applications like WPS Office.




