Power BI Embedded Capacity planning.

[israrci1318]

Hi Everyone,
I need help regarding Power BI Embedded capacity planning.
Currently, I am using A1 capacity for a project with the following details:

Number of Reports: 30
Maximum Number of Concurrent Users: 10
Report Size: 15 MB (average for all 30 reports)
Number of Observations in the Main Fact Table: 0.2 million

However, this is expected to change, and we anticipate around 10 million observations in the main fact table. The number of reports and maximum users will remain the same, but report sizes will increase with the growing data volume, as we are using larger datasets.

Question:
How should we scale the capacity to handle this volume of data?

[israrci1318]

Hi @powerbidev123 , I forgot to mention that my reports include around 10 calculated columns, which are quite memory-intensive. I have optimized them to the best of my understanding, but for one report with 0.2 million (2 lakh) observations, a complete refresh takes 10 minutes.

I have also installed Microsoft Fabric Capacity Metrics but am still unable to generate any conclusive insights from it. I would like to understand precisely what the load will be for this dataset and what capacity will be required. Is it possible to determine this accurately?

[Anonymous · Accepted solution]

Hi, @israrci1318 

Thanks for powerbidev123's reply. You can use the Power BI Capacity Load Assessment Tool to assess your capacity needs. Please refer to the following link.

Power BI embedded analytics capacity planning - Power BI | Microsoft Learn

Best Regards,
Yang
Community Support Team

If there is any post helps, then please consider Accept it as the solution to help the other members find it more quickly.
If I misunderstand your needs or you still have problems on it, please feel free to let us know. Thanks a lot!

How to get your questions answered quickly --  How to provide sample data in the Power BI Forum

[powerbidev123]

Hi @israrci1318 , I suggest test out with A1 capacity for now as the data size doesn't look that significant. However you can always then increase the capacity to A2/A3 depending upon the memory ,pricing etc .Further you can refer this link for more information on how you can plan your embedded analytics capacity planning :: https://learn.microsoft.com/en-us/power-bi/developer/embedded/embedded-capacity-planning