Starting December 3, join live sessions with database experts and the Microsoft product team to learn just how easy it is to get started
Learn moreGet certified in Microsoft Fabric—for free! For a limited time, get a free DP-600 exam voucher to use by the end of 2024. Register now
Hello,
In power bi desktop we user SharePoint Online connector V1 to connect to multiple tables in Sharepoint lists with 100k and more records. This V1 connector is no longer working and all our reports have finallyt stopped refreshing due to the many hours it takes to refresh. I think we simply hit the limit with the V1 connector.
We tried the SharePoint Online V2 connector , but that doesnt work. It only loads the folders and does not load any records within the folders. In a list of 100k items , it will only load our 50 folders that we keep the records in to overcome the 5k view threshhold. So the V2.0 sharePoint online list connector is useless.
I can export the SharePoint List to excel in less than 1 minute and all 100K records are available. Can Power BI use the same type of connection ? If Excel can loiad 100k records from sharepoint in less than a minute, why cant Power BI?
I really dont want to use the REST API as described in other posts, but would like to find a solution that uses exactly what Excel uses.
Any suggestions?
Hi @lcasey
Have you solved your problem? If yes, could you kindly mark the answer helpful as the solution?
If not, could you provide more details about your problem? so that we can work on it further. Thanks.
Best Regards,
Community Support Team _ Tang
Hi @lcasey
If the data set size is relatively large, it may cause problems such as slow refresh or refresh failure,
I also find a similar post, please check if it can help, https://community.powerbi.com/t5/Desktop/Slow-refresh-of-SharePoint-list-data/m-p/134425
Best Regards,
Community Support Team _Tang
If this post helps, please consider Accept it as the solution to help the other members find it more quickly.
Starting December 3, join live sessions with database experts and the Fabric product team to learn just how easy it is to get started.
March 31 - April 2, 2025, in Las Vegas, Nevada. Use code MSCUST for a $150 discount! Early Bird pricing ends December 9th.
User | Count |
---|---|
90 | |
87 | |
84 | |
68 | |
49 |
User | Count |
---|---|
131 | |
111 | |
96 | |
71 | |
67 |