performance optimisation for table visual

[Anonymous]

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?

The Dax shows as below : 

[aj1973]

Hi @Anonymous 

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

[Anonymous]

@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 · Accepted solution]

@Anonymous 

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...

[Anonymous]

@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.