Forum Discussion
Power BI Service can't connect to Postgres.
So, I have a Postgres database that is avaialable on AWS. I have connected to the database using the Postgres connector in "Get Data" in Power BI desktop and unchekced the "Encrypt Connection" box. T...
sergej_og
Super User
Super UserPersonal gateway should be fine for this purpose, but there are limitation.
I recommend to use gateway standard mode.
https://learn.microsoft.com/en-us/power-bi/connect-data/service-gateway-personal-mode
Your message above tells you all data sources are in the cloud.
Your PostgreDB is on-prem? If yes, then you have to install postgre driver in your machine where gateway is running.
I´m bit confused about the message from Service and your description.
Pls provide more exact information for better (potential) solution proposal.
Regards
I have only one source which is a Postgres DB on cloud. Although it's possible for me to connect in Desktop, published dashboards are unable to connect the Postgres DB.