topic Re: Virtual gateway. PostreSql in Developer

Virtual gateway. PostreSql

kkk777 — Tue, 23 Jan 2024 18:07:27 GMT

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.

Re: Virtual gateway. PostreSql

Anonymous — Wed, 24 Jan 2024 10:02:32 GMT

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

Re: Virtual gateway. PostreSql

lbendlin — Wed, 24 Jan 2024 20:04:49 GMT

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

Re: Virtual gateway. PostreSql

kkk777 — Wed, 31 Jan 2024 11:42:41 GMT

Not a local, I using DigitalOcean hoster

Re: Virtual gateway. PostreSql

lbendlin — Wed, 31 Jan 2024 13:33:47 GMT

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