cancel
Showing results for 
Search instead for 
Did you mean: 
Reply
QS7
Frequent Visitor

Error 500 when publishing

Hi everyone,
I currently have an issue when i'm trying to publish my dataset on Power BI Service ( On a premium workspace ).
The dataset is 2GB wide, in composite mode ( Import Mode + Direct Query ).

When i'm trying to publish the dataset on my workspace i got the following error : 'an error occured while attempting to publish 'Report.pbix'": the remote server returned an error: (500) Internal server error'.
Then if i look into my workspace i can find that the report has been published twice with the same name. I tried to delete it multiple times and republish it. It always display the error, and sometime the report is published twice, sometime once.

Does anyone know how to fix this issues ? ( There were many topics on the subject but without any solution )

 

2 REPLIES 2
v-polly-msft
Community Support
Community Support

Hi @QS7 ,

 

Please refer to the following steps to see if it helps you.

  • It may be some type of file corruption. Please manage to fix by exporting it as a Power BI template (file menu - export) and then reimporting it again which puts it into a blank pbix file. It then will be able to re-publish successfully.
  •  Please log on Power Bi Service, upload your pbix files via Get Data -> Files -> Local file to check whether they can be published successfully.
  • Enable large datasets. In the service > dataset > Settings, expand Large dataset storage format, click the slider to On, and then click Apply.

33.png

 

Please refer to the following topic for details.

https://community.powerbi.com/t5/Report-Server/500-Internal-server-error-appears-after-the-publishin...

 

 

 

Best Regards

Community Support Team _ polly

 

If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.

ibarrau
Super User
Super User

Hi. This is very weird error. I think I have heard about it. It might sound strange but that how my friend got it done. They changed the name of the report and published again. They were able to share again and keep it calm for the moment. Days later they were able to delete duplications of 500 error. There is a cache after that error that won't let you delete the reports for some time.

I hope that helps, I'm assuming you have a P1 and it's not a problem of small capacity.


If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.

Happy to help!

LaDataWeb Blog

Helpful resources

Announcements
Power BI Show Episode 10 Recap

The Power BI Community Show

Watch the playback when Amit Chandak, a Power BI Super User, demos how to use Field Parameters to make reports more dynamic.

Power BI Dev Camp Session 26

New Date - Check it Out!

Mark your calendars and join us on Thursday, October 6 at 11a PDT for a great session with Ted Pattison!

Health and Life Sciences Power BI User Group

Health and Life Sciences Power BI User Group

Power BI specialists at Microsoft have created a community user group where customers in the provider, payor, pharma, health solutions, and life science industries can collaborate.

Ignite 2022

What's Next at Microsoft Ignite 2022

Explore the latest innovations, learn from product experts and partners, level up your skillset, and create connections from around the world.

Top Solution Authors