Forum Discussion
Ian_Stuart_Rupe
Advocate III
Advocate IIIPower Query Performance
In general I find Power Query performance to be very poor when building a medium complexity script. For example it seems really inefficient on joins (merges) and if I have a fact table that I want t...
smpa01
Community Champion
Community ChampionIan_Stuart_Rupe I can understand the feeling. PQ has performance issues and the performance is nowhere near to SQL's performance.
PQ is largely used for data transformation. If you are bringing the tables from a SQL server and if you have an option, do all the transformation server-side and only use PQ to transport those tables.
If you have tables from multiple sources (e.g. SQL and sharepoint) it is recommended that you build a data model and use DAX to genrate the output.
DAX is blazing fast (if not as fast as SQL) and it will not disappoint you.
There are also known tweaks described here that makes significant difference to PQ's performance. But for large dataset I did not find PQ's performance satisfactory.