Find everything you need to get certified on Fabric—skills challenges, live sessions, exam prep, role guidance, and more.
Get startedGrow your Fabric skills and prepare for the DP-600 certification exam by completing the latest Microsoft Fabric challenge.
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 work when direct query is used
And similarly for rest of nodes. A2,A3,A4,A5 and A6.
I search a lot, but could not find the expected.
Thanks in advance.
Solved! Go to Solution.
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.
Hi, @Jai_Bankar ;
You could refer the official document.
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 |
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.
Hi, @v-yalanwu-msft
Can you please help me in understanding what does the DirectQuery/Live connection (per sec) value means?.
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.