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)
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: