Error upload pbix file to PowerBI website

[ZsoltV]

Hello, I have several running reports on PowerBI website created in Desktop app. However I have one report where I'm getting an error message: An error occurred while attemping to publish 'LPA.....pbix'. The remote server returned an error : (500) Internal Server Error. The file contains 9 sheets only. What can I do to resolve the publishing issue? Thanks, Zsolt

[ZsoltV]

Hello @v-lili6-msft ,

Thanks for your reply. I read the linked post, doesn't work for me.

I cannot use the Get data or I misunderstand where to find. In the Desktop app I can see this:

There is no possibility to choose an existing pbix file.

I tried also to save it as a template and re-import and publish -> same server error.

I tried to delete some old report from the web service than publish -> same server error.

My desktop is Version: 2.71.5523.941 64-bit (re-installed right now).

[ZsoltV]

I tried to import directly to the web surface through the 'Get Data'.

This is the detail error message I get:

We couldn't import data from Power BI Desktop File

The last refresh attempt failed because of an internal service error.
Please try again later or contact support. If you contact support, please provide these details.

Processing error

The relationship '9b59fadd-a531-463f-ba7b-980fd4a7a7cc' is invalid because an AlternateOf table cannot be the ToTable in a relationship with a cardinality of one.

Activity ID1c3b81a3-fd12-423d-aae3-cf9b5af89262

Correlation IDf887e0ce-bd57-4d58-6324-79ad2d7f6f18

Request ID0f57a873-6505-bad9-a915-342f81134076

Status code500

TimeTue Jul 30 2019 14:51:34 GMT+0200 (Central Europe Daylight Time)

Version13.0.10246.182

Cluster URIhttps://wabi-west-us-redirect.analysis.windows.net

Regards, Zsolt

[v-lili6-msft]

hi, @ZsoltV 

If you could update the power bi desktop to the lastest version, and what is size of the pbix file?

If you could try to publish the report via Get Data -> Files on Power BI service, check if the publish can be finished successfully. 

and here is a similar post, you may refer to it:

https://community.powerbi.com/t5/Report-Server/500-Internal-server-error-appears-after-the-publishin...

Best Regards,

Lin