Forum Discussion
Using a Column with reserved words inside ODBC connector
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 😞
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.
3 Replies
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:
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.
Neither of your formats worked. Both gave the same error.
Brackets:
counter bars with double quotes:
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.
