OData / SSL Gateway error

[CPC-Keith]

Hi

Apologies if this ends up being a double post, i had posted this issue but now can not find the post any where,

Resonably new user to PowerBi but have been able to work around most things so far until hitting this,

We have a system on site that uses REST and i have created an SSL for the server which works fine scross site on any systems the certs are installed to, PowerBi Desktop is happy using this cert for an OData link to the REST api,

The certs are on the server that is running our gateway but i can not set up a datasource to it on the gateway in the PowerBi Service, i get the following error

Underlying error code:	-2147467259
Underlying error message:	OData: Request failed: The underlying connection was closed: Could not establish trust relationship for the SSL/TLS secure channel.

Should this work with a self create cert if it is working onsite and is on the gateway server?

anyone have any suggestions on what i need ot look at or do?

Thank You

[CPC-Keith · Accepted solution]

Thank you for the links, some helpfull reading there,

I have now fixed the problem, i was trying to work it the same as a data source on a file share - setting the top level and mapping to it, the connection was not working to the top level of the REST api which does work in a browser,

Setting a datasource for each api routine we are using works fine and has moved me on.

[v-angzheng-msft]

Hi, @CPC-Keith 

I am very glad that your problem has been solved and thank you for sharing. Could you please mark your post as Answered since it is working now? It will help the others in the community find the solution easily if they face the same problem with you. Thank you.

[v-angzheng-msft]

Hi, @CPC-Keith 

Here are some references that may be helpful

https://patchmypc.com/could-not-establish-trust-relationship-for-the-ssl-tls-secure-channel

https://community.powerbi.com/t5/Desktop/The-underlying-connection-SSL-connection-was-closed-No-trus...

https://community.powerbi.com/t5/Report-Server/ERROR-The-underlying-connection-was-closed-Could-not-...

https://kb.blackbaud.com/knowledgebase/Article/114768

Best Regards,
Community Support Team _ Zeon Zheng
If this post helps, then please consider Accept it as the solution and give it a thumbs up to help the other members find it more quickly.