ODBC connection and automatic data refresh - Power BI Service

[Anonymous]

Hi there, 

I have the following issue: 

I need to connect to a PostgreSQL-database in AWS via a SSH-tunnel. I have managed this locally (in Power BI Desktop) by setting up the SSH tunnel in the command prompt and connecting via the localhost and an ODBC in Power BI Desktop. I can now manually refresh the data in the desktop app. 

Now I want to publish this to Power BI service and obviously set up an automatic data refresh. How can I manage to set up the same here? With an SSH-tunnel etc.?

Thank you in advance!

[v-yiruan-msft]

Hi @Anonymous ,

Please review the content in the following threads, hope they can help you.

Installing Power BI Data Gateway For Refresh of PostgreSQL Database

Connecting to PostgresSQL hosted on AWS RDS?

Best Regards