Forum Discussion
PowerBI Embedded dedicated capacity
Hi prven
Please check that whether your report will work in shared capcacity.
If you use import mode to get data, 10MB in power bi service may be highly compressed.
The data source may occupies 1G or even more memory.
Refreshes of import models are always memory intensive as models must be loaded into memory. Additional intermediate memory is also required for processing. A full refresh can use approximately double the amount of memory required by the model because Power BI maintains an existing snapshot of the model in memory until the processing operation is completed. This allows the model to be queried even when being it's being processed. Queries can be sent to the existing snapshot of the model until the refresh has completed and the new model data is available.
You can download the pbixfile, open it in power bi desktop and check the memory your data source occupy in
Microsoft SQL Server Analysis Service in Task Manage.Best Regards,
Rico Zhou
If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.
Hi prven
P SKUs can be used for consuming content through PBI.com or the mobile app, while A/EM do not.
For more info:Embeded-faq
Comparation table (A,P,EM SKU):
For more info: Which SKU should I use?
For more info: Understanding the Power BI Capacity Based SKUs
Best Regards,
Rico Zhou
If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.
Thanks for your response. Yes, we do use A SKU and embed the report in a custom web application. We run into this memory issue while testing the report and was wondering why would the A1 SKU run out of memory with just 1 active user.
Hi prven
Please check that whether your report will work in shared capcacity.
If you use import mode to get data, 10MB in power bi service may be highly compressed.
The data source may occupies 1G or even more memory.
Refreshes of import models are always memory intensive as models must be loaded into memory. Additional intermediate memory is also required for processing. A full refresh can use approximately double the amount of memory required by the model because Power BI maintains an existing snapshot of the model in memory until the processing operation is completed. This allows the model to be queried even when being it's being processed. Queries can be sent to the existing snapshot of the model until the refresh has completed and the new model data is available.
You can download the pbixfile, open it in power bi desktop and check the memory your data source occupy in
Microsoft SQL Server Analysis Service in Task Manage.Best Regards,
Rico Zhou
If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.