Refresh passed in the desktop, but failed in the service.message is "An existing connection was..."

[Kelly_Zhu]

Hi Everyone,

My report can completed refresh in the desktop and publish successfully, but refresh in the service failed after new year holiday.

The message is "Odata: 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."

Could you help me to fix this? Thank you in advance!

Regards,

Kelly

[Ons]

Hi,

We're facing the same issue since the last month and still the same error when refreshing on the service,

Does anyone find out a solution ?

[Kelly_Zhu]

Hi,

The reason of the issue I faced is too large datasize, much large than limitation of PBI Service and there is no solution.

[monty]

Our customers receive this error with OData downloads of little larger than 10 MB (compressed size). Do you happen to know the actual limitation of PBI service? The error typically occurs one minute after the OData payload has been downloaded.

[Kelly_Zhu]

My dataset don't use data gateway, so I don't need to make sure if my gateway is the latest.

[v-shex-msft]

Hi @Kelly_Zhu,

Can you please share more detail informations about this issue?
Based on your error message, I think it may related to odata setting, perhaps you can take a look at below link:

unable to read data from the transport connection an existing connection was forcibly closed by remo...

Regards,

Xiaoxin Sheng

[Kelly_Zhu]

Hi Xiaoxin,

Could you tell me which kind of detail information I need provide?

Thanks,

Kelly

[v-shex-msft]

HI @Kelly_Zhu,

>>Could you tell me which kind of detail information I need provide?

For example: Odata instance setting, detail error log, proxy setting(if you enabled)

BTW, based on your error message, I think this issue more related to your odata server side.

Regards,

Xiaoxin Sheng

[Kelly_Zhu]

Hi Xiaoxin,

Thanks for your reply!

Could you tell me how to find out my odata server?

Thanks,

Kelly

[v-shex-msft]

Hi @Kelly_Zhu,

I think you can also submit a support ticket for further support.

Regards,

XIaoxin Sheng

[Kelly_Zhu]

Hi xiaoxin, Sure. I have submitted a ticket when I find this issue. Thanks, Kelly

[bajee]

Hi,

Many peoples are facing the same issues from new year onwards.

Even i'm also facing the refresh issue in power bi service.

Regards,

Bajee.