cancel
Showing results for 
Search instead for 
Did you mean: 
Reply
Highlighted
dass6 Frequent Visitor
Frequent Visitor

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

 

1 ACCEPTED SOLUTION

Accepted Solutions
Community Support Team
Community Support Team

Re: Premium Capacity sizing

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

Community Support Team _ Xiaoxin Sheng
If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.



For learning resources/Release notes, please visit: | |
2 REPLIES 2
Community Support Team
Community Support Team

Re: Premium Capacity sizing

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

Community Support Team _ Xiaoxin Sheng
If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.



For learning resources/Release notes, please visit: | |
dass6 Frequent Visitor
Frequent Visitor

Re: Premium Capacity sizing

@v-shex-msft Thanks. I think I got my question answered