Power BI Only Loading 276 Items from SharePoint List + Duplicating Some – Need Help!

[ryr96]

Hey everyone,

I’m facing a strange issue while connecting a SharePoint Online List to Power BI:

• The SharePoint list has over 16,000 items, but Power BI is only loading 276 of them.
• Additionally, some of the 276 loaded items appear duplicated after the “Navigation” step in Power Query.
• The original SharePoint list does not have duplicates. • There are no visible transformations in Power Query that would cause this.
• When I export the SharePoint list to a CSV, I get the full 16,000+ items with no issues.
• I have another SharePoint list with over 30,000 items, and Power BI loads that one correctly without any missing data or duplicates.
• I tried to get the data in Excel instead of PowerBi and the issue persists.

Has anyone encountered something similar? Any tips on fixing this?

Thanks in advance!

[v-menakakota]

Hi @ryr96 ,

Thank you @MarkLaf  for providing possible solution,I wanted to check if you had the opportunity to review the information provided. Please feel free to contact us if you have any further questions. If my response has addressed your query, please accept it as a solution and give a 'Kudos' so other members can easily find it.

Thank you.

[v-menakakota]

Hi @ryr96 ,

I wanted to check if you had the opportunity to review the information provided. Please feel free to contact us if you have any further questions. If my response has addressed your query, please accept it as a solution and give a 'Kudos' so other members can easily find it.

Thank you.

[v-menakakota]

Hi @ryr96 ,

I hope this information is helpful. Please let me know if you have any further questions or if you'd like to discuss this further. If this answers your question, please Accept it as a solution and give it a 'Kudos' so others can find it easily.

Thank you.

[MarkLaf · Accepted solution]

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" ]
  ]
)