topic Re: Using a Column with reserved words inside ODBC connector in Developer

Using a Column with reserved words inside ODBC connector

RaphaelPavanBR — Tue, 23 Jul 2024 18:19:49 GMT

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 😞

Anonymous — Wed, 24 Jul 2024 07:36:49 GMT

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

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

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

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

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 — Wed, 31 Jul 2024 16:57:58 GMT

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

Brackets:

counter bars with double quotes:

RaphaelPavanBR — Tue, 06 Aug 2024 14:53:02 GMT

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.