Power BI Query - Using "&" in a variable name in Power Query

[bendsteel6]

Hi, 

I have an instance in a Power Query where I'm trying to read in a field that has an ampersand (&) in it.  I can't get around this as this is how it's name in the data source.  I've read many posts online and nothing seems to work.

select ...

,r.4oa_wheel_style_front

,r.0bx_wheel_type_drive

,r.02x_wheel_&_tire_diameter_drive

,r.01x_wheel_&_tire_diameter_front

from...

Is there any way around this?

Thanks!

[bendsteel6]

Hi,

I got it working using the 'single quote' from the tilde key (upper left on the keyboard) as opposed to the single-quote, double-quote key.  The #"" was not working.

Thanks for your response anyway.

[lbendlin]

This is SQL code.  What does your Power Query code look like?  Funny characters are escaped via #"", so for example 

#"01x_wheel_&_tire_diameter_front"