Forum Discussion
Powerbi with odbc Postgres
I'm using powerbi and postgres 9.4. I downloaded psqlodbc_15, created dsn.
The dsn test is ok! But when I'm in powerbi and choose the odbc, the authentication, password and user error message appears.
Is there any configuration I need to do?
1 Reply
Hi lindembergpe -If still issue exists , please check your pg_hba.conf file on the PostgreSQL server to ensure that it allows connections from your client IP address with the correct authentication method.
Ensure that the version of the ODBC driver is compatible with PostgreSQL 9.4. Although you are using psqlodbc_15, which should generally work, compatibility issues can sometimes arise.
Enabling DirectQuery for an ODBC-based Power Query connector - Power Query | Microsoft Learn
Did I answer your question? Mark my post as a solution! This will help others on the forum!
Appreciate your Kudos!!
