Forum Discussion
Incredibly poor SharePoint performance
I'm getting some incredibly poor performance with queries that reference SharePoint, both SP List and SP Folder queries. The one I'm working on at the moment mainly has SP Folder queries. One...
I think I've narrowed down our issue.
One of the document libraries contains scans of compliance paperwork - tens of thousands of files. As the initial step on any query to SharePoint is to download the list of all the files this step is taking a very long time to do.
The query has just finished and there are 156k files which isn't a big dataset to download. However, I find the performance of extracting SharePoint lists to be incredibly poor so I think this is the real issue.
hi, Veles
This usually doesn't last, It could due to the network or the server,
It also could due to the hardware for running Power BI Desktop.
So you could try it again in different working environments.
Best Regards,
Lin