Large Imported Dataset Publishing failure

[ron_holyfield]

Are any of you experiencing issues publishing large (100 MB or larger), imported datasets? We have several individuals that have stated that it fails with this message:

   "Unable to write data to the transport connection: An existing connection was forcibly closed by the remote host"

These are targeted to Premium Workspaces so it's not due to limits and had worked prior to this week. 

[v-easonf-msft]

Hi,  @ron_holyfield 

You can test whether this is caused by an oversized data model by reducing the amount of data.

Please refer this related post:

https://community.powerbi.com/t5/Desktop/quot-Unable-to-write-to-the-transport-connection-quot/td-p/...

https://community.powerbi.com/t5/Desktop/Using-Power-Bi-with-Large-Datasets/td-p/379116

In addition ,using 'DirectQuery connection mode'  instead of 'import connection mode' could be a better choice.

Best Regards,
Community Support Team _ Eason
If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.

[ron_holyfield]

I'm the PBI admin and am not the specific person experiencing the issue.  Direct Query is the typical default mode but Import is utilized by the user community when performance is causing issues. Thx.

[GilbertQ]

Yeah i would suggest having a look at the PBIX and see if there is anything unusual going on with it.

[GilbertQ]

Hi there

Can you make sure that you have got enough capacity on your Premium Node by checking the Premium Capacity metrics App?

Also can you make sure that your connectivity is good and working when uploading?

The error could indicate network issues.

[ron_holyfield]

Defintitely enough capacity.  This is for another user, not my specific issue.  I'm going have them provide me with the file and I'll try on my end.  Thx.