Solved: Premium Capacity sizing

dass6 · ‎03-14-2019

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

Anonymous · ‎03-17-2019

Hi @dass6 ,

You can take a look at following documents:

Paginated reports in Power BI: FAQ (Preview)

Spoiler

What 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

What 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

Spoiler

Microsoft 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

Microsoft 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

View solution in original post

Anonymous · ‎03-17-2019

Hi @dass6 ,

You can take a look at following documents:

Paginated reports in Power BI: FAQ (Preview)

Spoiler

What 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

What 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

Spoiler

Microsoft 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

Microsoft 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