Schema Change - Now What? Please Help!

[irnm8dn]

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!

[v-yuta-msft · Accepted solution]

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

[Stachu]

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.