Forum Discussion
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?
The Dax shows as below :
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
4 Replies
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
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?
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