Forum Discussion
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.
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
2 Replies
- ppm1Solution Sage
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
- ivan_wilsonRegular Visitor
Thank you! That works perfectly