Card taking more than 60 seconds to load when slicer value changed

[sharath_15]

Total records in the source table used in power bi: 283Million (data for 6 quarters including 2024-Q2)
Records in 2024-Q2: 20 Million
Datasource: Databricks
Input method: Direct query method.

Problem:
              Card showing sum aggregate of sales column for 2024-Q2 takes 60 seconds refresh upon change in slicers in power BI.

Please help me on this.

[Anonymous · Accepted solution]

Hi @sharath_15 

Here are a few steps to help improve the performance:

1. Optimize DAX Queries: Ensure that the DAX query used for the card visual is optimized for performance. Avoid using complex calculations directly in the visual and consider pre-calculating measures if possible. For more insights on optimizing DAX, you might find this documentation helpful:
   Improve Power BI Performance by Optimizing your DAX | by MAQ Software | MAQ Software | Medium
   Optimizing DAX expressions involving multiple measures - SQLBI
   
   

2. Use Performance Analyzer: The Performance Analyzer in Power BI Desktop can help identify which part of your report is causing the delay. It can provide insights into the DAX query processing time, visual display time, and other factors contributing to the slow performance. Here's how you can use it: Use Performance Analyzer to examine report element performance in Power BI Desktop - Power BI | Micr...

Best Regards,

Jayleny

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