Forum Discussion
performance optimisation for table visual
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
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
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.