Can't login to Analysis for MS Excel using BW/4HANA and BPC 11

Hi have created an instance on Azure for BW/4HANA SP05 and BPC 11 SP01 from SAP CAL.

Everything works fine. I can login to the system and I can use the Web Client.

Then I installed Office 2016 and the Analysis tool for Excel.

When I try to login using this tool I got the following error

When using http://[Server]:[Port]/sap/bpc/:

Framework message:
The underlying connection was closed: An unexpected error occurred on a receive.
An error occurred while receiving the HTTP response to http://[server]:[port]/sap/bpc/session?method=Get. This could be due to the service endpoint binding not using the HTTP protocol. This could also be due to an HTTP request context being aborted by the server (possibly due to the service shutting down). See server logs for more details.
The underlying connection was closed: An unexpected error occurred on a receive.
Unable to read data from the transport connection: An existing connection was forcibly closed by the remote host.
An existing connection was forcibly closed by the remote host

and when using https://[Server]:[Port]/sap/bpc/

Framework message:
The underlying connection was closed: Could not establish trust relationship for the SSL/TLS secure channel.
Could not establish trust relationship for the SSL/TLS secure channel with authority '[server]:[port]'.
The underlying connection was closed: Could not establish trust relationship for the SSL/TLS secure channel.
The remote certificate is invalid according to the validation procedure.

I use Remote Desktop Connection to login to the Azure server and work from there.

Any help will be appreciated.

Thanks!.