Error updating on Power BI Online: An existing connection was forcibly closed by the remote host.

[GuilhermeDias]

I'm having problems updating my report on Power Bi Service Online, on desktop it works without problems. Another issue is, that when I filter a smaller amount of data for the variables, it runs without problems.

Source:

 (Empresa as text, Empregado as text) => let
Fonte = Csv.Document(Web.Contents("https://ws1.soc.com.br/WebSoc/exportadados",
[Query = [parametro="{'empresa':'xxxx','codigo':'xxxxxx','chave':'xxxxxxx','tipoSaida':'csv','empresaTrabalho':" & Empresa & ",'funcionario':" & Empregado & "}"]]),[Delimiter=";", Columns=8, Encoding=28591, QuoteStyle=QuoteStyle.None])

Error message:

Data source error: DataSource.Error: <ccon>Unable to read data from the transport connection: An existing connection was forcibly closed by the remote host.. </ccon>;Unable to read data from the transport connection: An existing connection was forcibly closed by the remote host.. The exception was raised by the IDataReader interface. Please review the error message and provider documentation for further information and corrective action. Table: Empregados.
Cluster URI: WABI-SOUTH-CENTRAL-US-redirect.analysis.windows.net
ID da atividade: 7cfd3f51-1bd2-4a72-be6f-f957162c4ab2
Solicitar ID: d25e5d37-cdbf-45b3-9e5c-ce09e0a8282a
Hora: 2023-06-06 07:06:35

[Anonymous]

Hi  @GuilhermeDias ,

Does this problem occur when refreshing or updating dataflow?
If so, the product team is aware of the issue and is working on a fix!

Best regards.
Community Support Team_Caitlyn

[GuilhermeDias]

Hi @Anonymous , 

The problem occurs when updating the dataset and Dataflow Gen2 of the new Data Factory.

[Anonymous]

Hi  @GuilhermeDias ,

We have seen on the internal platform that other engineers have reported this issue and submitted it.
The engineers on the product team are now aware and will do their best to resolve the issue. I will update here if there is any progress, so please be patient.

Best regards.
Community Support Team_Caitlyn

[mhasan27]

@GuilhermeDias 

I am facing dataflow refresh failure and this dataflow has all the source from SharePoint and it is failing to refresh since last week. I triggered manual refresh but it is failing with the same error with different table. Kindly suggest ways to resolve this issue.

Follwoing is the error message:

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

Request ID: 4ad4a72d-d4d0-43b6-8c46-2d402d1a3443

Activity ID: 96dcd502-4720-473d-97fc-be6936663e98