Tenant Observability & Automation: Capacity Metrics, Log Analytics, Scanner API and Python

Power BI and Fabric provide rich monitoring, yet manually tracing heavy DAX queries and capacity spikes can be arduous. This session shows how to connect the Capacity Metrics App, Log Analytics and Scanner API, then automate insights with Python. We’ll start with core concepts like Capacity Units, smoothing and the difference between interactive and background operations. You’ll see how to enable the OperationId column in the Capacity Metrics App and cross‑reference it in Workspace Monitoring or Log Analytics to retrieve the text and timing of a DAX query. Using the SemPy library, we’ll execute a query and pull its capacity consumption, enrich the analysis with metadata from the Scanner API, and wrap everything into Python scripts that generate reports or alerts.