Microsoft Fabric Community Conference 2025, March 31 - April 2, Las Vegas, Nevada. Use code MSCUST for a $150 discount.
Register nowThe Power BI DataViz World Championships are on! With four chances to enter, you could win a spot in the LIVE Grand Finale in Las Vegas. Show off your skills.
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.
Solved! Go to 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
Thank you! That works perfectly
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
User | Count |
---|---|
23 | |
17 | |
14 | |
12 | |
11 |