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
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