Pause/Stop recalculation. Is there any trick?

[Anonymous]

Hi

I'm at this point quite experienced in DAX, to the point that my model contains many relationships and 3 complex precalculated tables (so the visuals for the final user are quick and snappy).
However, this has a major drawback: EACH time that I 

- create a new column

- add a new measure

- rename a measure/column

- pretty much any other modification of the model

recalculates the ENTIRE model. I stay there literally 1 minute or so each time I have to make a modification. Plus everything is very sluggish. As this model is far from complete, this is slowing down a lot my work.

So I would really love a feature, like in excel, "hey, wait a minute to recalculate everything, let me create these 3-4 new measures, and then you can recalculate". I know that there is an idea (I voted for it) but with 3 votes does not seem popular.

Is there therefore any "trick" to avoid recalculation? What I do now is to comment out each of the three main calculated tables and then start working: this of course messes up al the visuals because the calculated tables are not anymore there. 

But I would really love a feature to speed up working with large models....any idea?

[StefanC]

I was experiencing the same issue and just found 'Tabular Editor'. It allows me to change the data model without recalculation each time. Take a look at: https://tabulareditor.com/

[v-lili6-msft]

hi, @Anonymous 

For your case, I think the best way is in Edit Queries, Add some filter for data set to reduce the size of the data model just for modeling process. Then remove the filter after that.

Best Regards,

Lin

[Anonymous]

Hi

thanks, i found an somewhat easier solution: save the model as .pbit so it has no data in it. Modify the queries and then reload the data. It helps, but even when the dataset is empty, if you have several relationships and calculated tables it still recalculates after each measure. Of course, without data is faster...

[v-lili6-msft]

hi, @Anonymous 

It's also a great way to achieve it. Thank you for your sharing.  

Could you please tell me if you still have other problem? If not, could you please mark the helpful replies as Answered?

Best Regards,

Lin

[Anonymous]

Well, emptying the dataset only improve the issue, but does not resolve it. Still PBI recalculates everything and even with empty data set it still takes a lot when there are many relationship and calculated tables...