Forum Discussion
Limit on rows from SharePoint List
It looks like Power BI isn’t actually limiting your SharePoint List to 200 rows — the limit is coming from SharePoint itself, not Power BI
SharePoint list views often have an item limit set (for example, “show only the first 200 items”).
When Power BI connects to that view, it only receives whatever the view shows.
So if the view is capped at 200, Power BI only imports 200.Increase or remove the limit in SharePoint
Go to your SharePoint list → List settings → Views → open the view you’re using → scroll down to Item limit.
Increase it or turn it off.
Then refresh Power BI and you’ll get all the rows.2. Or keep all rows in Power BI but only show the newest 200
If you want Power BI to load everything but display only the last 200 entries, you can filter them in Power Query:
Sort your list by date (newest first)
Home → Keep Rows → Keep Top Rows → 200
Or use this M-code:
SortedRows = Table.Sort(Source, {{"Created", Order.Descending}}), Top200 = Table.FirstN(SortedRows, 200)
Hi Anonymous,
Why does this happen?
- The SharePoint connector uses the OData API, which applies pagination to avoid overly heavy queries.
- Each page contains 200 records by default.
How to retrieve all records
- Click Transform Data.
- In the top bar, go to Data Source Settings and check if you are using the OData.Feed option.
- Ensure that the parameter Implementation="2.0" is present, as this enables automatic pagination.
If this response was helpful in any way, I’d gladly accept a 👍much like the joy of seeing a DAX measure work first time without needing another FILTER.
Please mark it as the correct solution. It helps other community members find their way faster (and saves them from another endless loop 🌀.
Data source settings doesnt show this as mine shows the web address for the sharepoint list, although have found its set to 2.0 already