Forum Discussion

bendsteel6's avatar
bendsteel6
Icon for Helper I rankHelper I
2 years ago

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

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!

Need Help

2 Replies

  • lbendlin's avatar
    lbendlin
    Icon for Super User rankSuper User
    2 years ago

    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"

  • bendsteel6's avatar
    bendsteel6
    Icon for Helper I rankHelper I
    2 years ago

    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.