Do we need more Power BI Premium Capacity?

Рет қаралды 16,283

Күн бұрын

Capacity planning for Power BI Premium is not an exact science. How much capacity do you need? As with most things, it depends! Adam walks through some things to consider when thinking about your planning.
Premium Gen2 capacity load evaluation
docs.microsoft.com/power-bi/a...
Use the Gen2 metrics app
docs.microsoft.com/power-bi/a...
📢 Become a member: guyinacu.be/membership
*******************
Want to take your Power BI skills to the next level? We have training courses available to help you with your journey.
🎓 Guy in a Cube courses: guyinacu.be/courses
*******************
LET'S CONNECT!
*******************
-- / guyinacube
-- / awsaxton
-- / patrickdba
-- / guyinacube
-- / guyinacube
-- guyinacube.com
**Gear**
🛠 Check out my Tools page - guyinacube.com/tools/
#PowerBI #Premium #GuyInACube

Пікірлер: 20

@Bharath_PBI 2 жыл бұрын

Agree, optimization is the first key option 👍 Thank you

@Timothywharton912 2 жыл бұрын

Thanks for taking the time with this Adam. So so helpful - in regards to the variables that combine to decide on an appropriate Capacity - it would be great if the utilisation report held more historical usage and attempted to use predictive analysis for capacity planning (when a P2/P3 may be required with current growth.)

@shinaken 2 жыл бұрын

Any idea how to do a 544 fiscal calendar and keep the cool features like zoom slider? I can't find anything on this! Thanks

@MuradMuradov717 Жыл бұрын

just a feedback, there is distortion in the audio if you use high end headphones.

@88packito88 2 жыл бұрын

You mentioned in the video having 2 P1s and moving workspaces to the another P1 in order to free up space. What about if you’d like to merge both capacities? What would your approach be as Power BI doesn’t let you merge capacities automatically?

@davidcousins8407 2 жыл бұрын

Move everything into one capacity then delete the empty capacity you moved things from. Assign the v-cores to the remaining capacity. Giggle as the dataset SKU limit chart in the metrics app jumps up (the CPU limit won't move, because it's always 100% of whatever the SKU limit is at the time) Do this all out of hours to avoid overloading the P1 in the short space between moving workspaces into it and assigning the recovered v-cores from the other capacity. Or do it live, that's fun too.

@andrewsnodgrass5381 Жыл бұрын

If I scale-up (in other words edit my capacity setting and go from a P1 to a P2 (assuming I have avaialble cores), what happens on the back-end? Does the service automatically perform the increase? Is there anything I need to move or is all that hidden from me?

@vinaymishra06 2 жыл бұрын

How much capacity is required for paginated reports which hold approx 1M rows in Power BI embedded capacity?? Also can non-pro users are able to see the reports if included in the APP??

@danielszymczewski9637 2 ай бұрын

Q: Using the capacity monitor app how can one change the settings to observe the trends for CPU in a wider view i.e. more than just one week window?

@jasonsmith5169 2 жыл бұрын

Why not use A SKUs for production environments?

@agnego Жыл бұрын

Ok and how to optimize data sets and flows

@yogeshdornala 2 жыл бұрын

Great video!! But I have one question running in my mind from long time For example we have an import model report which has a size of 10MB. There are 10 visuals which mostly have sum measures Will the premium at highest capacity be able to handle 5000 concurrent users?

@Bharath_PBI 2 жыл бұрын

If it's optimised and modeled using best practices, I don't think you need premium, rather wisely use report caches, for 10 MB models.

@yogeshdornala 2 жыл бұрын

Thanks for the reply Bharath As I need to share the report to thousands of users, I need premium right? Even if I opt for pro, all the users who want to view the report should have pro, right? Am I missing something here?

@Bharath_PBI 2 жыл бұрын

@@yogeshdornala , Hi, then you should estimate cost difference between premium and embedded licensing, for better cost effective solution.