Forum Discussion
Power BI API fails when exporting a report with a large dataset
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?
Hello MartinezData , There are few of the suggestion mensioned you can also try.
1. Enable Large Dataset Storage Format (in the Power Bi Service)- Go to your dataset in Power BI Service
- Open Settings
- Enable Large dataset storage format
- 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
5 Replies
Hello MartinezData , There are few of the suggestion mensioned you can also try.
1. Enable Large Dataset Storage Format (in the Power Bi Service)- Go to your dataset in Power BI Service
- Open Settings
- Enable Large dataset storage format
- 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
How large? More than 10 GB large?
If you just need the definition and not the data you can use fabric API get item definition
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.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.
