Forum Discussion
Error refreshing report data DM_GWPipeline_Gateway_MashupDataAccessError
Getting this error within the tags :
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 certificate chain was issued by an authority that is not trusted. (see below)
Connection Power BI to Azure SQL.
An error occurred while processing the data in the semantic model.Refresh failed: {"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":"<ccon>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 certificate chain was issued by an authority that is not trusted.)</ccon>"}},{"code":"DM_ErrorDetailNameCode_UnderlyingHResult","detail":{"type":1,"value":"-2147467259"}},{"code":"Microsoft.Data.Mashup.ErrorCode","detail":{"type":1,"value":"10478"}},{"code":"Microsoft.Data.Mashup.ValueError.Class","detail":{"type":1,"value":"20"}},{"code":"Microsoft.Data.Mashup.ValueError.ConnectionId","detail":{"type":1,"value":"6cd86606-b954-4db6-8be1-7fd3d41c3b2e"}},{"code":"Microsoft.Data.Mashup.ValueError.DataSourceKind","detail":{"type":1,"value":"SQL"}},{"code":"Microsoft.Data.Mashup.ValueError.DataSourcePath","detail":{"type":1,"value":"<ccon>lockaudc-db04;AU_DW_PROD</ccon>"}},{"code":"Microsoft.Data.Mashup.ValueError.ErrorCode","detail":{"type":1,"value":"-2146232060"}},{"code":"Microsoft.Data.Mashup.ValueError.Message","detail":{"type":1,"value":"<ccon>A connection was successfully established with the server, but then an error occurred during the login process. (provider: SSL Provider, error: 0 - The certificate chain was issued by an authority that is not trusted.)</ccon>"}},{"code":"Microsoft.Data.Mashup.ValueError.Number","detail":{"type":1,"value":"-2146893019"}},{"code":"Microsoft.Data.Mashup.ValueError.Reason","detail":{"type":1,"value":"DataSource.Error"}},{"code":"Microsoft.Data.Mashup.ValueError.State","detail":{"type":1,"value":"0"}}],"exceptionCulprit":1}}} Table: dw_anzsic_division_code_ranges. Next refresh for Lockton-AU-Dashboards is scheduled for February 21, 2025 20:00 UTC. |
I looked at articles and was unable to resolve.
Hi ssnegi,
Thank you for reaching out in Microsoft Community Forum.
Thank you Anonymous for the helpful response.
Power BI enforces encryption when connecting to Azure SQL, but SSL errors may occur if the certificate is not trusted. please follow below steos to fiz the issue;
1. please make sure whether encryption is enabled or not In power BI desktop
Go to File → Options and settings → Data Source Settings → Edit Permissions2. Download and install the DigiCert Global Root CA on the gateway machine and restart the Gateway
3. you can modify the connection string using below code
Encrypt=True;TrustServerCertificate=TruePlease continue using Microsoft community forum.
If you found this post helpful, please consider marking it as "Accept as Solution" and give it a 'Kudos'. if it was helpful. help other members find it more easily.
Regards,
Pavan.
7 Replies
Hi, is there any setting in power bi for encryption and trusted certificates ?
Hi ssnegi,
Thank you for reaching out in Microsoft Community Forum.
Thank you Anonymous for the helpful response.
Power BI enforces encryption when connecting to Azure SQL, but SSL errors may occur if the certificate is not trusted. please follow below steos to fiz the issue;
1. please make sure whether encryption is enabled or not In power BI desktop
Go to File → Options and settings → Data Source Settings → Edit Permissions2. Download and install the DigiCert Global Root CA on the gateway machine and restart the Gateway
3. you can modify the connection string using below code
Encrypt=True;TrustServerCertificate=TruePlease continue using Microsoft community forum.
If you found this post helpful, please consider marking it as "Accept as Solution" and give it a 'Kudos'. if it was helpful. help other members find it more easily.
Regards,
Pavan.
Hi ssnegi,
I wanted to follow up since we haven't heard back from you regarding our last response. We hope your issue has been resolved.
If the community member's answer your query, please mark it as "Accept as Solution" and select "Yes" if it was helpful.
If you need any further assistance, feel free to reach out.
Please continue using Microsoft community forum.
Thank you,
Pavan.Hi ssnegi,
I hope this information is helpful. Please let me know if you have any further questions or if you'd like to discuss this further. If this answers your question, kindly "Accept as Solution" and give it a 'Kudos' so others can find it easily.
Thank you,
Pavan.Hi ssnegi,
I wanted to check if you had the opportunity to review the information provided. Please feel free to contact us if you have any further questions. If my response has addressed your query, please "Accept as Solution" and give a 'Kudos' so other members can easily find it.
Thank you,
Pavan.
