Forum Discussion
Sharepoint List Extract Records = very slow apply query, plz help
i have one sharepoint list as data source which has 122 columns and many of them as "records". I want to extract two columns and get some fields BUT doing so when I apply the changes it is very slow. It took roughly more than five hours to apply the changes. Is there a better way to get the data from the records to improve speed??
I am deleting the columns which i don't use, i then extract the fields from the records (not ma
1 Reply
v-juanli-msftCommunity Support
Hi demerch1
If there are relationships among your queries, the records contains data from other queries, please refer to this threads:
Some references regarding improve performance of power query:
Table.Buffer for cashing intermediate query results or how workaround Unnecessary Queries Issue
Performance Tip for Power BI; Enable Load Sucks Memory Up
Best Regards
Maggie
Community Support Team _ Maggie Li
If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.