I am trying to use Excel to retrieve data using OData and I get an error message:
Odata: Request failed: the underlying connection was closed: could not establish trust relationship for the SSL/TLS secure channel.
I am able to get results using just a browser:
However, when i try to connect from Excel i get the trust relationship error.
I went into the Excel Trust Center and added a Catalog to that URL however, i still get the trust relationship error.
Anyone solved this issue before?
I’m not sure if this is a server or client issue?
Any help greatly appreciated.