Skip to main content
cancel
Showing results for 
Search instead for 
Did you mean: 

Find everything you need to get certified on Fabric—skills challenges, live sessions, exam prep, role guidance, and more. Get started

Reply
Jai_Bankar
Helper I
Helper I

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 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.

1 ACCEPTED 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.

View solution in original post

5 REPLIES 5
v-yalanwu-msft
Community Support
Community Support

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.

SKU MEMORY AND COMPUTING POWER
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...

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.

Thanks @v-yalanwu-msft 

Hi, @v-yalanwu-msft 

Thanks for sharing the details.

Helpful resources

Announcements
July 2024 Power BI Update

Power BI Monthly Update - July 2024

Check out the July 2024 Power BI update to learn about new features.

July Newsletter

Fabric Community Update - July 2024

Find out what's new and trending in the Fabric Community.