Forum Discussion

Juvin's avatar
Juvin
New Member
7 years ago

Postgresql connection using ODBC

Hi, I dont  how to connect postresql live db using ODBC.Tired to connect using ODBC but after publishing to power bi service the data is not refreshing automatically in service .can anyone help with...
Need Help
v-jiascu-msft's avatar
v-jiascu-msft
Microsoft Employee
7 years ago

Hi Juvin,

 

Did ODBC support live connection?

No, it doesn't support live connection directly.

 

How to connect Postgresql using ODBC?

Using the ODBC connector. 

 

 

Did ODBC need gateway setup?

Yes.

 

How to setup gateway for ODBC?

Please refer to the snapshot below. If it's a gateway (personal-mode), you just need to update the credential). If it's the other gateway, you need to add a data source in the Gateway settings. Please refer to the snapshots below.

postgresql

Postgresql-connection-using-ODBC

 

 

Did I need to setup anything in power bi service for ODBC?

Yes, set up the gateway information. 

 

 

Best Regards,
Dale