How to connect Power BI with Aurora - In Direct Query Mode

[Dhir_083]

Hi,

I have postgresql DB hosted on Aurora and to connect with Power BI, I am using ODBC but with ODBC we have only Import mode option. Do we have any work around to connect directly with Aurora and specially in Direct Query mode?

I appreciate if there is any work around.

Thanks!

[amitchandak]

@Dhir_083 , Try the PostgreSQL connector if that can help

do not miss any setting

https://community.powerbi.com/t5/Power-Query/Connecting-to-PostgresSQL-hosted-on-AWS-RDS/td-p/135666
https://dataintoresults.com/post/powerbi-and-postgresql-ssl-lets-encrypt-and-gateway/

[Dhir_083]

Hi @amitchandak ,

This is not working actually, I have tried this earlier.

Thank you!