postgresqlazurepowerbifirewalldata-collection

How to fetch data from Postgres db behind firewall for power bi report

I am having my data on Postgres DB on Azure behind the firewall. Because of firewall it is not possible to import data in Power bi. I want to publish the report on https://app.powerbi.com/. Any suggestion how this can be done?

Solution

  • There are some major steps when importing the data into Power BI from Azure Database for PostgreSQL.

    1. Install the ODBC driver
    2. You have to add a rule to the firewall (inbound rule).

    Refer https://niftit.com/connecting-power-bi-to-postgresql/ for more detailed explanation.