Forum Discussion
Power BI Only Loading 276 Items from SharePoint List + Duplicating Some – Need Help!
Iirc when this has happened in the past, you can scroll to the bottom of your query and see if there is an error complaining about something. I've sometimes run across lists where even just one item is missing a field (as in the whole field somehow did not get associated to the item, not just that it is blank) and it causes the whole query to error.
Alternatively, you can try a simple api call on just IDs to see if you can get more than 276 items.
= Web.Contents( "https://{site_url}/_api", [ RelativePath = "/web/lists/GetByTitle('List Title')/items", Headers = [accept="application/json;odata=nometadata"], Query = [ #"$select" = "ID", #"$top" = "5000" ] ] )
Super UserIirc when this has happened in the past, you can scroll to the bottom of your query and see if there is an error complaining about something. I've sometimes run across lists where even just one item is missing a field (as in the whole field somehow did not get associated to the item, not just that it is blank) and it causes the whole query to error.
Alternatively, you can try a simple api call on just IDs to see if you can get more than 276 items.
= Web.Contents(
"https://{site_url}/_api",
[
RelativePath = "/web/lists/GetByTitle('List Title')/items",
Headers = [accept="application/json;odata=nometadata"],
Query = [ #"$select" = "ID", #"$top" = "5000" ]
]
)