Forum Discussion
Using custom SQL via ODBC throws errors
We are trying to use custom SQL as a data source against PostgreSQL, using the latest, official ANSI and Unicode PostgreSQL drivers for Windows.
We are unable to customize the SQL statement beyond "Select * from table" - anything else throws ODBC errors.
Does anyone know of potential solutions?
I discovered that PosgreSQL requires double quotes around all column names to avoid errors.
This solves the issues. Thank you.
2 Replies
What is the error message? You can try find similar discussions for that specific error message. They usually have fixes in the replies.
e.g.
Solved: Getting Data from ODBC using SQL statement - Microsoft Power BI CommunityPaul Zheng _ Community Support Team
If this post helps, please Accept it as the solution to help the other members find it more quickly.I discovered that PosgreSQL requires double quotes around all column names to avoid errors.
This solves the issues. Thank you.
