cancel
Showing results for 
Search instead for 
Did you mean: 
Reply
adetogni Established Member
Established Member

Pause/Stop recalculation. Is there any trick?

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?

4 REPLIES 4
Community Support Team
Community Support Team

Re: Pause/Stop recalculation. Is there any trick?

hi, @adetogni 

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

 

Community Support Team _ Lin
If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.
adetogni Established Member
Established Member

Re: Pause/Stop recalculation. Is there any trick?

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

Community Support Team
Community Support Team

Re: Pause/Stop recalculation. Is there any trick?

hi, @adetogni 

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

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

Community Support Team _ Lin
If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.
Highlighted
adetogni Established Member
Established Member

Re: Pause/Stop recalculation. Is there any trick?

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

Helpful resources

Announcements
Virtual Launch Event

Microsoft Business Applications October Virtual Launch Event

Join us for an in-depth look at the new innovations across Dynamics 365 and the Microsoft Power Platform.

Power BI Helps Homeless and Trouble Youth

Power BI Helps Homeless and Trouble Youth

We spoke with Power BI Super User, Greg Deckler, about his charity work

MBAS Gallery

Watch Sessions On Demand!

Continue your learning in our online communities.

Users Online
Currently online: 33 members 795 guests
Please welcome our newest community members: