Join us for an expert-led overview of the tools and concepts you'll need to pass exam PL-300. The first session starts on June 11th. See you there!
Get registeredPower BI is turning 10! Let’s celebrate together with dataviz contests, interactive sessions, and giveaways. Register now.
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.
Solved! Go to Solution.
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:
For example, a common issue is:
Otherwise you will need to downsize the size with good practices.
I hope that helps,
Happy to help!
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.
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.
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!
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:
For example, a common issue is:
Otherwise you will need to downsize the size with good practices.
I hope that helps,
Happy to help!
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...
User | Count |
---|---|
47 | |
31 | |
27 | |
27 | |
26 |
User | Count |
---|---|
56 | |
55 | |
36 | |
33 | |
28 |