Forum Discussion
Error 500 Internal Server Error when publishing a PBIX file
Hi,
With the August 24 release of Power BI I am getting an error where I am unable to publish my PBIX files to powerbi.com.
The error message that I get is
I get this error with all of my pre-existing Power BI reports. (These are all reports that connect to a local excel spreadsheet.)
The strange thing is that if I take a copy of any of these files, paste as a new name (e.g. Insurance2.pbix), and then publish to powerbi.com, that first-time publish will work. But if I were to attempt a republish of this new file, it will come up with the same error message.
Prior to the August release, I was intermittently getting the Error 400 issue outlined by another user. The only solution I had was to delete the report and dataset, then republish, but that was a pain because each report would have a new URL and I would have to repin the visuals. It makes it difficult to get wider scale adoption of powerbi in our organisation.
Is anyone else getting this Error 500?
Sam
15 Replies
I have the same issue and it seems that after 5 years, no one came with a solution to this problem, how is this possible?
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
I am also getting same error while publishing report using Azure HDInsight Spark connector to connect to Hive tables.
I already posted a question on community : Link
Even tried to get data from Spark connector in Power BI service, i am getting error "We are unable to establish connection, please check connection information."
Please let me know if you are able to resolve the issue or you got any solutions/workarounds.
I also get the same error.
Hi,
I'm having the same error when attempting to publish a Power Bi file to a workspace on Power Bi Service. I already tried to import it to my workspace on Power BI Service and it doesn't do it!
I already tried to publish the same file with a diferent name but it doesn't work either.
I'm using the following version: 2.65.5313.841 64-bit (December 2018).
Can anyone help me please?
Thanks in advance.
Best regards,
LMFC
Hello,
I'm having the same issue trying to republish a report based on an existing PBI dataset.
I've already tried a lot of things like reinstalling PBI and even downloading the PBIX file from the service and publishing it again. The result is the same... It's really painful
Does someone can help here?
Thank you very much in advance.
Best
Laverdie
Year 2023, same issue... No fix yet? 😞
