Register now to learn Fabric in free live sessions led by the best Microsoft experts. From Apr 16 to May 9, in English and Spanish.
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
Solved! Go to Solution.
Hi @dass6 ,
You can take a look at following documents:
Paginated reports in Power BI: FAQ (Preview)
Currently, you may only reserve 50% of the memory for this workload.
Default memory in each Premium SKU for paginated reports:
Configure workloads in a Premium capacity
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 |
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
Hi @dass6 ,
You can take a look at following documents:
Paginated reports in Power BI: FAQ (Preview)
Currently, you may only reserve 50% of the memory for this workload.
Default memory in each Premium SKU for paginated reports:
Configure workloads in a Premium capacity
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 |
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
Covering the world! 9:00-10:30 AM Sydney, 4:00-5:30 PM CET (Paris/Berlin), 7:00-8:30 PM Mexico City
Check out the April 2024 Power BI update to learn about new features.