PostgreSQL to Power BI Service without on premise gateway 4 Azure

[iglesias6]

Hello! How are you?

I have Azure, inside Azure I have a Virtual Machine where we installed a PostgreSQL. Now I am connecting in Power BI to this potgres Database, and I am using the On Premise Data Gateway for the scheduled refresh. Is there a way to have a Cloud Connection instead? How?

Currently I am using this way to get the data:

In order to do the Cloud Connection, how should I do it? In case this is not possible please let me know and the reason if you know it!

Thanks a lot in advance!

Regards

[lbendlin]

Be aware that there is currently a bug preventing setting up scheduled refreshes for Azure PostGreSQL databases. Allegedly being worked on.

[lbendlin · Accepted solution]

Instead of creating your own PostGreSQL database you would need to use the Azure offering.

Azure Database for PostgreSQL | Microsoft Azure