How connect power bi desktop to data gateway inside vm

[Anonymous]

We have setup a postgre database in azure which is connected over a private endpoint to a vpn gateway. Now we want to access this database with power bi desktop. So basically we know, that we have to create a data gateway inside a virtual machine, which is in the same subnet/network as the database. But what next? How can we use this data gateway with power bi desktop? We don't want to use power bi desktop inside the virtual machine, but with our local machines. So there are multiple local machine which should be connected with a local power bi desktop to the data gateway (virtual machine).

When i start power bi desktop and click on "connect to postgre database", power bi desktop needs a server name and (optional) the database name.

See this picture:

[Icey · Accepted solution]

Hi @Anonymous ,

---

So basically we know, that we have to create a data gateway inside a virtual machine, which is in the same subnet/network as the database. 

---

This gateway is used to refresh data in Power BI Service, not for Power BI Desktop.

For connecting to a Postgre Database in Azure using Power BI Desktop on local machine, please refer to these posts:

Create Power BI Connection to Azure SQL Database (mssqltips.com);

Connecting Power BI to PostgreSQL on Azure - DEV Community.

Best Regards,

Icey

If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.

[Anonymous]

Hi Icey, this is a partial response.

Its missing the important part, how would users connect to data source using the data gateway via Power Bi Desktop CLient using their own machines?

Q1- Could Power BI Desktop connect to Bi Data Gateway which in turns connects to data source?

Note - direct connection to source is denied.

Q2- Could we keep the BI Data Gateway in App Tier?

Anyone, any ideas?