Forum Discussion

Jai_Bankar's avatar
Jai_Bankar
Icon for Helper I rankHelper I
4 years ago
Solved

Need help in Power BI Embedded capacity planning

Hello All, Can I get a help in planning a capacity for Power BI Embedded. 1.If A1 node is considered, how many concurrent users can use it. Also what is dataset limit for A1 node. 2.How will it wo...
Need Help
Show and Tell
  • v-yalanwu-msft's avatar
    v-yalanwu-msft
    4 years ago

    Hi， Jai_Bankar ；

    DirectQuery/Live Connection (per sec) means the max number of data sources connected to DQ or LC per sec (used in memory).

    https://www.youtube.com/watch?v=XgjnjXkEnPw

    Best Regards,
    Community Support Team_ Yalan Wu
    If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.

v-yalanwu-msft's avatar
v-yalanwu-msft
Icon for Community Support rankCommunity Support
4 years ago

Hi, Jai_Bankar ;

You could refer the official document.

SKU memory and computing power

The table below describes the resources and limits of each SKU.

Capacity Nodes Total v-cores Backend v-cores RAM (GB) Frontend v-cores DirectQuery/Live Connection (per sec) Model Refresh Parallelism
EM1/A1 1 0.5 2.5 0.5 3.75 1
EM2/A2 2 1 5 1 7.5 2
EM3/A3 4 2 10 2 15 3
P1/A4 8 4 25 4 30 6
P2/A5 16 8 50 8 60 12
P3/A6 32 16 100 16 120 24
P4/A7 1 64 32 200 32 240 48
P5/A8 1 128 64 400 64 480 96

https://addendanalytics.com/wp-content/uploads/2020/03/Microsoft-Power-BI-Embedded-Analytics-Pricing-Guidance-WP-Oct-2017.pdf

According to my understanding, the work of DQ is the same as usual. The query speed will be different for different capacity nodes, as shown in the table.

Best Regards,
Community Support Team_ Yalan Wu
If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.

  • Jai_Bankar's avatar
    Jai_Bankar
    Icon for Helper I rankHelper I
    4 years ago

    Hi, v-yalanwu-msft 
    Can you please help me in understanding what does the DirectQuery/Live connection (per sec) value means?.

    • v-yalanwu-msft's avatar
      v-yalanwu-msft
      Icon for Community Support rankCommunity Support
      4 years ago

      Hi， Jai_Bankar ；

      DirectQuery/Live Connection (per sec) means the max number of data sources connected to DQ or LC per sec (used in memory).

      https://www.youtube.com/watch?v=XgjnjXkEnPw

      Best Regards,
      Community Support Team_ Yalan Wu
      If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.