topic Re: An existing connection was forcibly closed by the remote host in Developer

An existing connection was forcibly closed by the remote host

xboneu — Thu, 09 Sep 2021 17:00:53 GMT

Hi! We used to consume some Power BI Pro reports but recently, when we try to reach the PowerBI reports we get the following error: "An existing connection was forcibly closed by the remote host"

[SocketException (0x2746): An existing connection was forcibly closed by the remote host]
   System.Net.Sockets.Socket.EndReceive(IAsyncResult asyncResult) +6723894
   System.Net.Sockets.NetworkStream.EndRead(IAsyncResult asyncResult) +57

[IOException: Unable to read data from the transport connection: An existing connection was forcibly closed by the remote host.]
   System.Net.TlsStream.EndWrite(IAsyncResult asyncResult) +237
   System.Net.PooledStream.EndWrite(IAsyncResult asyncResult) +15
   System.Net.ConnectStream.WriteHeadersCallback(IAsyncResult ar) +121

Continues....

Since we have not changed anything from our code, we thought that maybe PowerBI has changed something that prevents us to consume the reports as usual. We've searched the forum with no avail.

The piece of code that fails is:

-HttpClient client = new HttpClient();
-string powerBiUrl = "https://api.powerbi.com/v1.0/myorg/groups/" + ConfigurationManager.AppSettings["powerbi:WorkspaceId"] + "/reports";
-client.DefaultRequestHeaders.Authorization = new AuthenticationHeaderValue("Bearer", authToken);
-var result = client.GetAsync(powerBiUrl).Result;
-if (result.IsSuccessStatusCode)
-{...}

I hope that someone can throw some light on it.

Thanks.

Re: An existing connection was forcibly closed by the remote host

lbendlin — Fri, 10 Sep 2021 17:58:43 GMT

if this happens during dataset refresh it usually means that you are bombarding the data source and it gets fed up and leaves. In your case you may have run into API calls per hour limits, but normally the error message should mention that more explicitly. Have you seen an increase in 429's in your HTTP logs?

Re: An existing connection was forcibly closed by the remote host

xboneu — Tue, 14 Sep 2021 16:30:43 GMT

Ibendlin, thank you for your reply.

I haven´t seen anything strange in the HTTP logs. We seldom use these reports, so I would discard the bombarding scenario. I am trying to build from scratch a small experiment app. Maybe I can see and understand what's going on and why a piece of code that hasn't been modified for months, now cannot retrieve the PowerBI reports.