DataSource.Error: The underlying connection was cl...

JoergSch · ‎11-24-2022

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:

In Excel, go to Get Data -> From Other sources -> Blank Query
Type "PowerPlatform.Dataflows(null)
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 · ‎11-28-2022

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 · ‎11-24-2022

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.