Power BI - Enterprise Setup

Ready-to-Use Files

Download these files from the powerbi/ folder:

In Power BI Desktop → Home → Get Data → Blank Query
Click Advanced Editor and paste HealthReports-Query.m
Update StorageAccountName at the top
Authenticate with Organizational account (needs Storage Table Data Reader)
Click Close & Apply
Modeling → New Measure — add each measure from Measures.dax

📸

Screenshot: Power BI Desktop → Advanced Editor with HealthReports-Query.m pasted

Connects to Azure Table Storage and expands all flat columns
Correct types: boolean, integer, datetime, text
Computed columns: HoursSinceReport, IsStale (>24h), AllFirewallProfilesEnabled, HealthBucket
Sorted by freshest report per device

Total Devices, Avg Health Score, Healthy Device %, Stale Device Count

RTP Enabled %, Tamper Protection %, Avg Signature Age, Stale Signatures Count

MDE Onboarding %, Sense Not Running

ASR Configured %, Avg ASR Block Rules

All Firewall Profiles %, Firewall Gaps

VBS Enabled %, HVCI Running %, Credential Guard %

Gauge on HealthScore, card count by OverallStatus

RTP/Tamper pie charts, signature age histogram, ASR bar chart

Matrix: Hostname × Domain/Private/Public profiles

Pie: HvciRunning true vs false

Full table with slicers on DeviceTag, OrgUnit, OsVersion

Hostname × GeneratedAtUtc sorted by staleness

📸

Screenshot: Example Power BI dashboard showing fleet health overview