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.
Next refresh for name_of_the_file is scheduled for 01/13/2017 07:45:00.