Virtual gateway. PostreSql

[kkk777]

I want use vurtual gateway for auto refresh my workspace. So, but I see that I will need have a subcription. But which subcription I don't understand. Which? Now I have only trial period.

Also If I will buy any subcription, can I connect to my server on PostgreSQL? Because Power BI Desktop can't connect directly, and I'm using ODBC. So, in virtual gateway I'll can't use ODBC.

[lbendlin]

Is your PostGreSQL database in the Azure cloud or on-premise?

[kkk777]

Not a local, I using DigitalOcean hoster

[lbendlin]

If it's not on Azure then you need to treat it as on-premise, and create a gateway in the same environment.

[v-yiruan-msft · Accepted solution]

Hi @kkk777 ,

Thanks for reaching out to us with your problem. Base on your description, you connected to PostgreSQL by ODBC connector and want to configure ODBC under virtual gateway in Power BI Server. However, it seems that it need some subscription and there is no ODBC data source option in virtual gateway. As the following official documentation refer: Virtual network data gateways is a Premium and Embedded feature, and will be available only in Power BI Premium workspaces, Premium Per User (PPU), and Power BI Embedded for public preview.

License types and capabilities

And virtual gateway only support the connectivity of the following data sources in current release:

You can refer the following documentation to connect to PostgreSQL in Power BI Desktop:

Power Query PostgreSQL connector - Power Query | Microsoft Learn

Best Regards