Error 500 when publishing

[QS7]

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 )

[v-rongtiep-msft]

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.

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]

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.