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.)
@jasonsmith51692 жыл бұрын
Why not use A SKUs for production environments?
@Bharath_PBI2 жыл бұрын
Agree, optimization is the first key option 👍 Thank you
@MuradMuradov7172 жыл бұрын
just a feedback, there is distortion in the audio if you use high end headphones.
@agnego Жыл бұрын
Ok and how to optimize data sets and flows
@danielszymczewski96379 ай бұрын
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?
@shinaken2 жыл бұрын
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
@andrewsnodgrass53812 жыл бұрын
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?
@vinaymishra062 жыл бұрын
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??
@88packito882 жыл бұрын
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?
@davidcousins84072 жыл бұрын
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.
@nassu822 жыл бұрын
Hi, what about having only DirectQuery sources on a capacity ? How to plan that?
@ookbrz2 жыл бұрын
Probabily you wont need a dedicated capacity, since the all you workload will be submited to the data source.
@yogeshdornala2 жыл бұрын
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_PBI2 жыл бұрын
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.
@yogeshdornala2 жыл бұрын
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_PBI2 жыл бұрын
@@yogeshdornala , Hi, then you should estimate cost difference between premium and embedded licensing, for better cost effective solution.
@sahmedalee2 жыл бұрын
is there anyway i can switch to premium gen2 wihtout purchasing Premium Capacity?