Power BI Monitoring 101

on YouTube ↗43m

" summary

Covers a concrete Power BI tenant monitoring pipeline: collect activity events API logs, catalog metadata and refresh history, and Graph license data using a service principal and PowerShell scripts that persist files to disk or an Azure data lake. Shows numbers: 89 distinct users since November, ~20/day average, ~60 peak/hour, and flags like a personal-workspace report being the top asset. Explains throttling, client‑credentials auth, needing workspace access for refresh history, anomaly detection in Power BI visuals, and a file‑proxy to switch storage locations.

AI-written summary · about

" chapters (15)

1. 0:00Intro
2. 0:40Agenda
3. 1:52Why Monitoring
4. 8:42Reality Check
5. 9:33Out of the Box
6. 11:43Activity
7. 12:43Activity Trend
8. 16:43Data Views
9. 21:53Report Activities
10. 23:43Metadata
11. 25:18Data Sources
12. 26:38Refresh History
13. 29:38Users Roles
14. 31:16Licenses
15. 37:23Authentication

" related talks

• 51mThe accidental administrator's guide Power BIMichael Johnson · SQLBits 2023
• 45mPower BI Universe - Mapping the hiveTom Martens · Global Azure 2021
• 58mPower BI for DevelopersPeter Myers, Laurent Amar · NDC London 2019
• 58mPower BI for the DeveloperPeter Myers, Chris Webb · NDC London 2023
• 01h 03mPower BI for the DeveloperPeter Myers · NDC Sydney 2016
• 20mUnderstanding and Managing Data Lineage in Power BIJoe Billingham · SQLBits 2023
• 48mPower BI for DevelopersPeter Meyers · NDC Sydney 2018
• 01h 01mDiscover, Manage, Analyze, and Visualize Your Data with Power BIMiguel Martínez · PASS Business Analytics Conference 2015