Sharepoint List Extract Records = very slow apply query, plz help

[demerch1]

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

[v-juanli-msft]

Hi @demerch1 

If there are relationships among your queries, the records contains data from other queries, please refer to this threads:

https://community.powerbi.com/t5/Desktop/Refresh-very-slow-when-using-SharePoint-people-picker-field...

Some references regarding improve performance of power query:

Speeding up 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.