Forum Discussion
postgres.database.azure issue connecting with power bi
Hi ysalih ,
Have submitted this issue internal to confirm, would update here as soon as possible if there is any update about it.
Best Regards
Community Support Team _ RongtieIf this post helps, then please consider Accept it as the solution to help the other members find it more quickly.
Hey ysalih ,
it seems Service can´t access your DB through gateway. When I catched it right... you need a postgres driver on your gateway machine installed. Version=5.0.0.0 (like in your screen above).
Do you already have required driver installed on your gateway machine?
Regards
The same issue manifests for me and I am not using a gateway (I shouldn't have to, as my Postgres instance is deployed on the cloud), so I don't think this is the problem. Btw, on Power BI Dekstop it works, the problem manifests only in Power BI Service, when you publish the report.
But it doesn´t work, right?
Look, from Power BI Service´s point of view "everything" not in your PBI tenant is on-prem.
Meaning: when PBI Service don´t see any sources within Service network these sources are not reachable for Service.
Your organizational network as well azure cloud environment are foreign networks which are accessable through a gateway. Azure and Power BI are MS product but they are "not in the same box".
That´s what I have seen until today. You will need a gateway in most cases.
Maybe you have another experiences but that´s what I saw a lot of times.
And my cloud sources are accessable and work properly using a gateway.
Regards.A gateway definitely sounds like a workaround. But I want to be able to use the native solution for databases that are publically accessible, a gateway should only be needed for databases running on private networks as clearly stated in the docs. I don't want to have to maintain a server as a gateway and pay the extra bandwidth for all the data to go through it.
