Skip to main content
cancel
Showing results for 
Search instead for 
Did you mean: 

Find everything you need to get certified on Fabric—skills challenges, live sessions, exam prep, role guidance, and more. Get started

Reply
tkiwi
Frequent Visitor

Cancel "Working on it" dialog

 

Is there a way to cancel the process of adding a calculated column in Power BI when the "Working on it" message is displayed?

 

tkiwi_1-1716541496494.png

 

3 REPLIES 3
v-jingzhan-msft
Community Support
Community Support

Hi @tkiwi 

 

Currently, there isn't a direct method to cancel the process once it has started and the "Working on it" dialog is displayed. Power BI does not provide an explicit "cancel" button for this operation. The process is designed to complete the task it has begun to ensure data integrity and consistency within your model.

 

However, if you find that the operation is taking an unusually long time and you suspect it might be stuck or causing issues, you might consider the following steps as a workaround:

  1. Wait it out: Sometimes, complex calculations can take a significant amount of time, especially with large datasets.
  2. Force Quit Power BI Desktop: If the process seems to be stuck indefinitely, you might need to force quit Power BI Desktop. Please note, this should be a last resort as it can result in unsaved work being lost. To do this, you can use the Task Manager on Windows and end the Power BI Desktop task.
  3. Review and Optimize Your DAX Formula: Before attempting to add the calculated column again, review your DAX formula for any potential inefficiencies. Consider simplifying the formula or breaking it down into smaller, more manageable parts.

For future operations, it's a good practice to save your work before performing compute-intensive operations. This way, you can ensure that your progress is not lost in case you need to force quit the application.

 

Best Regards,
Jing
If this post helps, please Accept it as Solution to help other members find it. Appreciate your Kudos!

tkiwi
Frequent Visitor

 
The ESC key doesn't work, and stopping Power BI via Task Manager is not an ideal solution.
rajendraongole1
Community Champion
Community Champion

Hi @tkiwi - you can try with Esc key on your keyboard. This sometimes interrupts the process and cancels the operation.

or you can directly close the application and reopen it with saved changes will get added your report.

 

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

Helpful resources

Announcements
July 2024 Power BI Update

Power BI Monthly Update - July 2024

Check out the July 2024 Power BI update to learn about new features.

PBI_Carousel_NL_June

Fabric Community Update - June 2024

Get the latest Fabric updates from Build 2024, key Skills Challenge voucher deadlines, top blogs, forum posts, and product ideas.

Top Solution Authors