Slow Overwrite Publishing to the PBI Service

[gregentrican]

Does anyone know how to resolve slow overwrite publishing of datasets/reports? It does not seem that anyone has posted anything concerning this since 2018, and it "seems" that the issue must have been resolved with a new desktop release at that time. The overwrite publishing of datasets/reports can take a long long time, but strangely this is not always true. The time this takes is very inconsistent. If it the dataset/report does not exist, the publish to the service is quick. When it is an overwrite publish it can take hours. What is causing this? Was it a new release that is casuing this? How can this be resolved?

[gregentrican · Accepted solution]

This worked for me. Go to the service, hit the Get Data button (bottom left), choose Local file, browse to the .pbix file, and upload.

https://community.powerbi.com/t5/Service/Error-when-Publishing-The-remote-server-returned-an-error-4...

[Triple_Agent]

Finally somebody else with this issue! For the last week or more, publishing has gone from a 30s process to a sometimes 30+ minute ordeal. Just like you said, it only seems to happen if overwriting an existing report/dataset. I've even had a few instances where publishing fails with an internal server error message (500). Also, Power BI desktop has randomly been signing me out when I try to publish.

It might be unrelated, but our dataflow refresh times have gone from 3 or 4 minutes to 2+ hours and even timing out at the 3 hour mark occasionally. I've tried updating Power BI desktop, and the data gateway to no effect.

Lastly, even browsing PowerBI.com has gotten slow periodically and won't load the workspace or reports.

Hopefully we can get some kind of offical word on this.