Forum Discussion

ivan_wilson's avatar
ivan_wilson
Regular Visitor
3 years ago
Solved

Retrieve SharePoint Online list data - v2.0 connector is returning less than 1% of data

I have a Power BI report that queries a large SharePoint Online list (+40,000 items). This has been working fine until recently. It is now only returning 124 items.

 

However if I set up a new query and use the v1.0 SharePoint Online connector, it returns all my data.

 

I'm using the same account to access the list in both cases. The query is basic - return all rows, all fields from the list. Is there any reason why the v.20 connector would start returning far less items?

 

I've tried creating a new PBIX file, or restricting the query to only return the fields in the default view, but I get the same results.