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?
Asked
Active
Viewed 224 times
0
-
Ask the owner of the database, he/she can tell you how you can get access to the data. – Frank Heikens Dec 13 '21 at 14:09
-
@FrankHeikens we are the owner of the database but as we are having firewall around the db that direct connection is not possible – Sonali Bisht Dec 17 '21 at 04:27
-
Please clarify your specific problem or provide additional details to highlight exactly what you need. As it's currently written, it's hard to tell exactly what you're asking. – Community Dec 19 '21 at 11:07
1 Answers
0
There are some major steps when importing the data into Power BI from Azure Database for PostgreSQL.
- Install the ODBC driver
- You have to add a rule to the firewall (inbound rule).
Refer https://niftit.com/connecting-power-bi-to-postgresql/ for more detailed explanation.
Utkarsh Pal
- 4,079
- 1
- 5
- 14
-
Is there any other way to connect to the database, other than adding an exception in the firewall as we want to host the power bi reports on private IPs – Sonali Bisht Dec 17 '21 at 04:26
-