topic Re: SQL error in Power BI advanced editor in Developer

SQL error in Power BI advanced editor

Analitika — Mon, 06 Sep 2021 05:59:15 GMT

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?

Re: SQL error in Power BI advanced editor

Fowmy — Mon, 06 Sep 2021 07:32:41 GMT

@Analitika

You can use within square brackets without quotes as follows

Tablename[ name.1]

Re: SQL error in Power BI advanced editor

Analitika — Mon, 06 Sep 2021 07:35:35 GMT

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.

Re: SQL error in Power BI advanced editor

Anonymous — Wed, 08 Sep 2021 09:45:02 GMT

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.