Forum Discussion

BeanieMan's avatar
BeanieMan
Regular Visitor
2 years ago

unable to Edit Power Query Applied Steps

Hi,

 

I have Power Query Version "2.127.277.0 64-bit" and for some reason I can no longer edit existing applied steps in Power Query.

 

Scenario:

I am just bringing in a simple Excel sheet

Remove nulls from a column

Close and Load

 

When i re-enter Power Query I can no longer edit the Applied Steps I just created. They appear greyed out but no clickable?

 

Can anybody help?

Need Help

5 Replies

  • Anonymous's avatar
    Anonymous
    Not applicable
    2 years ago

    Hi BeanieMan ,

    Do you mean here? For some steps without UI, you need to edit the m-code in the code bar or in the advanced editor.

    If there is any post helps, then please consider Accept it as the solution  to help the other members find it more quickly.
    If I misunderstand your needs or you still have problems on it, please feel free to let us know. Thanks a lot!

    How to get your questions answered quickly --  How to provide sample data in the Power BI Forum -- China Power BI User Group

  • BeanieMan's avatar
    BeanieMan
    Regular Visitor
    2 years ago

    Hi,

     

    Thanks for the replies ... Here is a screen shot...The existing Applied Steps cannot be edited or clicked on.... It is not that some steps are only editible via M Script as i have been using these in this way for years from the same Excel source and they have have always been editible... Thanks

     

     

    • ronrsnfld's avatar
      ronrsnfld
      Super User
      2 years ago

      Are you able to edit the Excel worksheet?

      Are you able to enter the Advanced Editor in Power Query?

      Are you able to edit the formula bar in Power Query?

    • mahenkj2's avatar
      mahenkj2
      Solution Sage
      2 years ago

      Hi BeanieMan ,

       

      Just for testing, can you use the same Excel source in another power BI file, just to make sure if it's happening after a version update.

       

      Hope it helps.

       

      P.S.-I believe that all applied steps are greyed out, but in image you shared they appear not so. May be It's not that clear to me.