Reloading pages

[Anonymous]

hi all,

I have a question related to the reloading with the pages in power bi. Is not related to the gateway or something like that. Is related to the reloading with you are moving whith different pages in the same dashboard. Seems like every page is loaded when you are opening only the page that you are consulting but the question is, is it possible to load the hole dashboard only one time ? when is opened for the first time? Thats a typical thing when you are working with Qlik for example.

[Anonymous · Accepted solution]

If I understand what you are asking, is it possible to force all the visuals to load when the report is opened.

This is not possible at the moment, plus even if it was as soon as the report was interacted with it would have to recalculate the visuals with new DAX queries. 

If the underlying problem is that your visuals are taking too long to load/measures taking too long to run therea re some steps you can take to remedy this.

1. See if your measures are slow with DAX studio, see this blog post on how to do this https://www.sqlbi.com/articles/capturing-power-bi-queries-using-dax-studio/ 
2. Move calcuations into precalcuated columns/tables, either with DAX or Power Query. This will probably increase refresh time and in memory model size but it will mean that the measures run will be far simpler and therefore faster.
3. If you are using any complex custom visuals or R/Python visuals these can often take a long time to load as they are doing a lot of transformations. See if using other visuals still has the same performance issues.