Forum Discussion
Erreur authentification Power Query : La connexion sous-jacente a été fermée.
Hi LV_Skopea ,
The error might be caused by the direction of TLS. Please kindly refer to
error: The underlying connection was closed: An unexpected error occurred on a send
The there're some possible causes:
- 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.
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.
Hi Stephen !
Thank you for your answer, I have read the links you shared and tried a few changes but I’m am clearly not an expert, I’m a just a freelance who need PowerQuery to work and I have been stuck for ten days now..
For now on, what I understand from tests that I made :
- Has I said in my previous message, I can’t connect to a data source that requires an anthentification through professional account (Sharepoint or OneDrive file).
- On the service, I can connect perfectly to this sources (PowerBI Service / dataflow ).
- On my desktop computer, I have tried the same procedure with my account, and everything works fine.
So it seems to come from my laptop.
From the documentation you’ve send to me, I have understood that it may come from my navigator (Microsoft Edge) or from my laptop system parameters is that right ?