500 Internal server error

[dgonda]

Hey,

I preface this with this, I'm kinda new to power bi.

I have pbix file that is admittedly 4.93Gb (one of its table has 2.3 billion rows, I can't really make it any less). Whenever I try to publish it to the service, I get a 500 internal serve error. Any ideas as to why does this happen?

Edit: We are using power BI premium, so the 1Gb limit shouldn't be an issue.

[Anonymous]

Hi @dgonda ,

Is there anyone else face the same problem with you in your side? Whether the problem still persist? If the problem still persist, please try to do the operations in this thread and check whether it can resolve the problem.

1.  Enable large datasets

2. Exporting the file as a PowerBI template (File --> Export) , then reimporting it again which puts it into a blank pbix file. Try to re-publish it again.

3. Save the file on local file directory and check the file extension

Best Regards

[dgonda]

Large Datasets were enabled, I've already tried the template trick but it didn't work, and the extension was pbix, so it should be good. I've decreased the size of the file to around 1.5Gb and it went up without a hitch. I ditched some old data to decrease the size because only a few of our users watched them, but I still don't know why it wouldn't go up with all of the data. If that helps, when I tried to upload it from service, it crashed with a memory_limit_exceeded if I remember correctly.

[Anonymous]

Hi @dgonda ，

Thanks for your feedback. Which workspace did you publish the report to? Is that a workspace with diamond icon just as shown in below screenshot? And could you please try to publish to different workspace or upload the pbix file(Select the related premium workspace --> Get data --> Files --> Select the pbix file) in Power BI Service directly? Later check whether it got the same error message. Thank you.

Size limits to consider while choosing the right capacity

Best Regards

[dgonda]

Hi @Anonymous,

Yes, it was a premium workspace, we have 4 of them, I've tried uploading it to 2 of them via Power BI service -> Get Data, but failed with the same error message. Sadly I don't have the 5Gb pbix file anymore since I've downscaled it to around 1.5Gb as I've mentioned, so I can't really try to upload it anymore.

[Anonymous · Accepted solution]

Hi @dgonda ,

Which SKU the premium workspace is available in? P1 or other SKU? As describe in this official documentation: Depending on the SKU, Power BI Premium supports uploading Power BI Desktop (.pbix) model files up to a maximum of 10 GB in size. When loaded, the model can then be published to a workspace assigned to a Premium capacity. The dataset can then be refreshed to up to 12 GB in size. You should have at least a P1 or an A4 SKU for any datasets larger than 1 GB. And the size of your original file is 4.93 GB, the SKU type you need is at least P2 or higher as refer to the table below...

Best Regards

[amitchandak]

@dgonda , Log an issue https://community.powerbi.com/t5/Issues/idb-p/Issues