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

Question

Hi,&nbsp;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?&nbsp;I appreciate if there is any work around.&nbsp;Thanks!

amitchandak · Answer

Dhir_083 , Try the PostgreSQL connector if that can help 
&nbsp;
do not miss any setting
https://community.powerbi.com/t5/Power-Query/Connecting-to-PostgresSQL-hosted-on-AWS-RDS/td-p/135666https://dataintoresults.com/post/powerbi-and-postgresql-ssl-lets-encrypt-and-gateway/

dhir_083 · Answer

Hi&nbsp;amitchandak&nbsp;,&nbsp;This is not working actually, I have tried this earlier.Thank you!

Forum Discussion

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

2 Replies

Related content

RLS implementation under direct Lake connectivity

Power BI Direct Query (Live connection)

Connect Power BI with AWS Aurora PostgreSQL

Power BI Direct Connection to SAP HANA Production Database

Private Endpoint support for direct EventHub → EventHouse connection