Forum Discussion

Modash12's avatar
Modash12
Frequent Visitor
3 years ago

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...
Need Help
Tutorial Requests
Modash12's avatar
Modash12
Frequent Visitor
3 years ago

I have installed a personal gateway, but the option is grayed out for me. 

 

 

sergej_og's avatar
sergej_og
Icon for Super User rankSuper User
3 years ago

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-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

  • Modash12's avatar
    Modash12
    Frequent Visitor
    3 years ago

    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.