Hello,
Lately, we have issues with automatic update in PBI online accounts. I have 2 different reports, each has different CSV data source from our server. Almost every day the auto update fails.
During update one of the reports, PBI tries to update both data sources at once, do not know why. Additionaly, the update process sends 2, sometimes even more GET requests on the server at a time. First request is stopped by PBI during downloading the file. Usually, PBI sends requests, our server answers and sends the whole file successfully, but PBI do not use it and it ends with error anyway.
We have tried to check all time limits on our side, but it seems to be OK. It is the same with small and large files.
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.
21 Comments
v-haibl-msftMicrosoft Employee
Did this issue happen to the same two reports before? I tried to test the same scenario as you but cannot repro the same issue. Is there any special setting/configuration?
Best Regards,
Herbert
Vicky_SongImpactful Individual
Status changed:NewtoNeeds InfoDear Herbert,
We have app. 30 clients and everyone has each own free account with 2 reports = 60 autoupdates per day. Today I recieved 11/30 errors, 17/30 yesterday. Distribution is random every day. So yes, this issue happened more than once to the same reports. In late November, it was usually 1 error of this type per week in total. Nothing changed on our side since then and we use the same reports.
Best regards,
Jakub
- v-haibl-msft
Can the report be refreshed successfully if using manual refresh instead of automatic refresh?
Best Regards,
Herbert
Yes, but there is also 30-40 % failure rate, so I need to do that more than once.
Regards,
Jakub
I have the same issue on some manual and scheduled refresh :
Data source error: 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.
Cluster URI: WABI-NORTH-EUROPE-redirect.analysis.windows.net
Activity ID: 432c4293-14d8-48a8-aa03-379d92461a0f
Request ID: 71d7169d-fdbb-aa4e-2cff-d0fc054632ab
Time: 2017-03-01 12:36:00ZWe no change on the report the issue occur and disapear.
Good to hear we are not alone.
The number of errors has decreased on half last month. Nobody knows why and when it increases again. No changes in our reports as well.
CamLK: Wish you to find a solution.
Regards,
Jakub
We have the same issue.
Did anyone find solution?
