Forum Discussion
Error: Could not establish trust relationship for the SSL/TLS secure channel.
Hi fellow members,
I'm seeking some help using Power Query. Hopefull you can give me a hand.
I had a table (two columns) done from a URL. This URL is the following: "https://www.bcv.org.ve/sites/default/files/indicadores_sector_externo/2_1_1_tdc.xlsx "
By going in, an Excel file is automatically downloaded from a Central bank with the official Exchange Rates in a daily presentation.
All of a sudden, my table does not refresh, and it gives me this error:"Details: "The underlying connection was closed: Could not establish trust relationship for the SSL/TLS secure channel."
I've done nothing differently in my file and the webpage has not changed the link.
If I start to do my Query from scratch by extracting data from the web, it gives me the same error.
Do any of you guys have a clue?
2 Replies
rubayatyasminCommunity Champion
Hi, Jabostation
this is happening because of certification enforcement of a old release of PBI. However, you need to upgrade your SSL certification or disable ''enable certification revocation check''.
refer:Not able to login into Power BI desktop App - Microsoft Fabric Community
Also some similar thread that might help you, Solved: Refresh in Service error : Could not establish tru... - Microsoft Fabric Community
How to fix 'Could not establish trust relationship for the SSL/TLS secure channel' - Microsoft Q&A
Hello rubayatyasmin ,
Thanks for reaching out.
I think this is not my case, because the Query is working at this exact moment and everything seems to be okay. Not sure what changed, but I can tell you I did not have time to make the changes you suggested.
I'm guessing this had to do with the site's website and not my personal configuration.
