Join us for an expert-led overview of the tools and concepts you'll need to pass exam PL-300. The first session starts on June 11th. See you there!
Get registeredPower BI is turning 10! Let’s celebrate together with dataviz contests, interactive sessions, and giveaways. Register now.
HI everyone:
I hope you are doing well. I have installed and configured the On-premises data gateway, but whenever I try to refresh any Dataflow, the status shows as failed. I checked the logs and found the following message:
Non-gateway exception encountered in activity scope: Microsoft.Data.Mashup.MashupValueException (0x80004005): AzureBlobs failed to get the response: 'The underlying connection was closed: Could not establish trust relationship for the SSL/TLS secure channel.'.
Could you help me please?
Hi @TorresJA ,
Thank you for reaching out to the Microsoft Fabric Community
As highlighted by @Nasif_Azam , the issue is likely due to a certificate trust or TLS configuration problem on the gateway machine. Please verify SSL certificate trust, enforce TLS 1.2 via registry, and ensure your gateway is up to date and correctly mapped in the Dataflow settings.
For more details, you can also refer to this doc: Install an on-premises data gateway | Microsoft Learn
Hope this helps. Please reach out for further assistance.
If this post helps, then please consider to Accept as the solution to help the other members find it more quickly and a kudos would be appreciated.
Thank you.
Hey @TorresJA ,
The error message typically indicates a certificate trust issue between your on-premises data gateway and Azure services like Azure Blob Storage. It occurs may:
Invalid or Untrusted Root Certificates
Outdated TLS Version Support
Interception by Antivirus/Firewall
Missing Gateway Configuration or Mismatch
Open a browser on the gateway machine.
Go to the Blob Storage URL you're trying to connect to (e.g., https://<yourstorageaccount>.blob.core.windows.net).
See if it loads without certificate errors.
If it doesn’t, install the missing intermediate/root certificates.
Make sure your OS is using TLS 1.2 by default:
Open regedit and navigate to: HKEY_LOCAL_MACHINE\SOFTWARE\Microsoft\.NETFramework\v4.0.30319
Add or update these DWORD values:
SchUseStrongCrypto = 1 SystemDefaultTlsVersions = 1
Make sure you’re running the latest version of the On-premises Data Gateway.
Update Windows, especially the root certificate store.
If possible, update to the latest .NET Framework runtime.
Verify Dataflow Gateway Usage
In the Power BI Service:
Go to the workspace where your Dataflow is.
Edit the Dataflow → Check the data source settings.
Ensure the gateway is mapped correctly to the source.
If you found this solution helpful, please consider accepting it and giving it a kudos (Like) it’s greatly appreciated and helps others find the solution more easily.
Best Regards,
Nasif Azam
User | Count |
---|---|
6 | |
4 | |
2 | |
2 | |
2 |
User | Count |
---|---|
6 | |
3 | |
3 | |
2 | |
2 |