Forum Discussion

lcasey's avatar
lcasey
Post Prodigy
4 years ago

SharePoint Online Connector

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...
Need Help
v-xiaotang's avatar
v-xiaotang
Community Support
4 years ago

Hi lcasey 

If the data set size is relatively large, it may cause problems such as slow refresh or refresh failure,

https://docs.microsoft.com/en-us/power-query/connectors/excel#sluggish-or-slow-performance-when-loading-excel-data

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.