Extremely slow report: Performance Analyzer indicates DAX

[ERing]

I have a report that runs VERY slow. I need to speed up the report as it's currently almost unusable.

I ran the report in Performance Optimizer and nearly every visual has long DAX times. I'm confused by this because my DAX is very simple and I don't know any other way to write it. Some of the visuals don't even use any DAX so I'm not sure why they have long DAX times.

Any thoughts on how I can address this issue?

Count_Jobs = VAR A =
 COUNT(DIM_JOB_SUMMARY[ID])
 RETURN IF(ISBLANK(A),0,A)

Count_Total_Customers = Count(DIM_C360_CUSTOMER[ID])

Total_Revenue = VAR A = 
 sum('DIM_JOB_SUMMARY'[SUBTOTAL_INVOICE_AMOUNT])
 RETURN IF(ISBLANK(A),0,A)

[lbendlin · Accepted solution]

Use DAX Studio to examine the query plans.  Try to do some pre-aggregations to get the number of records down.

[Anonymous]

Hi, @ERing 

I wish you all the best. Previously we have provided a solution to help you solve the problem. Since we haven't heard back from you yet, I'd like to confirm if you've successfully resolved this issue or if you need further help?
If yes, you are welcome to share your workaround and mark it as a solution so that other users can benefit as well. If you find a reply particularly helpful to you, you can also mark it as a solution.
If you still have any questions or need more support, please feel free to let us know. We are more than happy to continue to help you.
Thank you for your patience and look forward to hearing from you.

Best Regards

Jianpeng Li

[Anonymous · Accepted solution]

Hi, @ERing 

First of all, the slow loading speed is mainly caused by your too much data and not being filtered to a certain extent, so try to avoid unnecessary columns on the visual. Then, try adding some dimension filtering to make sure you're not loading a lot of data on one visual.
You can also refer to SQL BI's report slow analysis video to apply it to your reports:

Analyzing a slow report query in DAX Studio - SQLBI

Optimizing card visuals in slow Power BI reports - SQLBI

Best Regards

Jianpeng Li

If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.

[lbendlin · Accepted solution]

Use DAX Studio to examine the query plans.  Try to do some pre-aggregations to get the number of records down.