Forum Discussion

james_pbi's avatar
james_pbi
Frequent Visitor
5 years ago
Solved

Working On It

When working in my data model, whenever I make any changes the "Working On It" box appears and stops me working for up to a minute. Is there a way to disable this - and have me accept any and all ch...
  • Pragati11's avatar
    5 years ago

    Hi james_pbi ,

     

    You can't disable "Working on It" window in Power BI.

    It is an indication for every change that you are making in your Power BI Desktop file.

    Also renaming columns in Power BI is a one-by-one step if you are not doing it in Power Query Editor.

    Therefore you rename a column/measure, Power then tries to apply those changes and hence that Working On It window appears. You can't do all changes in one go and then commit them.

     

    If you want to do this in one step, you can do this for columns in Power Query Editor by adding a "Table.RenameColumns" function in your existing M-code for your source.

    You can find details on this function here: https://docs.microsoft.com/en-us/powerquery-m/table-renamecolumns

     

    For renaming a Measure you still ned to do them one-by-one.

     

    Thanks,

    Pragati