Limit on rows from SharePoint List

[MercedesAlpha1]

Hi

Im using a report in PowerBi which is linked to a sharepoint list but ive just noticed when it reached 200 lines its stopped importing the data onto the report.

Is ther a limit set anywhere on PowerBi or can I set it to show the last 200 records if not so the older ones dont show?

[123abc · Accepted solution]

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)

[Zanqueta]

Hi @MercedesAlpha1,

The behaviour you are experiencing is not a limitation of Power BI itself, but rather how the SharePoint List connector works. By default, when using OData to connect to a SharePoint list, the API returns only 200 rows per page (pagination). If Power Query is not configured to follow subsequent pages, only the first 200 rows will be imported.

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

In Power Query, when connecting to the list:

1. Click Transform Data.
2. In the top bar, go to Data Source Settings and check if you are using the OData.Feed option.
3. 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 🌀.

[MercedesAlpha1]

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