Skip to main content
cancel
Showing results for 
Search instead for 
Did you mean: 

Don't miss out! 2025 Microsoft Fabric Community Conference, March 31 - April 2, Las Vegas, Nevada. Use code MSCUST for a $150 discount. Prices go up February 11th. Register now.

Reply
Anonymous
Not applicable

Odata -Unable to read data from the transport connection: An existing connection was forcibly closed

Hi,

 

I have build few OData based PBIX files. All of the refresh fine in Power BI desktop but when refresh is schedued from PBI-RS (March 2018 Update), One of them fails with following error. Only difference between the one which refresh fine and the one which does not is that it has little larger sized datasets. However they all refresh fine in Power BI Desktop without any issue.

 

When refresh failes, following error is logged in RSPowerBI_2018_*****.log file

 

2018-05-23 16:00:05.6798|INFO|27|Processing Data Model Refresh: SessionId: db7ae921-481f-4904-998e-afcbe5fa3cff, Status: Starting Data Refresh.
2018-05-23 16:00:05.6798|INFO|27|Processing Data Model Refresh: SessionId: db7ae921-481f-4904-998e-afcbe5fa3cff, Status: Starting Retrieving PBIX AsDatabaseInfo.
2018-05-23 16:00:05.7258|INFO|27|Processing Data Model Refresh: SessionId: db7ae921-481f-4904-998e-afcbe5fa3cff, Status: Starting Verifying all the data sources are embedded.
2018-05-23 16:00:05.7258|INFO|27|Processing Data Model Refresh: SessionId: db7ae921-481f-4904-998e-afcbe5fa3cff, Status: Starting Verifying connection strings are valid.
2018-05-23 16:00:05.7328|INFO|27|Processing Data Model Refresh: SessionId: db7ae921-481f-4904-998e-afcbe5fa3cff, Status: Starting Streaming model to Analysis Server.
2018-05-23 16:00:06.2848|INFO|27|Processing Data Model Refresh: SessionId: db7ae921-481f-4904-998e-afcbe5fa3cff, Status: Starting Refreshing the model.
2018-05-23 16:02:11.2116|ERROR|27|Error Processing Data Model Refresh: SessionId: db7ae921-481f-4904-998e-afcbe5fa3cff, Status: Error Failed to refresh the model, Exception Microsoft.AnalysisServices.OperationException: Failed to save modifications to the server. Error returned: '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.
The command has been canceled.. The exception was raised by the IDataReader interface.
'.
   at Microsoft.AnalysisServices.Tabular.Model.SaveChanges(SaveOptions saveOptions)
   at Microsoft.PowerBI.ReportServer.AsServer.TOMWrapper.RefreshModel(Database database)
   at Microsoft.PowerBI.ReportServer.AsServer.AnalysisServicesServer.RefreshDatabase(String databaseName, IEnumerable`1 dataSources, String clientSessionId)
   at Microsoft.PowerBI.ReportServer.WebHost.EventHandler.AnalysisServicesDataRefresh.RefreshDatabase(AsDatabaseInfo asDatabaseInfo)
   at Microsoft.PowerBI.ReportServer.WebHost.EventHandler.DataRefreshScope.<>c__DisplayClass9.<ExecuteActionWithLogging>b__7()
   at Microsoft.PowerBI.ReportServer.WebHost.EventHandler.DataRefreshScope.<ExecuteFuncWithLogging>d__3`1.MoveNext()

On few occasions, I have noticed that my scheduled refresh from PBI-RS succeed without any error. That makes me think that it has to be related to some timeout but logs are not verbose enough to point to a specific timeout setting. I have tried play around with following rsreportserver.config settings but none has helped

 

  <Add Key="DatabaseQueryTimeout" Value="300" />
  <Add Key="RunningRequestsScavengerCycle" Value="300" />
  <Add Key="RunningRequestsDbCycle" Value="300" />
  <Add Key="RunningRequestsAge" Value="300" />

I have also added following config entries in msmdsrv.ini but again no luck

 

 <ExternalCommandTimeout>3600</ExternalCommandTimeout>
<ExternalConnectionTimeout>600</ExternalConnectionTimeout>
<ForceCommitTimeout>600000</ForceCommitTimeout>

Please let me know how can I get around this error.

Thanks...

0 REPLIES 0

Helpful resources

Announcements
Las Vegas 2025

Join us at the Microsoft Fabric Community Conference

March 31 - April 2, 2025, in Las Vegas, Nevada. Use code MSCUST for a $150 discount! Prices go up Feb. 11th.

Jan25PBI_Carousel

Power BI Monthly Update - January 2025

Check out the January 2025 Power BI update to learn about new features in Reporting, Modeling, and Data Connectivity.

Jan NL Carousel

Fabric Community Update - January 2025

Find out what's new and trending in the Fabric community.