Remove offending column from Power Query

[Daryl_K]

This seems like it should be a super-easy thing to do, and maybe it is and I'm having a brain stall, but one of the many sources for my Power BI report was recently modified to remove a column. No worries, since I wasn't using that particular column anyway, so I want to permanently delete it from my power query, but all I get is this error and the inability to edit the power query.

I deleted the offending column from the table that was pulling from this source, but refresh still fails because it seems the query itself is still looking for the missing column.

What am I missing?

[Greg_Deckler · Accepted solution]

@Daryl_K Use Advanced Editor to find the reference to the column and remove the reference. You can copy and paste into Notepad and search for it.

[Daryl_K]

Thanks!