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

Find everything you need to get certified on Fabric—skills challenges, live sessions, exam prep, role guidance, and more. Get started

Reply
tarunsareen25
Advocate I
Advocate I

Certificate error while refreshing data on Power BI service for connection with Postgresql on AWS

I have been going through a lot of posts but could not find a clear answer to this issue. 

 

We are trying to build new reports and dashboards in Power BI and the data for this is retrieved from a Postgresql server on AWS. When I publish this on Power BI service and try to refresh data it is throwing an error:

 

Failed to update data source credentials: An error happened while reading data from the provider: 'The remote certificate is invalid according to the validation procedure.'

 

There are couple of posts on how to fix this on Power BI Desktop but none of them has a mention of how is this fixed on Power BI Service after it has been published. Is there a way to fix this issue in Power BI Service?

6 REPLIES 6
rahulanandt
Frequent Visitor

I also have the same issue and not getting a proper solution. Whenever people post this issue, everyone reply with the solution for desktop version. 

Using Gateway might solve the issue but i don't want to use a gateway for this connection

collinq
Super User
Super User

Hi tarunsareen25,

 

Have you installed the certificate on the Computer account AND the Enterprise Gateway Server?  (https://social.technet.microsoft.com/Forums/windowsserver/en-US/85f2cdbf-f316-40a2-968b-ab823bffc947...

 

And, are both your Power BI Desktop and the Gateway the latest and greatest versions?

 

I would appreciate Kudos if my response was helpful. I would also appreciate it if you would Mark this As a Solution if it solved the problem. Thanks!

 




Did I answer your question? Mark my post as a solution!

Proud to be a Datanaut!
Private message me for consulting or training needs.




Thanks @collinq 

 

Do you need a Gateway for Postgresql DB on AWS? 

 

This works fine on Power BI Desktop, the issue is basically when the data is refreshed on Power BI Service.

Hi @tarunsareen25 ,

 

Take a look at this thread and see if it helps:

https://community.powerbi.com/t5/Power-Query/Configure-Gateway-to-connect-to-PostgreSQL/td-p/478150

 

 

I would appreciate Kudos if my response was helpful. I would also appreciate it if you would Mark this As a Solution if it solved the problem. Thanks!



Did I answer your question? Mark my post as a solution!

Proud to be a Datanaut!
Private message me for consulting or training needs.




Thanks @collinq . The link is for a different issue while connecting with Power BI desktop.

 

What I am looking for is how to resolve a certificate issue on Power BI Service while connecting with Postgresql on AWS.

 

I have not been able to find a way to do this yet except get a gateway to refresh the data

 

 

Did you ever get a solution to this problem? I've got the same issue that you are reporting...

Helpful resources

Announcements
July 2024 Power BI Update

Power BI Monthly Update - July 2024

Check out the July 2024 Power BI update to learn about new features.