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.

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.