Forum Discussion

Anonymous's avatar
Anonymous
Not applicable
4 years ago
Solved

Handling source column changes in Direct Query

I have created a Power BI report using direct query mode on a RDBMS source. Some of the underlying columns in the source in the source have undergone a change in name and the report is breaking. I don't see any option to change the name in Power Query Editor or anywhere else in Power BI desktop to the latest column names. Can you let me know if there is a workaround?

Need Help
  • amitchandak's avatar
    amitchandak
    4 years ago

    Anonymous , Open Power Query, Right click on Table, Advance Editor, Check the steps where that name has been used try to change it there

     

    Optional

    then add a step to rename, so you do have to change if there are more steps post that

1 Reply

  • amitchandak's avatar
    amitchandak
    Icon for Super User rankSuper User
    4 years ago

    Anonymous , Open Power Query, Right click on Table, Advance Editor, Check the steps where that name has been used try to change it there

     

    Optional

    then add a step to rename, so you do have to change if there are more steps post that