Advance your Data & AI career with 50 days of live learning, dataviz contests, hands-on challenges, study groups & certifications and more!
Get registeredGet Fabric Certified for FREE during Fabric Data Days. Don't miss your chance! Request now
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?
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!!
Proud to be a Super User! | |
Check out the November 2025 Power BI update to learn about new features.
Advance your Data & AI career with 50 days of live learning, contests, hands-on challenges, study groups & certifications and more!
| User | Count |
|---|---|
| 97 | |
| 74 | |
| 50 | |
| 47 | |
| 44 |