Starting December 3, join live sessions with database experts and the Microsoft product team to learn just how easy it is to get started
Learn moreShape the future of the Fabric Community! Your insights matter. That’s why we created a quick survey to learn about your experience finding answers to technical questions. Take survey.
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:
Solved! Go to 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 !!! |
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!!
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.
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!!
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!
@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 !!! |
This upload solution was a breeze. Thank you!
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?
Wow following your step 4 instructions worked!! Thank you soooo much for your help!
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 !!! |
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.
@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 !!! |
User | Count |
---|---|
92 | |
88 | |
88 | |
79 | |
49 |
User | Count |
---|---|
156 | |
145 | |
105 | |
72 | |
55 |