topic Re: Power BI API fails when exporting a report with a large dataset in Developer

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

MartinezData — Mon, 13 Apr 2026 19:44:42 GMT

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?

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

lbendlin — Mon, 13 Apr 2026 20:01:38 GMT

How large? More than 10 GB large?

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

Ray_Minds — Tue, 14 Apr 2026 04:34:37 GMT

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

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

Deku — Wed, 15 Apr 2026 18:27:42 GMT

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

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

v-echaithra — Fri, 17 Apr 2026 10:47:06 GMT

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.

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

v-echaithra — Mon, 20 Apr 2026 13:16:41 GMT

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.

topic Re: Power BI API fails when exporting a report with a large dataset in Developer

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

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

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

Hello @MartinezData , There are few of the suggestion mensioned you can also try.1. Enable Large Dataset Storage Format (in the Power Bi Service)

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

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

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

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

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