Special Character in Column Name

[Junaid11]

Hello,

I have few columns which have special characters in them. I tried creating a custom column based on column with special character in its name but it did not allow me to do that in Power query. My code was below:

Text.Combine( List.Distinct( List.Transform([Check][Work?], Text.Trim)),",")

I cannot change the column name. Is there a way that I can use this column name of Work? with special character. Help would be highly appreciated.

Thank you 

[Danalber]

Hi,

I had a similar issue today and the solution above didn't work. After many try and errors the solution in my case was very easy.

In the power query the column name with the special character, "#" in my case, just needed to be set in a double quote.

SELECT TRANSACTION_ID, TRANSACTION_TYPE, ""COMMENTS#1"" FROM PROD_DB.PO.RCV_TRANSACTIONS

The single quote '' and squared brakes [] both didn't work in the power query.

Hope this might be useful to someone at some point. Wasted quite a bit time today. 🙂

BR

[watkinnc · Accepted solution]

[#"Work?"] instead of [Work?] will work.

--Nate