Forum Discussion
Error 500 Internal Server Error when publishing a PBIX file
Thanks Michael_Shao,
I think Power BI used to ask me if I wanted to replace the dataset before loading. But I don't get this prompt anymore Error 500 comes up.
The Fiddler Trace shows the following.
And the Power BI Trace shows the following.
{"dt":"e","ct":1472623943,"u":"ee15a6e3-f2f0-4151-8ab1-cdf70c42d9ff","su":"a76a725a-d92a-41c2-ab66-e539c239a37f","n":"PBI.Win.UploadReportToPowerBIService","attrs":{"backendUrl":"https://api.powerbi.com/","activityId":"79bc70ab-beb9-4593-a5cf-eea4964dd4a2","requestId":"7c0485f6-b0b3-4432-8bef-0be23efa7daa","canceled":"False","httpStatusCode":"","exceptionType":"","errorCode":"","errorDetails":"","parentId":"7b788786-5e50-4c00-817b-82f8ca57b174","isError":"False","duration":"0 - 100ms","client":"WinDesktop","build":"2.38.4491.282 (PBIDesktop)","uiCulture":"en-US","clientCulture":"en-AU","isInternal":"False"}}
{"dt":"e","ct":1472623947,"u":"1e1ed5c0-f74f-4578-b7f1-78da446620ee","su":"a76a725a-d92a-41c2-ab66-e539c239a37f","n":"PBI.PQ.PublishingFailedInternal","attrs":{"backendUrl":"https://api.powerbi.com/","activityId":"79bc70ab-beb9-4593-a5cf-eea4964dd4a2","requestId":"7c0485f6-b0b3-4432-8bef-0be23efa7daa","httpStatusCode":"500","exceptionType":"Microsoft.PowerBI.Client.Windows.PowerBIService.PowerBIServiceException","errorCode":"ExcelWorkbookAlreadyImported","errorDetails":"{\"code\":\"ExcelWorkbookAlreadyImported\",\"pbi.error\":{\"code\":\"ExcelWorkbookAlreadyImported\",\"parameters\":{},\"details\":[]},\"error\":{\"code\":\"ExcelWorkbookAlreadyImported\",\"pbi.error\":{\"code\":\"ExcelWorkbookAlreadyImported\",\"parameters\":{},\"details\":[]}}}","entryPoint":"EditorRibbonButtonPowerBISharePublish","message":"UnexpectedError","activeView":"Reports","actionId":"PublishingFailedInternal","parentId":"7b788786-5e50-4c00-817b-82f8ca57b174","isError":"True","client":"WinDesktop","build":"2.38.4491.282 (PBIDesktop)","uiCulture":"en-US","clientCulture":"en-AU","isInternal":"False"}}
Sorry that I can't load this in OneDrive. Our organisation actually doesn't have OneDrive set up.
It sounds like Power BI isn't asking me whether I want to replace the dataset with the existing, anymore. Is there a way that I can re-enable this in Power BI?
I will also reinstall/repair Power BI to see if that helps.
Update: I repaired Power BI. No difference in outcome. Power BI doesn't ask if I want to replace the dataset, instead jumping straight to Error 500.
Hi samngai,
Thanks for the update.
The error code in the fiddler tool showed that"ExcelworkbookAlreadyImported", there is nothing else helpful that I could find out from the trace information posted.
The trace from my side didn't show any errors when re-publish the PBIX file.
I will report this and if any further update, will post back.
Regards
samngai, like Michael I can't reproduce your issue either. Would you mind uninstalling Power BI Desktop completely to install it again? You can get the PBI Desktop from the link: https://powerbi.microsoft.com/en-us/desktop/
Hi Michael and Vicky. A complete uninstall, reboot, and reinstall did not fix the issue. But it does seem like I am the only one impacted.
samngai, your issue looks strange to me. I will try to involve other senior engineers.
