Premium Capacity sizing

[dass6]

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 · Accepted solution]

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

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

Official documents:

What are paginated reports in Power BI Premium? (Preview)

Self-service data prep in Power BI (Preview)

Regards,

Xiaoxin Sheng

[dass6]

@Anonymous Thanks. I think I got my question answered