Forum Discussion

Anonymous's avatar
Anonymous
Not applicable
7 years ago

Performance inspector for Desktop?

Is there a way to analyze performance of a Power BI query? I have a report that is quite large and has about 80 steps of transformation. Needless to say, it takes a while to load. That's ok with me a...
Need Help
parry2k's avatar
parry2k
Super User
7 years ago

Anonymous  if you have lot of steps, best would be to go thru each step and see what steps take longer. If your data source is sql server, I guess you can use profiler to see what is taking longer to load.

 

if performance issue is with DAX then you can DAXStudio (available free to download) to debug the expression. I hope it is helpful.

  • Anonymous's avatar
    Anonymous
    Not applicable
    7 years ago
    parry2k wrote:

    Anonymous  if you have lot of steps, best would be to go thru each step and see what steps take longer.

     

    Ah, i hadn't thought of stepping through each item. I'll give that a shot and report back. Thanks!

  • Anonymous's avatar
    Anonymous
    Not applicable
    7 years ago

    parry2k i'm going through the steps now and finding that all the steps that manipulate columns with text are causing the issue. There aren't a ton of them, but there are several. Any idea how to optimze those?

    • parry2k's avatar
      parry2k
      Super User
      7 years ago

      Anonymous what you are trying to do in the step you found is running slow?

      • Anonymous's avatar
        Anonymous
        Not applicable
        7 years ago

        parry2k right now the slowest step is a merge between two tables. It's joining on a 2 to 3 character unique code. One table has the code as a primary key while the other has it as a foreign key. There's about 200 rows in the primary table and 20k in the other.