Forum Discussion
Power BI Service can't connect to Postgres.
Super UserHi Modash12 ,
as aj1973 mentioned an on-prem gateway...
make sure you have installed a postgre driveron your gateway machine - I guess you have to use a bit "older" one, not last stable - we have this case in our company.
Reason for using an "older" driver is Power BI Service accepts connection through a specific version and no higher - at least that is the case in our region (West Europe)
I have installed a personal gateway, but the option is grayed out for me.
- sergej_og
Personal 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-modeYour 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.
RegardsI 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.
