Forum Discussion
Power Query SharePoint Connections Refresh Speeds
Hi, the best approach would be use filtering in the Source step or as early as possible to avoid loading full content of lists if you're only interested in metadata like item count, permissions, or last modified date.
There's official Microsoft documentation recommending filtering as early as possible in Power Query. This means placing your Table.SelectRows(...) filters immediately after the data source step so that fewer rows are pulled into Power BI, reducing memory and processing time.
Best practices when working with Power Query - Power Query | Microsoft Learn
I am not very sure if we have met the same problem.
Actually, after June's update, I find power query in Desktop connceted to Sharepoint goes very slow. I even don't know how to get help. When I refresh some tables from Sharepoint, the Memory of the PC will goes very high after a long time and still the data is not refreshed.
I can't help think what Microsoft Fabric Team have done in the connection because I remember in 2023 the function “SharePoint.Contents" went error,too.
Please check this, thank you