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

[ivan_wilson]

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.

[ivan_wilson]

Thank you! That works perfectly

[ppm1 · Accepted solution]

Not sure why you aren't seeing all your items (did you select a limited View?), but FYI on an alternate approach that may be faster too.

Updated – Get SharePoint List Data … Fast – Hoosier BI

Pat