Forum Discussion
Troubleshooting DAX Performance
Hi, I have a problem with my Dashboard performance. Currently it has aboout 65 millions row and it takes approx 10 second to load a table. Upon analysing the process using SQL Server Profiler, I fo...
Hi Xiaoshin
Thanks for the links. Actually, I already did the tracing using the similar method in your provided links. Thats why I can come up with that problematic query in my original post. The only things that, I don't know what to do with that problematic dax query since I never really create a script like that. It seems that script autmatically generated by power bi engine
regards
Hi andrehawari,
If these query is generated by power bi itself, I also not found a way to modify the logic of generate dax query which power bi used.
Perhaps you can take a look at following links if it help for your scenario:
Optimizing & Analyzing DAX Query Plans
Regards,
Xiaoxin Sheng