Forum Discussion
Unable to export the power bi report thru Export To File In Group api
I'm getting the below error for two reports which have the huge volume of data and unable to export it.
Is there any way can I get the total page size of the report from the api and can I export the report in chuncks?
API Name: Export To File In Group
error
----------
RootActivityId(d5446f19-785c-4114-a92d-e43fc9937dcb): There was an error communicating with Analysis Services. Please verify that the data source is available and your credentials are correct. Resource Governing: This query uses more memory than the configured limit. The query — or calculations referenced by it — might be too memory-intensive to run. Either simplify the query or its calculations, or if using Power BI Premium, you may reach out to your capacity administrator to see if they can increase the per-query memory limit. More details: consumed memory 10240 MB, memory limit 10240 MB. See https://go.microsoft.com/fwlink/?linkid=2159752 to learn more.Errors, warnings and informational messages related to the ASPAAS specific code in the engine. Error Code = 0xC147000D, External Code = 0x00000000:.
Hi Anonymous
I would recommend looking at the report and ensuring if you are following best practices and DAX best practices in order to make sure that the report can render and consume less than 10 gigs of memory typically. There typically can be done, but does require some work.
Thanks for the reply from GilbertQ , please allow me to provide another insight:
Hi, Anonymous
Regarding the issue you raised, my solution is as follows:
1.First, you can try increasing the query limit: If you're using Power BI Premium, you can contact your capacity admin to see if you can increase the memory limit for each query.
How to configure workloads in Power BI Premium - Power BI | Microsoft Learn
2.Second, you can try modifying the query capacity on desktop to choose the capacity setting:Set visual query limits in Power BI Desktop - Power BI | Microsoft Learn
Of course, if you have any new ideas, you are welcome to contact us.
Best Regards,
Leroy Lu
If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.
2 Replies
- GilbertQ
Super User
Hi Anonymous
I would recommend looking at the report and ensuring if you are following best practices and DAX best practices in order to make sure that the report can render and consume less than 10 gigs of memory typically. There typically can be done, but does require some work.
Thanks for the reply from GilbertQ , please allow me to provide another insight:
Hi, Anonymous
Regarding the issue you raised, my solution is as follows:
1.First, you can try increasing the query limit: If you're using Power BI Premium, you can contact your capacity admin to see if you can increase the memory limit for each query.
How to configure workloads in Power BI Premium - Power BI | Microsoft Learn
2.Second, you can try modifying the query capacity on desktop to choose the capacity setting:Set visual query limits in Power BI Desktop - Power BI | Microsoft Learn
Of course, if you have any new ideas, you are welcome to contact us.
Best Regards,
Leroy Lu
If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.