Help! Couldn't publish to Power BI: An Existing Connection was forcibly closed by remote host error

[jenyueh]

For the past 2 weeks, I am getting the "Couldn't publish to Power BI: An Existing Connection was forcibly closed by remote host" error when I tried to publish a dashboard that I have published many times before. I am only having issue with 1 dashboard. I can publish other dashboards in the same workspace with no issues.

Some information:

• Power BI desktop March 2023 version
• Power BI services linked to Office 365
• Other team members can publish this dashboard successfully so the data size is not an issue.

[Anand24 · Accepted solution]

@jenyueh ,
Point 4: You can Go to Power BI service, Get Data-> Files to get pbix files, this has the same effect as publish from desktop
> Go to required workspace and try uploading the .pbix directly from there using below option

Point 5: If above methods are not working, please run Fiddler with Decrypt Https traffic enabled and repeat publish steps to reproduce the issue and post the related message for fur discussion
> Fiddler is separate software which needs to be installed in your system. It helps in checking the logs at the browser level which then helps in debugging issues
> Microsoft Documentation: https://learn.microsoft.com/en-us/power-query/web-connection-fiddler
> If you are not thorough with Fiddler or you can't install in your organization's system due to security concerns, please raise a service ticket with Microsoft

Give a Thumbs Up if this post helped you in any way and Mark This Post as Solution if it solved your query !!! Proud To Be a Super User !!! LinkedIn

[QuantusPools]

One more solution I found was my actual my PowerBI dataset was refreshing in PowerBI service.  Once I cancelled that, I was able to publish the report. 

[jenyueh · Accepted solution]

For all viewers who read this post, I have an update. I actually found a solution that fixed my issue where now I can publish my dashboard from Power BI desktop again!

The solution is to clear cache. From the dashboard on Power BI desktop, go to File --> Options and Settings --> Options, under Data Load, clear all cache shown in the screenshot below. After I cleared all the cache, I was able to publish my dashboard again!!

[jenyueh]

Hi @Anand24, 

I actually saw this post before. The first 3 points are not applicable. Can you help me with point 4 and 5?

Really appreciate your help!

[Anand24 · Accepted solution]

@jenyueh ,
Point 4: You can Go to Power BI service, Get Data-> Files to get pbix files, this has the same effect as publish from desktop
> Go to required workspace and try uploading the .pbix directly from there using below option

Point 5: If above methods are not working, please run Fiddler with Decrypt Https traffic enabled and repeat publish steps to reproduce the issue and post the related message for fur discussion
> Fiddler is separate software which needs to be installed in your system. It helps in checking the logs at the browser level which then helps in debugging issues
> Microsoft Documentation: https://learn.microsoft.com/en-us/power-query/web-connection-fiddler
> If you are not thorough with Fiddler or you can't install in your organization's system due to security concerns, please raise a service ticket with Microsoft

Give a Thumbs Up if this post helped you in any way and Mark This Post as Solution if it solved your query !!! Proud To Be a Super User !!! LinkedIn

[EllenG]

This upload solution was a breeze.  Thank you!

[jenyueh]

Hi @Anand24, 

Sorry to bother you again. I was able to re-publish my dashboard yesterday by following step 4. But today when I tried it again with the same step by uploading the dashboard, it did not give me any error, but the dashboard is also not updated. What am I doing wrong?

[jenyueh]

@Anand24, 

Wow following your step 4 instructions worked!! Thank you soooo much for your help!

[Anand24]

Hi @jenyueh ,
What is the data source being used? Has there been any change of permission since you last published this dataset?
Have you tried publishing it to any other workspace?

Give a Thumbs Up if this post helped you in any way and Mark This Post as Solution if it solved your query !!! Proud To Be a Super User !!! LinkedIn

[jenyueh]

Hi, 

The data source is a bunch of Excel/CSV files that I imported. I have not changed any permissions since the last time I was able to publish this dashboard. As I said, another team member in my team can publish this dashboard without any problems.

I have also tried to publish it in my own workspace, which I got the same error. But I was also able to publish it in my workspace before.

[Anand24]

@jenyueh ,
You can go through the reply 5 of below post:
https://community.powerbi.com/t5/Desktop/Couldn-t-publish-to-Power-BI-An-Exixting-Connection-was-for...

Since the issue is user-specific, you should raise a concern with MS Support since only they will be able to check the logs and provide more information. Do let them know that the issue is user-specific and is not workspace specific.

Give a Thumbs Up if this post helped you in any way and Mark This Post as Solution if it solved your query !!! Proud To Be a Super User !!! LinkedIn