Forum Discussion

MartinezData's avatar
MartinezData
New Member
4 months ago
Solved

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 Fo...
Need Help
  • Ray_Minds's avatar
    Ray_Minds
    4 months ago

    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

     

v-echaithra's avatar
v-echaithra
Community Support
4 months ago

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.