Showing results for 
Search instead for 
Did you mean: 

Fabric is Generally Available. Browse Fabric Presentations. Work towards your Fabric certification with the Cloud Skills Challenge.

Post Prodigy
Post Prodigy

Stop calculations

So I made an error. I created a union combined with generate. The table doesn't have a lot of unique values, but does have a massive amount of records (6 milion). 

The Problem? I've forgot to put a 'distinct' on the column that has not a lot of unique values. So I'm now waiting on 6 milion x 6 milion generate. The other part of my problem is that my laptop is quite strong so it might take a long time for it to get to the point 'do it yourself, it is to big for me'. 

Anyway in killing the calculations without closing the file (without saving)?

Advocate I
Advocate I

A kill switch is needed to handle mistakes made when writing DAX expressions. Anybody know of any related ideas?

Community Support
Community Support

Hi @DouweMeer 

So far, there is no such option in Power BI which can stop the calculation and keep the file.

You can close the file or end task in Task Manager.


Some tips when you use the calculation in a large data.


Best Regards


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

I just killed one of the task manager processes that held the calculation. It didn't crash, but it threw an error when I tried to save it. That was too bad. Perhap I can kill one of the other processes next time...

Post Prodigy
Post Prodigy

Yes yes, still running. It sits now on 23.2 GB memory out of 31.8 GB. Anyone know the trick?

And it is still running... it is on 27 GB...

This is goning to take ages :(. 

It just won't stop.... 

Helpful resources

PBI November 2023 Update Carousel

Power BI Monthly Update - November 2023

Check out the November 2023 Power BI update to learn about new features.

Community News

Fabric Community News unified experience

Read the latest Fabric Community announcements, including updates on Power BI, Synapse, Data Factory and Data Activator.

Power BI Fabric Summit Carousel

The largest Power BI and Fabric virtual conference

130+ sessions, 130+ speakers, Product managers, MVPs, and experts. All about Power BI and Fabric. Attend online or watch the recordings.

Top Solution Authors
Top Kudoed Authors