Forum Discussion

Anonymous's avatar
Anonymous
Not applicable
8 years ago
Solved

Schema Change - Now What? Please Help!

I needed to remove a field from my dataset (source).  

 

Power BI is failing to Refresh, obviously, because it is looking for this particular column - now no longer in the dataset.

 

Is there anyway through the Query Editor, to modify it looking for this particular column - and allow the refresh to continue?  The dataset remains the same, with the exception of this removed column.

 

 

Thanks!

Need Help
Show and Tell
  • v-yuta-msft's avatar
    v-yuta-msft
    8 years ago

    Hi irnm8dn,

     

    Click Advanced Editor and modify the M code in it. If the column [Creative size] name has been changed in your data source, you should also modify the column name in Advanced Editor.

     

    Regards,

    Jimmy Tao

2 Replies

  • Stachu's avatar
    Stachu
    Community Champion
    8 years ago

    you need to edit the steps that refer to that Column, and remove the references from Syntax - e.g. Changing Type, Reordering, Renaming, Unpivoting, Applying filters, etc.

  • v-yuta-msft's avatar
    v-yuta-msft
    Community Support
    8 years ago

    Hi irnm8dn,

     

    Click Advanced Editor and modify the M code in it. If the column [Creative size] name has been changed in your data source, you should also modify the column name in Advanced Editor.

     

    Regards,

    Jimmy Tao