Use https web services in MS Power Query Excel 2016

[clemensbauer]

Using Microsoft Excel 2016 with Power Query to connect to a https web services is not possible. I receive always the following message: The request was aborted: Could not create SSL/TLS secure channel.

I tried already the following registry entries with Windows 7 and Excel 2016:

https://answers.microsoft.com/en-us/msoffice/forum/msoffice_excel-mso_other/power-query-could-not-cr... and

https://support.microsoft.com/en-us/help/3140245/update-to-enable-tls-1-1-and-tls-1-2-as-a-default-s...

but this does not help. So I tried to add the certificate https://blog.gbrueckl.at/2014/09/using-self-signed-certificates-for-your-power-bi-dmg/ to my windows. But this does also not work.

Is anyone aware of this issue and can tell me what I need to do to run https web services with Excel 2016?

Thanks

[v-yuezhe-msft]

@clemensbauer,

Do you get same error message when you use Web entry in Power BI Desktop to connect to your web services? Could you please post the web URL so that I can test?

Regards,
Lydia

[clemensbauer]

@v-yuezhe-msft, I do not have Power BI Desktop and usage is an internal server which provides the web services. Therefore, I cannot provide the URL (not accessable from outside).

I do not think that this is an Office issue, I think it is an server issue and rely on the certificate handling.

Br

[v-yuezhe-msft]

@clemensbauer,

As this issue is related to Power Query, please post the question in the Power Query forum to get dedicated support.

Regards,
Lydia