Register now to learn Fabric in free live sessions led by the best Microsoft experts. From Apr 16 to May 9, in English and Spanish.
Hello All,
Often when I am browsing various Power BI blogs/forums I will see posts that this or that function is a slow function as it scans every line. Filter is often brought up in discussions around DAX.
My question is other than testing every function and personal experiance with different functions is there a better way to test if a function in either Power Query or DAX is a "fast" or a "slow" function?
I am aware that with DAX queries tools such as the great DAX Studio can show this, but for Power Query I have no idea how this could be determined.
Thanks,
Tom
Solved! Go to Solution.
A lot of that comes with experience. For example, any function with an extra "X" on the end is generally a "slow" function as it is essentially doing a table scan. For example, MAXX, COUNTX, MINX, SUMX, etc.
A lot of that comes with experience. For example, any function with an extra "X" on the end is generally a "slow" function as it is essentially doing a table scan. For example, MAXX, COUNTX, MINX, SUMX, etc.
Thanks for your reply, is there anyway to see the underlying code for either DAX or power query functions or is this all closed?
Check out some of these DAX tools, they may help:
https://www.sqlbi.com/articles/tools-for-dax-and-tabular-developers/
Covering the world! 9:00-10:30 AM Sydney, 4:00-5:30 PM CET (Paris/Berlin), 7:00-8:30 PM Mexico City
Check out the April 2024 Power BI update to learn about new features.
User | Count |
---|---|
114 | |
99 | |
83 | |
70 | |
61 |
User | Count |
---|---|
149 | |
114 | |
107 | |
89 | |
67 |