Register now to learn Fabric in free live sessions led by the best Microsoft experts. From Apr 16 to May 9, in English and Spanish.
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)?
A kill switch is needed to handle mistakes made when writing DAX expressions. Anybody know of any related ideas?
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.
https://stackoverflow.com/questions/36911569/how-to-stop-calculation-in-power-pivot
Best Regards
Maggie
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...
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....
Covering the world! 9:00-10:30 AM Sydney, 4:00-5:30 PM CET (Paris/Berlin), 7:00-8:30 PM Mexico City
Check out the April 2024 Power BI update to learn about new features.
User | Count |
---|---|
109 | |
99 | |
77 | |
66 | |
54 |
User | Count |
---|---|
144 | |
104 | |
102 | |
87 | |
64 |