Forum Discussion

Icon for Post Prodigy rank

Post 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?

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.

3 Replies

Fowmy
Super User
5 years ago
Analitika

You can use within square brackets without quotes as follows

Tablename[ name.1]
- Analitika
  Post 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
    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.

Related content