Skip to main content
cancel
Showing results for 
Search instead for 
Did you mean: 

Get certified in Microsoft Fabric—for free! For a limited time, the Microsoft Fabric Community team will be offering free DP-600 exam vouchers. Prepare now

Reply
PavBidani
Helper II
Helper II

Performance Analyzer / Dax Studio

Hello All,

Happy New Year!

Some of the tiles in my report are taking too long to render.

I have exported data from Performance Analyzer and imported it into Dax Studio.

I will greatly appreciate suggestions on how to use Dax Studio to optimize queries / displays to improve performance.

Many Thanks,

Pav

1 ACCEPTED SOLUTION
Anonymous
Not applicable

Hi @PavBidani ,

I understand that you are experiencing slow rendering of tiles in your report and would like to optimize your queries and displays using Dax Studio.

 

Here are some tips that can help you improve the performance of your report:

  • Simplify your data model: Reducing the number of calculations and aggregations in your report can help reduce the amount of data that needs to be processed, resulting in faster loading times.
  • Remove unnecessary columns and measures: Removing columns and measures that are not needed in your report can also help reduce the amount of data that needs to be processed, resulting in faster loading times.
  • Optimize your queries: You can optimize your queries in Dax Studio by mitigating the presence of the CallBackDataID if ever they appear in your calculations. This will help improve DAX’s performance in generating accurate data. You can use error handling like ISERROR to catch potential errors before the calculation begins. You can also move filters to a CALCULATE statement and use MIN or MAX instead of date functions like LASTDATE.

 

These are some of the common causes for having a CallBackDataID and their mitigations .

 

How to Optimize Dax Queries in Power BI - Zebra BI

 

 

How to Get Your Question Answered Quickly 

 

If it does not help, please provide more details with your desired output and pbix file without privacy information (or some sample data) .

 

Best Regards
Community Support Team _ Rongtie

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

 

 

 

 

View solution in original post

1 REPLY 1
Anonymous
Not applicable

Hi @PavBidani ,

I understand that you are experiencing slow rendering of tiles in your report and would like to optimize your queries and displays using Dax Studio.

 

Here are some tips that can help you improve the performance of your report:

  • Simplify your data model: Reducing the number of calculations and aggregations in your report can help reduce the amount of data that needs to be processed, resulting in faster loading times.
  • Remove unnecessary columns and measures: Removing columns and measures that are not needed in your report can also help reduce the amount of data that needs to be processed, resulting in faster loading times.
  • Optimize your queries: You can optimize your queries in Dax Studio by mitigating the presence of the CallBackDataID if ever they appear in your calculations. This will help improve DAX’s performance in generating accurate data. You can use error handling like ISERROR to catch potential errors before the calculation begins. You can also move filters to a CALCULATE statement and use MIN or MAX instead of date functions like LASTDATE.

 

These are some of the common causes for having a CallBackDataID and their mitigations .

 

How to Optimize Dax Queries in Power BI - Zebra BI

 

 

How to Get Your Question Answered Quickly 

 

If it does not help, please provide more details with your desired output and pbix file without privacy information (or some sample data) .

 

Best Regards
Community Support Team _ Rongtie

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

 

 

 

 

Helpful resources

Announcements
OCT PBI Update Carousel

Power BI Monthly Update - October 2024

Check out the October 2024 Power BI update to learn about new features.

September Hackathon Carousel

Microsoft Fabric & AI Learning Hackathon

Learn from experts, get hands-on experience, and win awesome prizes.

October NL Carousel

Fabric Community Update - October 2024

Find out what's new and trending in the Fabric Community.