cancel
Showing results for 
Search instead for 
Did you mean: 
Reply
LPD280388
Helper III
Helper III

performance optimisation for table visual

Hi team,

I need a help in improving the performance of a table visual that i have in my report. 

 

I dont have any measure or calculated column in the table.  Just 3 columns added in Values section of the visual.   But still it takes 3975 ms for rendering.  Anything do you suggest to improve this dax?

 

LPD280388_0-1618505056563.png

 

The Dax shows as below : 

 

LPD280388_1-1618505293319.png

 

 

 

1 ACCEPTED SOLUTION
aj1973
Community Champion
Community Champion

@LPD280388 

The process for the visuals to load is controled by Power Bi engine (Backend), you can't controle that nor priotirize one before the other. The user can only controle the performance of the DAX and the display of the visual. What the video is trying to present is how to normalise some visuals and to reduce the number of visuals inside one page. 

I would recommend to reduce some visuals from the first page and introduce Bookmarks and Drillthrough to call for the other visuals into other pages.

Here is an example of using buttons for Bookmarks and Drillthroughs

https://app.powerbi.com/view?r=eyJrIjoiMmFhYWVlMDUtYTk3My00Y2U2LTgwMWEtZDQwNjAyNmQwNjc5IiwidCI6IjgzN...

 

Regards
Amine Jerbi

If I answered your question, please mark this thread as accepted
and you can follow me on
My Website, LinkedIn and Facebook

View solution in original post

4 REPLIES 4
aj1973
Community Champion
Community Champion

Hi @LPD280388 

The good thing is that you don't have issues with DAX nor the visual. You have a consuming time in Other. Please watch this video to know what Other can refer to in your report. It could be time waiting for other visuals to execute.

https://www.youtube.com/watch?v=wNNemTpA9Vo

 

Regards
Amine Jerbi

If I answered your question, please mark this thread as accepted
and you can follow me on
My Website, LinkedIn and Facebook

@aj1973  Thanks for your response.   I did go through this video multiple times. But in my situation. I have few buttons and then 7 tables. in one of the table above attached is the Dax query gets generated when performance analyser is turned on.

 

How do i reduce the time that these tables run for and is there way to tell the powerbi to run a particular visual first among other visuals? 

aj1973
Community Champion
Community Champion

@LPD280388 

The process for the visuals to load is controled by Power Bi engine (Backend), you can't controle that nor priotirize one before the other. The user can only controle the performance of the DAX and the display of the visual. What the video is trying to present is how to normalise some visuals and to reduce the number of visuals inside one page. 

I would recommend to reduce some visuals from the first page and introduce Bookmarks and Drillthrough to call for the other visuals into other pages.

Here is an example of using buttons for Bookmarks and Drillthroughs

https://app.powerbi.com/view?r=eyJrIjoiMmFhYWVlMDUtYTk3My00Y2U2LTgwMWEtZDQwNjAyNmQwNjc5IiwidCI6IjgzN...

 

Regards
Amine Jerbi

If I answered your question, please mark this thread as accepted
and you can follow me on
My Website, LinkedIn and Facebook

View solution in original post

@aj1973 Yes. Reducing the Visuals made a great impact on the performances. I had around 40 single card visuals and 2 multi row card which were brought down to 7 table visual which improved the performance.   thanks a lot for the reply.

Helpful resources

Announcements
PBI User Groups

Welcome to the User Group Public Preview

Check out new user group experience and if you are a leader please create your group!

MBAS Attendee Badge

Claim Your Badge & Digital Swag!

Check out how to claim yours today!

secondImage

Are You Ready?

Test your skills now with the Cloud Skills Challenge.

Top Solution Authors