Others

Fix Power BI SharePoint List Report Not Showing Recent Created Dates

Phi Hung VoPhi Hung Vo Oct 13, 2026 871 views

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.

Fix Power BI SharePoint List Report Not Showing Recent Created Dates
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.
Before you start

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.

Solution 1Recommended

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.

1
Refresh the Power BI dataset

Log into the Power BI Service, navigate to the workspace containing your SharePoint list report, locate the dataset, and click the 'Refresh now' icon.

2
Check the Filters pane

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.

3
Inspect date hierarchies

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.

Refresh Dataset and Verify Report Filters
Free Microsoft Office alternative

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. 1. Export your SharePoint list: From your SharePoint list view, click 'Export' and select 'Export to CSV' or 'Export to Excel'.
  2. 2. Open with WPS Spreadsheet: Launch WPS Office, open the 'Spreadsheet' module, and import your downloaded data file.
  3. 3. Visualize your data instantly: Highlight your data range and click 'Insert' > 'Chart' or 'PivotTable' to create your own reliable reports in seconds.
Effortlessly import and visualize large datasets without complex integrations.Fully compatible with Microsoft Excel (.xlsx and .xls) and CSV formats.Built-in advanced data visualization tools including PivotTables and dynamic charts.Lightweight desktop application that runs smoothly across all major operating systems.
microsoft office alternative - wps office

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.