Forum Discussion
Error 500 Internal Server Error when publishing a PBIX file
Hi samngai,
I tested with Power BI desktop August Update version, but didn’t encounter the 500 error when publishing old PBIX file to Power BI service.
A republish would remind me if I would like to replace the dataset.
To investigate further, please follow the steps below:
- Check the temp folder, C:\Users\User name\AppData\Local\Power BI, find the latest file after reproduce the issue and open it with notepad;
- Enable Tracing under Power BI Desktop File->Options and settings->Options->GLOBAL->Diagnostics, select Enable Tracing;
- Generate a Fiddler trace. (Fiddler Web Debugger Tool)
If available, upload them into OneDrive and post the shared link here. We will help to take a look.
In addition, try to take a reinstall or a repair of the Power BI desktop, see if this would make any difference.
Regards
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/
