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

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

 

Error500.PNG

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

12 REPLIES 12
v-micsh-msft New Contributor
New Contributor

Re: 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:

  1. 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;
  2. Enable Tracing under Power BI Desktop File->Options and settings->Options->GLOBAL->Diagnostics, select Enable Tracing;
  3. 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

samngai Frequent Visitor
Frequent Visitor

Re: 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.

 

 Error500-2.PNG

 

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-... - 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-... (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.

v-micsh-msft New Contributor
New Contributor

Re: Error 500 Internal Server Error when publishing a PBIX file

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

 

Vicky_Song Established Member
Established Member

Re: Error 500 Internal Server Error when publishing a PBIX file

@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/ 

samngai Frequent Visitor
Frequent Visitor

Re: Error 500 Internal Server Error when publishing a PBIX file

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.

Vicky_Song Established Member
Established Member

Re: Error 500 Internal Server Error when publishing a PBIX file

@samngai, your issue looks strange to me. I will try to involve other senior engineers. 

Vicky_Song Established Member
Established Member

Re: Error 500 Internal Server Error when publishing a PBIX file

@samngai, I need further information from your side:

1). Are there any proxy servers set in the environment?

2). Are you able to import the PBIX file into the service from the Get Data portion within the PBI service?

samngai Frequent Visitor
Frequent Visitor

Re: Error 500 Internal Server Error when publishing a PBIX file

Hi Vicky,

 

1) Yes there are proxy servers in the environment. I'm guessing this is what's contributing to the issue. Though the issue only appeared in recent times so I'm wondering whether there's a change in how Power BI Desktop connects to the cloud, or whether it's a change in our proxy settings.

 

2) Importing the PBIX into the service via PBI Service Get Data works in refreshing the report when the underlying Excel spreadsheet's structure does not change.
But if we update the underlying Excel (e.g. add additional columns and link visualisations to the new columns), then upload via PBI Service Get Data, the charts will not work. In the example below, "Agree", "Partially Agree", "Partially Disagree", and "Disagree" are all additional columns that we added to the Excel spreadsheet prior to an upload.

 

Data.PNG

Highlighted
HowardB Frequent Visitor
Frequent Visitor

Re: Error 500 Internal Server Error when publishing a PBIX file

Hi,

 

I am having this issue also with a newly created pbix file, exact same error message, except filename is obviously different. I have tried refreshing and saving data before attempting to publish, I get no error messages when I do this to make me think there is a problem with the data but when I try to publish I get an error 500. Is there an internal log file I can access that might give more detail as to the cause of the error, its kind of annoying and a bit of a show stopper

 

thanks

 

HowardB

Helpful resources

Announcements
Community News & Announcements

Community News & Announcements

Get your latest community news and announcements.

Summit North America

Power Platform Summit North America

Register by September 5 to save $200

Virtual Launch Event

Microsoft Business Applications Virtual Launch Event

Watch the event on demand for an in-depth look at the new innovations across Dynamics 365 and the Microsoft Power Platform.

MBAS Gallery

Watch Sessions On Demand!

Continue your learning in our online communities.

Users Online
Currently online: 202 members 2,743 guests
Please welcome our newest community members: