Forum Discussion

andrehawari's avatar
andrehawari
Helper II
7 years ago

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...
Need Help
  • andrehawari's avatar
    andrehawari
    Helper II
    7 years ago

    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

    • Anonymous's avatar
      Anonymous
      Not applicable
      7 years ago

      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

      SQLBI: Optimization

       

      Regards,
      Xiaoxin Sheng