Forum Discussion
Certificate Error Power Bi
I'm recieving this error about an expired certificate. I've never had to have a certificate before. Any tips on how to resolve?
I've updated to the most current version. Restarted. Tried to establish a new data source to the server. Gateway is able to establish a connection.
Data source error: {"error":{"code":"DM_GWPipeline_Gateway_MashupDataAccessError","pbi.error":{"code":"DM_GWPipeline_Gateway_MashupDataAccessError","parameters":{},"details":[{"code":"DM_ErrorDetailNameCode_UnderlyingErrorCode","detail":{"type":1,"value":"-2147467259"}},{"code":"DM_ErrorDetailNameCode_UnderlyingErrorMessage","detail":{"type":1,"value":"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.)"}},{"code":"DM_ErrorDetailNameCode_UnderlyingHResult","detail":{"type":1,"value":"-2147467259"}},{"code":"Microsoft.Data.Mashup.ValueError.Class","detail":{"type":1,"value":"20"}},{"code":"Microsoft.Data.Mashup.ValueError.DataSourceKind","detail":{"type":1,"value":"SQL"}},{"code":"Microsoft.Data.Mashup.ValueError.DataSourcePath","detail":{"type":1,"value":"shf-khazana.ad.sfgov.org,4921;NWSAEGISMSPDB"}},{"code":"Microsoft.Data.Mashup.ValueError.ErrorCode","detail":{"type":1,"value":"-2146232060"}},{"code":"Microsoft.Data.Mashup.ValueError.Message","detail":{"type":1,"value":"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.)"}},{"code":"Microsoft.Data.Mashup.ValueError.Number","detail":{"type":1,"value":"-2146893016"}},{"code":"Microsoft.Data.Mashup.ValueError.Reason","detail":{"type":1,"value":"DataSource.Error"}}],"exceptionCulprit":1}}} Table: Masked Grouped By LOS Ethnicity (2).
Cluster URI: WABI-US-GOV-IOWA-redirect.analysis.usgovcloudapi.net
Activity ID: 22bd74ff-aaf2-4aa1-8d0f-288049d90f26
Request ID: 8177b358-d03c-5af9-50ba-a671c495c31c
Time: 2022-09-21 21:46:53Z
Hi, lbjen
You need to check that your current credentials can access the database normally and make sure "Encrypted connection" is unchecked in the data source settings.
Please check the following related threads for more details.
PowerBI-connection-issue-The-received-certificate-has-expired
connecting-to-sql-server-with-power-queryreceived-certificate-has-expired
https://learn.microsoft.com/en-us/troubleshoot/sql/connect/error-message-when-you-connect
Best Regards,
Community Support Team _ Eason
1 Reply
- v-easonf-msftCommunity Support
Hi, lbjen
You need to check that your current credentials can access the database normally and make sure "Encrypted connection" is unchecked in the data source settings.
Please check the following related threads for more details.
PowerBI-connection-issue-The-received-certificate-has-expired
connecting-to-sql-server-with-power-queryreceived-certificate-has-expired
https://learn.microsoft.com/en-us/troubleshoot/sql/connect/error-message-when-you-connect
Best Regards,
Community Support Team _ Eason