Error handling on advanced editor?

[StephenF]

Sometimes Column 2 here exists sometimes and sometimes is doesnt.

I want powerbi not to error out on refresh if it doesnt exist, how to do this?

#"Removed Columns" = Table.RemoveColumns(#"Changed Type1",{"Source.Name", "Column2"}),

[camargos88 · Accepted solution]

@StephenF ,

You can use the function "Remove Other Columns", so you delete all the columns except those you are selecting.

[vanessafvg]

you can first probably check if the column exists before you remove it

chris web has a way of check if a column exists

let
Source = Csv.Document(File.Contents("C:\MissingColumnDemo.csv"),[Delimiter=",",Encoding=1252]),
PromotedHeaders = Table.PromoteHeaders(Source),
CheckColumns = Table.HasColumns(PromotedHeaders, {"Column2"})
in
CheckColumns

https://blog.crossjoin.co.uk/2015/07/08/checking-columns-are-present-in-power-query/

or something like this

to which you add a custom column to your m query, and adapt this if statement to your requirements

https://social.technet.microsoft.com/Forums/en-US/87affbc4-364f-470a-80ee-c35d32f1d331/is-there-a-wa...

AddedCustom = if List.Contains(Table.ColumnNames(PreviousStepName), "Column2") then PreviousStepName else Table.RemoveColumn(PreviousStepName, "Column2", each ...