Forum Discussion
Optimising Power Query in an excel spreadsheet
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://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/
Hello gawumpki
as camargos88 already mentioned Power Query can fold, that means that only the data you requested is transfered from SQL to Excel. However, when you write a DAX, exactly that is queried. The best practise is to connect to SQL and put all steps, that are reducing the amount of that in the beginning (removing rows, columns). Don't put any sort 🙂
Hope this helps
If this post helps or solves your problem, please mark it as solution (to help other users find useful content and to acknowledge the work of users that helped you)
Kudoes are nice too
Have fun
Jimmy