cancel
Showing results for 
Search instead for 
Did you mean: 
Reply
Anonymous
Not applicable

Help please -- SSL Provider error / certificate has expired

Hi,

I'm receiving the below error message (I've hidden the DataSourcePath which was just the server,port;dbname).

The datasource is an on-premises SQL Server database. To test the user access I use SSMS to connect to the database and run a couple of queries. All works fine.

I have successfully added the SQL Server database to the On-Premises Data Gateway. So all looks like the refresh should work.

Why do I get the below error message?  What is it actaully telling me?  Do I need to add some sort of software to the Server where the On-Premises Data Gateway is installed.

Thanks in advance.

 

SSL.PNG

5 REPLIES 5
Moderator v-qiuyu-msft
Moderator

Re: Help please -- SSL Provider error / certificate has expired

Hi @Anonymous,

 

The error message suggests that there's a problem with the encryption configuration on the SQL Server. It might be just what the message says – that the server is configured with a certificate that has now expired. Or, it might be a different problem.

 

1. Please edit the data source setting in Power BI Desktop and disable encryption to republish the report in order to avoid this problem.

 

w2.PNG

 

2. Update the on-premise data gateway to the latest version.

3. If issue still persists, please share on-premise data gateway service log files (C:\Users\PBIEgwService\AppData\Local\Microsoft\on-premises data gateway\Gateway*.log) around the time error throws out with us. You can upload log files to your OneDrive and share the link here.

 

Best Regards,
QiuyunYu

Community Support Team _ Qiuyun Yu
If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.
gune01 Frequent Visitor
Frequent Visitor

Re: Help please -- SSL Provider error / certificate has expired

we had same issue,  we had a sql server certificate which expired and was not needed, 

powerbi was working using the default encryption option and stopped working after the cert expired, we republished

the powerbi dataset using unencrypted connection but gateway still tries to look for the certificate on this server

below is the snippet of log, 

we applied latest patch to gateway, 

restart gateway service 

recreated the powerbi data source , thinking it might be cached, 

 

still its looking for the certifcate that is expired and no longer on the server

 

 

-ba2c-fd7c1e21ae61 8AA61592 [DM.Pipeline.Diagnostics] Exception data: DM_ErrorDetailNameCode_UnderlyingErrorCode = <pi>-2147467259</pi>
DM.EnterpriseGateway Error: 0 : 2019-02-23T02:40:31.0335409Z DM.EnterpriseGateway c6ed21b5-4db9-4cfb-adef-61f003a642d1 591a386d-db71-3b57-2621-f9eb069c807c MGCC 80c5f97e-414d-4a9a-ba2c-fd7c1e21ae61 4331972A [DM.Pipeline.Diagnostics] Exception data: DM_ErrorDetailNameCode_UnderlyingErrorMessage = <pi><pi>Microsoft SQL: A connection was successfully established with the server, but then an error occurred during the login process. (provider: SSL Provider, error: 0 - The received certificate has expired.)</pi></pi>

Highlighted
JakeInUK Frequent Visitor
Frequent Visitor

Re: Help please -- SSL Provider error / certificate has expired

I also had this problem. My workaround was to create an ODBC SQL connection instead; not ideal. It meant reconfiguring the Power BI model, but at least everything is refreshing again.

Anonymous
Not applicable

Re: Help please -- SSL Provider error / certificate has expired

Having someone just contribute to this post has prompted me to state the fix for my instance of the issue. In short, it was the SSL Certificate that had expired against the SQL Server. It took the DBA a while to suss what the problem was but once the SSL Certificate was renewed all was fine again (if my memory is correct).

JakeInUK Frequent Visitor
Frequent Visitor

Re: Help please -- SSL Provider error / certificate has expired

In my situation the expired SSL certificate had been removed (as the other connections were working), but the PowerBI gateway connection was still stating the error.

Helpful resources

Announcements
Coming Soon: T-Shirt Design Contest

Coming Soon: T-Shirt Design Contest

Keep your eyes open for our upcoming T-shirt design contest!

Meet the 2020 Season 1 Power BI Super Users!

Meet the 2020 Season 1 Power BI Super Users!

It’s the start of a new Super User season! Learn all about the new Super Users and brand-new tiered recognition system.

Super User Challenge: Can You Solve These?

Super User Challenge: Can You Solve These?

We're celebrating the start of the New Super User season with our first ever Super User 'Can You Solve These?' challenge.

Power BI Desktop Update - February 2020

Power BI Desktop Update - February 2020

We are super excited for our update this month, as we are releasing two of our top community requests!

Power Platform Online Conference

Power Platform Online Conference

Join us for the first ever Power Platform Online Conference!

Top Solution Authors
Top Kudoed Authors