Error Message Applying Query Changes

[evang550]

Any idea what this error is about? I got it after renaming some columns in the query editor...

[v-huizhn-msft]

Hi @evang550,

You changed the name in Edit Quey by Quey statement? Based on the error message, is there a variation in your Query statement?

As I tested, you can rename the column header name by the following solutions.

1. Double click the column header, it will become modifiable state. Then you can change it.

 

2. Type the following bold Query statement to rename it, don't forget add the comma.

let
    Source = Table.FromRows(Json.Document(Binary.Decompress(Binary.FromText("i45W8krMU9JRckwuySzLLKk0BLINlWJ1opXcUpPQxI3A4qjqjYBsUyzqQeImWNQbA9lmWNSDxA0NlGJjAQ==", BinaryEncoding.Base64), Compression.Deflate)), let _t = ((type text) meta [Serialized.Text = true]) in type table [Month = _t, Activity = _t, Value = _t]),
    #"Renamed Columns" = Table.RenameColumns(Source,{{"Month", "MonthMonth"}})
in
    #"Renamed Columns"

Please review your operation according to the steps above, and check if works fine.

Best Regards,
Angelia 

[parry2k]

not familiar but wondering after you changed the column name, did you looked at all the steps in query to make sure everything is good.