Forum Discussion
Premium Capacity sizing
Hi All,
We currently have two P1 SKU's for our capacity with a total of 16 cores and 50GB Memory.
We are planning to enable the Paginated Reports and Dataflow feature in our capacity and need some recommendations.
What would be an ideal capacity to enable these features as I understand these are memory intensive process and use up a lot of resources.
Please help us with any kind of standard sizing that microsoft provides to make a capacity efficient in our landscape.
Thanks in Advance.
Sumanta Das
Hi dass6 ,
You can take a look at following documents:
Paginated reports in Power BI: FAQ (Preview)
SpoilerWhat is the maximum memory threshold I can put for paginated reports in my capacity?
Currently, you may only reserve 50% of the memory for this workload.
What is the default memory for each of the Premium SKUs supported for paginated reports?
Default memory in each Premium SKU for paginated reports:
- P1/A4: 20% default; 10% minimum
- P2/A5: 20% default; 5% minimum
- P3/A6: 20% default; 2.5% minimum
Configure workloads in a Premium capacity
SpoilerMicrosoft Office SKUs for software as a service (SaaS) scenarios
EM2 EM3 P1 P2 P3 AI (Cognitive Services) 20% default; min TBD 20% default; min TBD 20% default; min TBD 20% default; min TBD 20% default; min TBD Dataflows N/A 20% default; 12% minimum 20% default; 5% minimum 20% default; 3% minimum 20% default; 2% minimum Paginated reports N/A N/A 20% default; 10% minimum 20% default; 5% minimum 20% default; 2.5% minimum Microsoft Azure SKUs for platform as a service (PaaS) scenarios
A1 A2 A3 A4 A5 A6 AI (Cognitive Services) N/A 20% default; min TBD 20% default; min TBD 20% default; min TBD 20% default; min TBD 20% default; min TBD Dataflows 40% default; 40% minimum 24% default; 24% minimum 20% default; 12% minimum 20% default; 5% minimum 20% default; 3% minimum 20% default; 2% minimum Paginated reports N/A N/A N/A 20% default; 10% minimum 20% default; 5% minimum 20% default; 2.5% minimum Official documents:
What are paginated reports in Power BI Premium? (Preview)
Self-service data prep in Power BI (Preview)
Regards,
Xiaoxin Sheng
2 Replies
Hi dass6 ,
You can take a look at following documents:
Paginated reports in Power BI: FAQ (Preview)
SpoilerWhat is the maximum memory threshold I can put for paginated reports in my capacity?
Currently, you may only reserve 50% of the memory for this workload.
What is the default memory for each of the Premium SKUs supported for paginated reports?
Default memory in each Premium SKU for paginated reports:
- P1/A4: 20% default; 10% minimum
- P2/A5: 20% default; 5% minimum
- P3/A6: 20% default; 2.5% minimum
Configure workloads in a Premium capacity
SpoilerMicrosoft Office SKUs for software as a service (SaaS) scenarios
EM2 EM3 P1 P2 P3 AI (Cognitive Services) 20% default; min TBD 20% default; min TBD 20% default; min TBD 20% default; min TBD 20% default; min TBD Dataflows N/A 20% default; 12% minimum 20% default; 5% minimum 20% default; 3% minimum 20% default; 2% minimum Paginated reports N/A N/A 20% default; 10% minimum 20% default; 5% minimum 20% default; 2.5% minimum Microsoft Azure SKUs for platform as a service (PaaS) scenarios
A1 A2 A3 A4 A5 A6 AI (Cognitive Services) N/A 20% default; min TBD 20% default; min TBD 20% default; min TBD 20% default; min TBD 20% default; min TBD Dataflows 40% default; 40% minimum 24% default; 24% minimum 20% default; 12% minimum 20% default; 5% minimum 20% default; 3% minimum 20% default; 2% minimum Paginated reports N/A N/A N/A 20% default; 10% minimum 20% default; 5% minimum 20% default; 2.5% minimum Official documents:
What are paginated reports in Power BI Premium? (Preview)
Self-service data prep in Power BI (Preview)
Regards,
Xiaoxin Sheng
Anonymous Thanks. I think I got my question answered
