Using a Column with reserved words inside ODBC connector

[RaphaelPavanBR]

Could someone help me?

I am using ODBC connector to use a server where I query the following:

Fonte = Odbc.Query("dsn=default-server", "select "from".taxid from clients")

I have this database in which I am only a user and can't change the column names, so that is not an option.

I found in another forum that using #"" could solve the problem, but I already tried:

[#"from"].taxid

["from"].taxid

[from].taxid

"from".taxid

#"from".taxid

But power bi keeps returning the same error: "the ',' token was expected". 

The query works when I run it in a SQL only environment using "from".taxid, but Power Bi is not accepting it 😞

[RaphaelPavanBR · Accepted solution]

After weeks of struggle I finally found out a solution.

One should use double double quotes to achieve what I wanted. Such as:

""from"".taxid

I found it really unusual and not friendly at all, but at least solved my problem.

[Anonymous]

Hi  @RaphaelPavanBR ,

You might consider using double quotes or square brackets to escape reserved words

Odbc.Query("dsn=default-server", "select \"from\".taxid from clients")

OR

Odbc.Query("dsn=default-server", "select [from].taxid from clients")

This is the related document, you can view this content:

sql - How to escape double quotes in a column name when querying Excel file using ODBC - Stack Overf...

blog.crossjoin.co.uk

Best Regards,

Liu Yang

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

[RaphaelPavanBR]

Neither of your formats worked. Both gave the same error.

Brackets:

counter bars with double quotes: