Forum Discussion

Analitika's avatar
Analitika
Icon for Post Prodigy rankPost Prodigy
5 years ago
Solved

SQL error in Power BI advanced editor

Hello,   How to select table column when column name contains dot . I tried to use 'name.1' but still getting error. How to resolve it?
Need Help
  • Anonymous's avatar
    Anonymous
    5 years ago

    Hi Analitika 

    I could reproduce the issue like yours. My column name in SQL is [Name.1], Power BI seems that couldn't identify the column name with dot.

    I think you could try to rename the column name in SQL. If you replace "." by "_",it works well.

     

    Best Regards,
    Rico Zhou

     

    If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.

Fowmy's avatar
Fowmy
Icon for Super User rankSuper User
5 years ago

Analitika 

You can use within square brackets  without quotes as follows

Tablename[ name.1]

  • Analitika's avatar
    Analitika
    Icon for Post Prodigy rankPost Prodigy
    5 years ago

    Still not helped, I am getting similar error like: DataSource.Error: ODBC: ERROR [42601] ERROR: syntax error at or near "["; when I have tried to use a bracket - [name.1] for example.

    • Anonymous's avatar
      Anonymous
      Not applicable
      5 years ago

      Hi Analitika 

      I could reproduce the issue like yours. My column name in SQL is [Name.1], Power BI seems that couldn't identify the column name with dot.

      I think you could try to rename the column name in SQL. If you replace "." by "_",it works well.

       

      Best Regards,
      Rico Zhou

       

      If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.