Power BI Premium Capacity Metrics App Deploy and Use Cyrus

Power BI Premium Capacity Metrics App Deploy and Use Cyrus Christian [email protected] Danni Olson [email protected] Intelligence Technical Specialist – State and Local Govt.

Deploying Premium Capacity Metric App Create folder (if not already there) [Documents]\Power BI Desktop\Custom Connectors Copy mez file to [Documents]\Power BI Desktop\Custom Connectors folder Change Power BI Desktop Data Extensions in Options Security to Allow Any Extension Restart Power BI Desktop Sign into the Power BI Service Open pbit file Set the time offset (ex -8 for Pacific and -5 for Eastern time zone) Sign into the connector (this should be Capacity Admin account) Verify data is pulled Publish to service after refresh is done Setup Schedule for automated daily refresh

Create Folder and Copy Connector File https://slgcommunitycall.blob.core.windows.net/communitydownloads/MetricsDataConnect mez

Modify Power BI Security Settings

Open Template and Publish Report https://slgcommunitycall.blob.core.windows.net/communitydownloads/PremiumCapacityMetri csTemplate.pbit

Update Credentials and Schedule Refresh

How Premium Capacity Works Today 2020 Microsoft. All rights reserved.

Distribute content to all users Pr o Power BI Service Self service BI Author & publish Power BI Premium Dedicated capacity V-cores/RAM allocation Dashboards workspace s Basi c Reports Datasets View reports/dashboards Distributed via Power BI Apps

Premium Resource Management Eviction What happens when a capacity gets busy? 25 GB Memory Dataset 1 Evictio n Dataset 2 Dataset 3 Dataset 4 Dataset 5 Dataset 6 Dataset 1 Dataset 2 Dataset 3 Dataset 4 Dataset 5 Dataset 6 Dataset 7 Dataset 8 Dataset 9 Dataset 10 Dataset 11 Dataset 12 Dataset 13 Dataset 14 100 TB Storage 2020 Microsoft. All rights reserved.

Managing Capacity: P1 Backend vcores: 4 Memory: 25 GB Storage: 100 TB Temperature: Warm 25 GB Memory Dataset 1 Dataset 2 Dataset 3 Dataset 4 Dataset 5 Dataset 6 100 TB storage Dataset 1 Dataset 2 Dataset 3 Dataset 4 Dataset 5 Dataset 6 Dataset 8 Dataset 9 Dataset 10 Dataset 11 Dataset 12 Dataset 13 Dataset 7 Dataset 14 2020 Microsoft. All rights reserved.

How Many Datasets can I Refresh at one time Capacity: P1 Backend v-cores: 4 Memory: 25 GB Storage: 100 TB Queue 25 GB Memory Dataset 1 Dataset 2 Dataset 3 Dataset 4 Dataset 5 Dataset 6 100 TB storage Dataset 1 Dataset 2 Dataset 3 Dataset 4 Dataset 5 Dataset 6 Dataset 7 Dataset 8 Dataset 9 Dataset 10 Dataset 11 Dataset 12 Dataset 13 Dataset 14 2020 Microsoft. All rights reserved.

How many Datasets can I Refresh at one time Capacity: P1 Backend vcores: 4 Memory: 25 GB Storage: 100 TB Temperature: Warm 25 GB Memory Dataset 1 Dataset 2 Dataset 3 Dataset 4 Dataset 5 Dataset 6 Queue 100 TB storage Dataset 7 Dataset 1 Dataset 2 Dataset 3 Dataset 4 Dataset 5 Dataset 6 Dataset 7 Dataset 8 Dataset 9 Dataset 10 Dataset 11 Dataset 12 Dataset 13 Dataset 14 2020 Microsoft. All rights reserved.

Background vs Interactive Capacity: P1 Backend vcores: 4 Memory: 25 GB Storage: 100 TB Queue Temperature: Hot 25 GB Memory Dataset 1 Dataset 2 Dataset 3 Dataset 4 Dataset 5 Dataset 6 100 TB storage Dataset 1 Dataset 2 Dataset 3 Dataset 4 Dataset 5 Dataset 6 Dataset 7 Dataset 8 Dataset 9 Dataset 10 Dataset 11 Dataset 12 Dataset 13 Dataset 14 2020 Microsoft. All rights reserved.

All Interactive Capacity: P1 Backend vcores: 4 Memory: 25 GB Storage: 100 TB Queue Dataset 8 Dataset 10 Temperature: Burning 25 GB Memory Dataset 1 Dataset 2 Dataset 3 Dataset 4 Dataset 5 Dataset 6 100 TB storage Dataset 9 Dataset 1 Dataset 2 Dataset 3 Dataset 4 Dataset 5 Dataset 6 Dataset 7 Dataset 8 Dataset 9 Dataset 10 Dataset 11 Dataset 12 Dataset 13 Dataset 14 2020 Microsoft. All rights reserved.

Dataset Model Size Premium Capacity Metric App (Demo) Data Refresh metrics Query time and duration Memory usage

How Premium Capacity Will Work in Gen 2 (In Preview) https://www.youtube.com/watch?v j 17y 2020 Microsoft. All rights reserved.

Parallelism -No limits on refresh concurrency Premium Gen 2 Changes Memory restrictions removed Autoscale vs Interactive Request Delay New Metric App