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

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.

Reply
akarkal
Frequent Visitor

Undetsanding Power Bi Embedded Limits on Dataset

I feel like I am going in circles with Power BI Embedded.

  • I am on A1 Capacity Node, which from the table below makes me think that I should access to 2.5 GBs of RAM.
  • Is 2.5 GB the maximum limit dataset that the capacity load at one time?

Say I am currently catering to multiple clients each with a separate dataset and the reports using import mode

  • Client A --> Dataset A (10 MB)
  • Client B --> Dataset B (1 GB)
  • Client C --> Dataset C (2GB)

fa4tq

Questions

  1. Will this mean if a user from Client B and Client C try to access my service which uses Power BI Embedded they will experience issues since my total dataset size is 3 GB ?

  2. I am measuring the size of the PBIX file as the size of the dataset. Is that an accurate estimate ?

 

I have the same question raised in Stack Overflow link here : 

https://stackoverflow.com/questions/69137290/power-bi-embedded-limits-on-dataset

1 ACCEPTED SOLUTION
lbendlin
Super User
Super User

1. no, but they will eject each other from the capacity/SKU all the time (or attempt to do so). You will not be able to load the Client A dataset at all.

2. Ish.  You need to account for the Vertipaq compression.  Have a look at the reported sizes in DAX Studio, or in the Power BI Service dataset settings pages.

View solution in original post

1 REPLY 1
lbendlin
Super User
Super User

1. no, but they will eject each other from the capacity/SKU all the time (or attempt to do so). You will not be able to load the Client A dataset at all.

2. Ish.  You need to account for the Vertipaq compression.  Have a look at the reported sizes in DAX Studio, or in the Power BI Service dataset settings pages.

Helpful resources

Announcements
Microsoft Fabric Learn Together

Microsoft Fabric Learn Together

Covering the world! 9:00-10:30 AM Sydney, 4:00-5:30 PM CET (Paris/Berlin), 7:00-8:30 PM Mexico City

PBI_APRIL_CAROUSEL1

Power BI Monthly Update - April 2024

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

April Fabric Community Update

Fabric Community Update - April 2024

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

Top Solution Authors
Top Kudoed Authors