Forum Discussion

cerequena's avatar
cerequena
New Member
4 years ago
Solved

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 ...
Tips and Tricks
  • cerequena's avatar
    cerequena
    4 years ago

    I discovered that PosgreSQL requires double quotes around all column names to avoid errors.

    This solves the issues. Thank you.

Anonymous's avatar
Anonymous
Not applicable
4 years ago

cerequena 

 

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 Community

PostgreSQL Major: "OLE DB or ODBC error: [Expression.Error] We couldn't fold the expression to the data source. Please try a simpler expression.." · Issue #1 · sgoley/DirectQuery-for-ODBC-in-PowerBI · GitHub

 

 

Paul Zheng _ Community Support Team
If this post helps, please Accept it as the solution to help the other members find it more quickly.