cancel
Showing results for 
Search instead for 
Did you mean: 
Reply
Highlighted
Frequent Visitor

The remote certificate is invalid according to the validation procedure

I got issue due to certificate when I try get data from Postgresql database in Power BI Desktop. 

 "The remote certificate is invalid according to the validation procedure"
So, I follow this guide: https://gist.github.com/oeon/d17bc6b0ccca708a67e172f4e4d86ef8

Now, I can get data and refresh it in Power BI desktop. But when I publish dataset in to Power BI Service, I can not refesh dataset. I got error below
"Something went wrong
There was an error when processing the data in the dataset.
Please try again later or contact support. If you contact support, please provide these details.
Message: An error happened while reading data from the provider: 'The remote certificate is invalid according to the validation procedure.' Table: public res_branch.
Cluster URI: WABI-SOUTH-EAST-ASIA-B-PRIMARY-redirect.analysis.windows.net
Activity ID: 67e5271f-4bd8-46f1-b27a-da880839e229
Request ID: 9a397ebc-95bc-8d4f-e537-cfb2f318758a
Time: 2020-02-10 07:45:52Z"

 

How can I deal with this issue?

Thanks for your support.

1 REPLY 1
Highlighted
Community Support
Community Support

Re: The remote certificate is invalid according to the validation procedure

Hi @sonnh ,

 

What version of PostgreSQL data source and client are you used? I think this issue may cause with power bi service client version. (Power bi service not able to recognize and compatibility with the encrypted credentials generated from a different data source/client version)

I'd like to suggest you open a support ticket with detail information to get further support for these compatibility issues.

https://powerbi.microsoft.com/en-us/support/

Support Ticket.gif

You could also install on-premise gateway personal mode for a try.

 

Community Support Team _ Eads
If this post helps, then please consider Accept it as the solution to help the other members find it.

Helpful resources

Announcements
August 2020 Community Challenge: Can You Solve These?

August 2020 Community Challenge: Can You Solve These?

We're excited to announce our first cross-community 'Can You Solve These?' challenge!

July 2020 Community Highlights

July 2020 Community Highlights

Learn about the exciting things that happened in July.

Featured Data Story of The Month

Featured Data Story of The Month

All Data Stories Gallery contributions are reviewed for each month. We select a contribution and feature the community member the following month.

Power BI Dev Camp - Developing with .NET Core

Power BI Dev Camp - Developing with .NET Core

Learn how to develop custom web applications for Power BI using .NET Core 3.1 and .NET 5.

Power BI Desktop August 2020 Update

Power BI Desktop August 2020 Update

We have great updates this month! Click the link for the video with more info.

Top Solution Authors
Top Kudoed Authors