Forum Discussion

Anonymous's avatar
Anonymous
Not applicable
5 years ago

ODBC connection and automatic data refresh - Power BI Service

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!