cancel working-on-it without end tasking

[Anonymous]

is there way to cancel "working on it" without having to end task power bi ? 

its hanging for ever. something blocking it and i dnt want end task.  

[TravelMan]

If your working with an online power bi services dataset or potentially other sources within power bi desktop. When it gets into Working on it endless loop. I disable the Network Adaptar and cut the internet this often forces power bi out of the loop and the ability to tweak the calclulation before re-enabling the adapter. Seems a less frustrating method than task manager and restarting.

[v-robertq-msft · Accepted solution]

Hi, @Anonymous 

If you just hang it in the background, Power BI will occupy the computer's Dynamic Memory, which is unavoidable. What’s more, Power BI has certain requirements for memory. I don't recommend you to hang more than one Power BI process in the background at the same time, which will cause your computer to run slowly.

You can refer to this link for some tips for optimizing Memory Usage in Microsoft Power BI:

https://www.linkedin.com/pulse/ten-techniques-optimising-memory-usage-microsoft-power-dejan-pajk

More info about Dynamic Memory

Best Regards,

Community Support Team _Robert Qin

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

[tracyosimowicz]

Nothing against poster, but there are so many posts in this community with "Solutions" that are not actually solutions and it is quite frustrating to sort through. I feel like only 10% of posts I read does the marked solution actually contain a relevant answer to the question.

[amitchandak]

@Anonymous , see if this blog can help

https://www.thebiccountant.com/2019/04/27/cancel-power-query-refreshes-fast/