Power BI API fails when exporting a report with a large dataset

[MartinezData]

I'm getting status code 500 when using this endpoint with a report with a large dataset: 

https://learn.microsoft.com/en-us/rest/api/power-bi/reports/export-report-in-group

Large Dataset Storage Format is disabled for this report.

Is there anything I can do to export it using the API?

[v-echaithra]

Hi @MartinezData ,

May I ask if you have resolved this issue? Please let us know if you have any further issues, we are happy to help.

Thank you.

[v-echaithra]

Hi @MartinezData ,

Thank you @Ray_Minds , @Deku  for your inputs.
We’d like to follow up regarding the recent concern. Kindly confirm whether the issue has been resolved, or if further assistance is still required. We are available to support you and are committed to helping you reach a resolution.

Thank you.

[Deku]

If you just need the definition and not the data you can use fabric API get item definition 

[Ray_Minds · Accepted solution]

Hello @MartinezData  , There are few of the suggestion mensioned you can also try.

1. Enable Large Dataset Storage Format (in the Power Bi Service)

1. Go to your dataset in Power BI Service
2. Open Settings
3. Enable Large dataset storage format
4. Refresh the dataset

Or via XMLA / Tabular Editor:

• Set:  DefaultPowerBIDataStorageFormat = Large
  This is the only reliable fix for large exports via API.

2. Reduce the export scope (workaround)

If you can’t enable large dataset format, try:

• Exporting specific pages only
• Applying filters to reduce data volume
• Avoiding visuals with heavy queries

This may work if you stay under internal limits—but it’s not guaranteed because its depend on the data voulume and Dax calculation, how heavely used.

3. Use alternative export methods like mensioned below.

• Paginated reports (RDL) handle large exports better
• Break the dataset/report into smaller chunks

[lbendlin]

How large?  More than 10 GB large?