Forum Discussion

luanlopes's avatar
luanlopes
Icon for Advocate II rankAdvocate II
1 year ago
Solved

Error exporting report via API: ServerError_PremiumFilesErrors_OperationIsNotSupportedForPremiumFile

Hello,
I'm encountering an error while trying to export Power BI reports via the API on behalf of clients who use our integrated solution.

I'm using the following API endpoint:

 

POST https://api.powerbi.com/v1.0/myorg/groups/{groupId}/reports/{reportId}/Export

 

 Most reports are being exported without issues. However, when attempting to export, I receive the following error:

 

ServerError_PremiumFilesErrors_OperationIsNotSupportedForPremiumFilesModel

 

This report is quite large (approximately 3GB) and was published directly to the workspace through the Power BI Service.

  • Hi. Make sure your workspace has dedicated capacity enabled. Then, take a look at exporting limitations in order to check if you are missing something for this file:

    https://learn.microsoft.com/en-us/power-bi/create-reports/service-export-to-pbix#limitations-when-downloading-a-report-pbix-file

    For example, a common issue is: 

    • Reports that are based on a semantic model enabled for large semantic model storage format cannot be downloaded using REST APIs. Use the Power BI Service to download these reports.

    Otherwise you will need to downsize the size with good practices.

    I hope that helps,

  • Hi luanlopes 

    The error you're encountering — ServerError_PremiumFilesErrors_OperationIsNotSupportedForPremiumFilesModel — typically occurs when attempting to export a Power BI report via the REST API that is based on a large semantic model published as a .pbip or Power BI file (PBIP) using the Power BI Service, particularly when the model exceeds a certain size threshold (like your 3GB model). These large datasets are handled differently under the hood, especially when they are stored using Premium Files, a newer storage format optimized for large models in Power BI Premium. Unfortunately, as of now, export operations using the Export API endpoint are not supported for models stored in Premium Files format, which is why you’re seeing this error. Even though your workspace is Premium-backed and other smaller reports export fine, this specific report likely triggers this limitation due to its size and storage format. Currently, Microsoft does not support exporting such large reports through this API method. As a workaround, consider reducing the model size or redesigning the report to use a smaller dataset if export functionality is essential. You can also monitor for updates to the Power BI API, as Microsoft may add support for Premium Files export in the future.

     

4 Replies

  • Hi. Make sure your workspace has dedicated capacity enabled. Then, take a look at exporting limitations in order to check if you are missing something for this file:

    https://learn.microsoft.com/en-us/power-bi/create-reports/service-export-to-pbix#limitations-when-downloading-a-report-pbix-file

    For example, a common issue is: 

    • Reports that are based on a semantic model enabled for large semantic model storage format cannot be downloaded using REST APIs. Use the Power BI Service to download these reports.

    Otherwise you will need to downsize the size with good practices.

    I hope that helps,

    • luanlopes's avatar
      luanlopes
      Icon for Advocate II rankAdvocate II

      Got it, thank you for the response and the explanation. I disabled the option for large semantic model to try to fix the issue, but it still persisted. I was looking into the SKU limits currently, my plan is FT1. Could that be related to the issue? Trial license.

      My report have 3GB...

  • Hi luanlopes 

    The error you're encountering — ServerError_PremiumFilesErrors_OperationIsNotSupportedForPremiumFilesModel — typically occurs when attempting to export a Power BI report via the REST API that is based on a large semantic model published as a .pbip or Power BI file (PBIP) using the Power BI Service, particularly when the model exceeds a certain size threshold (like your 3GB model). These large datasets are handled differently under the hood, especially when they are stored using Premium Files, a newer storage format optimized for large models in Power BI Premium. Unfortunately, as of now, export operations using the Export API endpoint are not supported for models stored in Premium Files format, which is why you’re seeing this error. Even though your workspace is Premium-backed and other smaller reports export fine, this specific report likely triggers this limitation due to its size and storage format. Currently, Microsoft does not support exporting such large reports through this API method. As a workaround, consider reducing the model size or redesigning the report to use a smaller dataset if export functionality is essential. You can also monitor for updates to the Power BI API, as Microsoft may add support for Premium Files export in the future.

     

    • luanlopes's avatar
      luanlopes
      Icon for Advocate II rankAdvocate II

      Hi Poojara, yes, 

      yes, I had to adjust my Power BI configuration to use small semantic models in order to export reports successfully. Thanks for your help!