Unanle to publish pbix to power BI

[RL1]

On attempting to publish a pbix file to my cloud workspace I keep seeing the following message:

An error occurred while attempting to publish '###.pbix: Unable to write data to the transport connection: An existing connection was forcibly closed by the remote host.

I have seen a few other threads referencing this error but have not yet found a solutin that works.

The pbix file is ~44MB and contains data from 8 Excel files.  I have run into this error for several pbix documents and have not been able to publish any of them, however, I do have other (smaller) files that I can publish without issue.

Any thoughts on what can cause this error & how to get past it?

Thanks

[RL1]

Update:

I've been testing various things to try and determine why my pbix file won't upload and found that I have one particular Excel file, that, if included in a PowerBI desktop report, means the file cannot be uploaded and causes the error message to appear.  I've tried renaming the Excel file and loading the data into a new PowerBI desktop instance but this still results in the error and a failed upload.  The Excel file is ~2MB and has ~10000 rows, nothing I'd think would cause any issues.

Has anyone experienced similar issues or perhaps know of any differences between what data is allowed on the desktop and cloud versions of Power BI?

Thanks.

[v-haibl-msft]

@RL1

Could you please share the excel file which can cause the publish problem to me? I’d like to have a try locally.

Best Regards,

Herbert

[RL1 · Accepted solution]

Hi,

Thanks for the offer but I think I've now figured out the problem.  I have a date column with many values of '31-Dec-9999'.  A 50kb Excel file containing just this column results in a 40MB PowerBI file when loading in the data, unless you disable 'auto time/date' in the options menu for the PowerBI file.  After doing this file file can be published - I don't know whether its a bug or a "feature" that the file can't be published otherwise...

 

Thanks anyway.

[egosselin]

on my side, I have the same error code. but unchecking the auto date didn't solve the problem....

although, when I use a vpn or an other network, it does work.

at first I tought it was my network. but can't pinpoint the problem exactly. I'm looking for the "how to" to make a "tracrt" with the powerBI server...

[RaphaelQueiroz]

---

@egosselin wrote:

on my side, I have the same error code. but unchecking the auto date didn't solve the problem....

although, when I use a vpn or an other network, it does work.

at first I tought it was my network. but can't pinpoint the problem exactly. I'm looking for the "how to" to make a "tracrt" with the powerBI server...

---

How about this VPN? How can I use it? I'm having the same issue

[v-haibl-msft]

@RL1

Please try the solution posted here to see if it helps.

Best Regards,

Herbert

[RL1]

v-haibl-msft

Sadly not.  

I'm unable to publish to my workspace or to a group, the same error message appears for both.  I've not been able to upload this file at all so as far  - so as far as I'm aware its not updating or replacing any data.

I've also used  'save as' in PowerBI desktop to create a new file and tried uploading this, but that also gets the same error.

Thanks. 

[RL1]

Here's  a section from the end of a trace file. It doesn't mean anything to me but may be helpful:

Spoiler

DataMashup.Trace Information: 24579 : {"Start":"2017-01-31T16:41:55.0394168Z","Action":"ClientConfigStorage/GetClientConfig","ClientConfig":["2.42.4611.901",[["ClientExpiryDateTime","2015/01/01"],["ClientExpiryVersion","0.0.0.0"],["ClientUpdateLocation","https://go.microsoft.com/fwlink/?LinkID=524795"],["ClientUpdateVersion","2.42.4611.700"],["PublishFi... (PBIDesktop)","ActivityId":"00000000-0000-0000-0000-000000000000","Process":"PBIDesktop","Pid":6504,"Tid":49,"Duration":"00:00:00.0000489"}
DataMashup.Trace Warning: 24579 : {"Start":"2017-01-31T16:41:55.1209350Z","Action":"PBI.Win.UploadReportToPowerBIService","Message":"{\"backendUrl\":\"https://wabi-europe-north-b-redirect.analysis.windows.net/\",\"activityId\":\"61e104e2-d5b3-4339-b05... (PBIDesktop)","ActivityId":"08ee202b-dfcc-4a70-807c-3a3320edbe5f","Process":"PBIDesktop","Pid":6504,"Tid":49,"Duration":"00:00:01.8878742"}
DataMashup.Trace Warning: 24579 : {"Start":"2017-01-31T16:41:59.0267206Z","Action":"PBI.Win.UploadReportToPowerBIService","Message":"{\"backendUrl\":\"https://wabi-europe-north-b-redirect.analysis.windows.net/\",\"activityId\":\"61e104e2-d5b3-4339-b05... (PBIDesktop)","ActivityId":"971cdead-dd40-40c6-8738-226fa5303161","Process":"PBIDesktop","Pid":6504,"Tid":49,"Duration":"00:00:01.1795945"}
DataMashup.Trace Warning: 24579 : {"Start":"2017-01-31T16:42:04.2232153Z","Action":"PBI.Win.UploadReportToPowerBIService","Message":"{\"backendUrl\":\"https://wabi-europe-north-b-redirect.analysis.windows.net/\",\"activityId\":\"61e104e2-d5b3-4339-b05... (PBIDesktop)","ActivityId":"284b8604-6fca-412d-953f-c6facdfcd8a1","Process":"PBIDesktop","Pid":6504,"Tid":49,"Duration":"00:00:01.8308901"}
DataMashup.Trace Warning: 24579 : {"Start":"2017-01-31T16:42:06.0725991Z","Action":"PBI.PQ.PublishingFailedInternal","Message":"{\"backendUrl\":\"https://wabi-europe-north-b-redirect.analysis.windows.net/\",\"activityId\":\"61e104e2-d5b3-4339-b05... (PBIDesktop)","ActivityId":"ce61cf16-4a97-4bb8-9773-6226eb01a3d4","Process":"PBIDesktop","Pid":6504,"Tid":1,"Duration":"-00:00:00.0139724"}
DataMashup.Trace Information: 24579 : {"Start":"2017-01-31T16:42:14.4009313Z","Action":"PackageSessionStorage/GetSessionStorage","PackageReference":[["4ee7b37b-34f7-4f4a-b064-5263cb500175"],[24]],"ProductVersion":"2.42.4611.901 (PBIDesktop)","ActivityId":"00000000-0000-0000-0000-000000000000","Process":"PBIDesktop","Pid":6504,"Tid":1,"Duration":"00:00:00.0000548"}
DataMashup.Trace Information: 24579 : {"Start":"2017-01-31T16:42:14.4009782Z","Action":"PackageStorage/Access","PackageReference":[["4ee7b37b-34f7-4f4a-b064-5263cb500175"],[24]],"ProductVersion":"2.42.4611.901 (PBIDesktop)","ActivityId":"00000000-0000-0000-0000-000000000000","Process":"PBIDesktop","Pid":6504,"Tid":1,"Duration":"00:00:00.0006678"}
DataMashup.Trace Information: 24579 : {"Start":"2017-01-31T16:42:14.4018793Z","Action":"SharedLocalStorageAccessor/AcquireMutex","ProductVersion