Calculated Table. Never Finishes. Working on it.

[dbeavon3]

I've noticed that getting data into a model via a calculated table (DQ for PBI dataset) is very problematic.

I plugged in my rough-draft DAX calculation, iterated until I was satisfied, then removed the filters to get the finalized output.  

After waiting for a while, I'm convinced that I need to cancel the calculation.  But I can't find a way to do that.  PBI desktop just says "working on it".

Worse yet, my RAM is filling up, and my network is running at 30 Mbps, and my PBI service is over-taxed and it is stealing all my "carry-forward" CU's.

How do I tell PBI desktop to stop what it is doing, short of killing the whole PBI desktop environment?
Can I kill the msmdsrv.exe?

I'm guessing Microsoft would say that this calculation operation is using "uncompressed data" or whatever.  What a pain....

Any help would be appreciated.  I think my next step is to kill msmdsrv.exe and see what happens to the desktop.

[dbeavon3]

Another thing that often crashes the calculated table is the fact that PBI can't seem to load more than one million rows from a PBI dataset hosted in the service.

Aside from the various things that cause the calculation to crash, there is no way to cancel the calculation from the user side.  I really think this calculation engine needs to have a cancel button.

[v-jialongy-msft]

Hi   @dbeavon3 

Thank you for your valuable suggestion on Power BI calculate table, if it is important to you, you can propose an idea about this, you can submit your idea by going to the link below:
Home (microsoft.com)

Best Regards,

Jayleny

If this post helps, then please considerAccept it as the solution to help the other members find it more quickly.

[dbeavon3]

For lack of a cancel button, how do people cancel the calculated table operation?

Do you kill something like msmdsrv?  Or do you interrupt the remote network connection?

[dbeavon3]

It eventually crashed on its own with a message like so:


There's not enough memory to complete this operation. Please try again later when there may be more memory available.
OLE DB or ODBC error: The operation was cancelled by the user.

If anyone knows how to kill this to cancel in a "Microsoft-supported" way , please let me know.