How to Publish PowerBI report with Azure PostGres flexible server Database

Rajeev Kumar Dave 21 Reputation points
2024-06-20T12:21:48.9633333+00:00

I have created Power BI report connecting MS Postgres Flexible server on prem using Vnet . But when I am publishing it is on Cloud it is giving us error or not able to connect,

Azure Database for PostgreSQL
{count} votes

1 answer

Sort by: Most helpful
  1. GeethaThatipatri-MSFT 28,852 Reputation points Microsoft Employee
    2024-06-21T21:00:29.22+00:00

    @Rajeev Kumar Dave There is a new PostgreSQL connector for the virtual network data gateway you can use to connect to Power BI.

    To use this connector with vnet data gateways, you have a few options. With Power BI Desktop, you can connect and then publish. Then, log in online and create a dataset from your published file. You can enable this dataset with vnet data gateways. Refer to the below blog for step-by-step instructions on how to do this.

    The vnet data gateway is only compatible with PBI datasets, paginated reports (and there are future plans to connect to dataflows)

    PostgreSQL connector for the virtual network data gateway

    Regards

    Geetha

    0 comments No comments