Skip to main content
cancel
Showing results for 
Search instead for 
Did you mean: 

Get certified as a Fabric Data Engineer: Check your eligibility for a 50% exam voucher offer and join us for free live learning sessions to get prepared for Exam DP-700. Get started

Reply
Modash12
Frequent Visitor

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. This allowed me to connect build reports which I then published to an organization workspace used by my company.

afifsyed67_0-1691240421665.png

However, I am unable to see any data on the reports published and upon checking getting the "remote certificate invalid error".

afifsyed67_1-1691240654144.png

Please assist on this matter. 

8 REPLIES 8
sergej_og
Super User
Super User

Hi @Modash12 ,
I my case Power BI Service "told" me in one error message (dataset refresh failure) which driver version Service needs to achive a successful refresh.
Currently ODBC driver "Npgsql-4.0.10" works well for our needs.
Setup an ODBC Connection on your Gateway VM and try out.

sergej_og
Super User
Super User

Hi @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. 

afifsyed67_0-1691486878877.png

 

 

aj1973
Community Champion
Community Champion

@Modash12 

Your Postgres Database is in the cloud hosted by AWS, no need for Gateway. However you need to contact the hosting provider : 

aj1973_0-1691492943212.png

 

Regards
Amine Jerbi

If I answered your question, please mark this thread as accepted
and you can follow me on
My Website, LinkedIn and Facebook

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

sergej_og_0-1691488646046.png

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.

@sergej_og Thanks for the response.
How can I know which "older" version driver will Power BI Service accept. 

aj1973
Community Champion
Community Champion

Hi @Modash12 

You need an On-premis Gateway

Regards
Amine Jerbi

If I answered your question, please mark this thread as accepted
and you can follow me on
My Website, LinkedIn and Facebook

Helpful resources

Announcements
Las Vegas 2025

Join us at the Microsoft Fabric Community Conference

March 31 - April 2, 2025, in Las Vegas, Nevada. Use code MSCUST for a $150 discount! Prices go up Feb. 11th.

Feb2025 Sticker Challenge

Join our Community Sticker Challenge 2025

If you love stickers, then you will definitely want to check out our Community Sticker Challenge!

Jan NL Carousel

Fabric Community Update - January 2025

Find out what's new and trending in the Fabric community.