Forum Discussion

ssnegi's avatar
ssnegi
Regular Visitor
1 year ago
Solved

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 ...
Need Help
  • Anonymous's avatar
    Anonymous
    1 year ago

    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 Permissions

    2. 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=True

    Please 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.

Anonymous's avatar
Anonymous
Not applicable
1 year ago

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 Permissions

2. 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=True

Please 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.

philam's avatar
philam
New Member
1 month ago

Server hosting the GateWay needs Certificate of the server where the database used by your PowrBI report resides.