topic Re: Power BI REST API - Authentication failed because the remote party has closed the transport stre in Developer

Power BI REST API - Authentication failed because the remote party has closed the transport stream.

Anchal-D — Wed, 24 Jun 2020 14:45:22 GMT

Hi, I am getting error "Authentication failed because the remote party has closed the transport stream." while connecting to Power BI REST API via a SSIS Script task. It was working fine till last Friday and sudently it started throwing error. below is the api string i am calling -

https://api.powerbi.com/v1.0/myorg/groups?$filter=contains(name,'ECHO')

anyone aware about any changes in the API side recently? I find some links asking to change target framework on script task side and I changed it from 4.5 to 4.6 but still getting this error. any help is appriciated.

Thanks in Advance.

Re: Power BI REST API - Authentication failed because the remote party has closed the transport stre

lbendlin — Wed, 24 Jun 2020 22:27:44 GMT

maybe related to the TLS 1.2 enforcement?

Re: Power BI REST API - Authentication failed because the remote party has closed the transport stre

Anonymous — Thu, 25 Jun 2020 03:44:05 GMT

same here

Re: Power BI REST API - Authentication failed because the remote party has closed the transport stre

Anonymous — Thu, 25 Jun 2020 03:54:34 GMT

checked "internet option" in my computer. TLS 1.0, 1.1, 1.2 are checked.

Re: Power BI REST API - Authentication failed because the remote party has closed the transport stre

Anchal-D — Thu, 25 Jun 2020 14:08:42 GMT

Yes. it was TLS 1.2 enforcement issue, I used below in my code and it fixed it.

System.Net.ServicePointManager .SecurityProtocol |= SecurityProtocolType.Tls11 | SecurityProtocolType.Tls12;

Re: Power BI REST API - Authentication failed because the remote party has closed the transport stre

Anonymous — Mon, 20 Jul 2020 02:48:41 GMT

It is not working in Win7.

The workaround is to use Win10

Re: Power BI REST API - Authentication failed because the remote party has closed the transport stre

marconis — Mon, 19 Jun 2023 06:19:11 GMT

HI @Anchal-D , This seems to be a very old post but I have the same problem that I recently encounter. With your solution, how do I put this colde in Power Query.

I encounter this issue in my PowerBI Dataflow.

Thank you in advance!

Re: Power BI REST API - Authentication failed because the remote party has closed the transport stre

lbendlin — Mon, 19 Jun 2023 17:42:15 GMT

show a cleaned up version of your Power Query code. Which API endpoint are you calling?