Forum Discussion

gawumpki's avatar
gawumpki
New Member
5 years ago
Solved

Optimising Power Query in an excel spreadsheet

Hello I have a Power query which directly queries SQL Server database and loads a few tables into the excel sheet. The tables are quite large, most over 300k rows. I actually only need around 600 ro...
Need Help
camargos88's avatar
camargos88
Community Champion
5 years ago

gawumpki ,

 

You can apply filters on Power Query for the SQL tables, so will can take advantage of Query Folding, bringing of the necessary amount of data.

 

https://support.microsoft.com/en-us/office/filter-a-table-power-query-b5610630-f5bf-4ba4-9217-a628f9b89353

 

https://docs.microsoft.com/en-us/power-query/power-query-folding

https://docs.microsoft.com/en-us/power-bi/guidance/power-query-folding

https://www.mssqltips.com/sqlservertip/3635/query-folding-in-power-query-to-improve-performance/

gawumpki's avatar
gawumpki
New Member
5 years ago

Great thank you so much for the links. The 'View Native Query' did not work for my query but i used 'Value.NativeQuery' to get to what i needed. 

Thanks again

Laura