DataSource.Error: The underlying connection was closed

[JoergSch]

Hi,

I am trying to connect from Excel to PowerPlatform Dataflows. The initial step is working fine, but when I connect try to select a specififc workspace, I am getting the below error:

Steps:

1. In Excel, go to Get Data -> From Other sources -> Blank Query
2. Type "PowerPlatform.Dataflows(null)
3. Clicking on the "Folder" link for the workspaces row in the Data column. Then the issue appears. I don't get the list of workspaces. For other users this is working fine and I have permissions on many workspaces.

What might be the reason?

Many thanks for your help.

Joerg

[JoergSch]

So far that didn't provided any solution. We are not using any self-signed certificates or anything like this.

Its pretty a standard connection from Excel to PowerBI Dataflow.

Joerg

[Anonymous]

Hi @JoergSch ,

Here are the main causes of the “Could not establish trust relationship for the SSL/TLS Secure Channel with Authority” message:

• Self-signed certificates: These certificates are often generated for free. However, they don’t provide as much trust as commercial certificates.
• Expired certificates: Most SSL certificates are only valid for a year. Therefore, you’ll need to renew your certificate as it nears its expiration date.
• Certificates not signed by a trusted Certificate Authority (CA): Like self-signed certificates, a lesser-known certificate provider might not be trusted by every browser.
• Free SSL certificates: There are a few free CAs, but sometimes their root certificates must be manually imported into your browser to clear the error.
• Certificates that are missing a chain/intermediate certificate: Most trusted certificates ask you to install at least one other chain/intermediate certificate to link your SSL certificate to a trusted source. However, this process depends on the browser you use. For example, Internet Explorer can automatically download intermediate certificates, but Mozilla Firefox can’t.

About more details, you may refer to

How To Fix the “Could Not Establish Trust Relationship for the SSL/TLS Secure Channel with Authority...

Best Regards,

Stephen Tao

If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.