Project Overview

A comprehensive Power BI solution for monitoring Microsoft Intune device compliance, software inventory, and endpoint security across your organization.

4
Data Queries
15+
DAX Measures
4
Report Pages
12h
Refresh Rate

Solution Architecture

Intune Data Warehouse
→
Power BI Desktop
→
Interactive Dashboard
🛡️

Device Compliance Monitoring

Track compliance states across policies and platforms with real-time insights.

Compliance Rate Non-compliant Devices Policy Violations
📱

Software Inventory Tracking

Monitor installed applications and versions across all devices in your environment.

Installed Apps Version Tracking Outdated Software
🔒

Security Posture Analysis

Identify encryption and antivirus gaps in your environment for better security.

Encryption Status Antivirus Protection Threat Detection
👥

User & Device Management

Comprehensive device and user tracking with detailed platform distribution insights.

Device Inventory User Analysis Platform Distribution

Setup Guide

Follow these steps to implement the Intune Power BI Dashboard in your environment.

0 of 7 steps completed
1

Prerequisites Check

~10 minutes

Verify Intune permissions and Power BI Desktop installation

  • Intune Administrator role
  • Power BI Desktop
  • Data Warehouse enabled
2

Clone Repository

~2 minutes

Download project files from GitHub repository

git clone https://github.com/a-ariff/intune-powerbi-dashboard
3

Configure Authentication

~15 minutes

Set up organizational account authentication with Intune API

Note: Follow authentication guide for detailed steps

4

Import Power Query Scripts

~10 minutes

Load M queries for data connection and transformation

base-connection.m devices-query.m compliance-query.m
5

Apply DAX Measures

~5 minutes

Add calculated measures for compliance and security metrics

compliance-measures.dax security-measures.dax
6

Build Report Pages

~20 minutes

Create visualizations and configure dashboard layout

Overview Compliance Software Inventory Device Details
7

Publish & Schedule Refresh

~10 minutes

Deploy to Power BI Service and configure data refresh

Refresh Frequency: Every 12 hours

System Architecture

Data Source

API Endpoint: Intune Data Warehouse API v1.0
Authentication: Organizational Account
URL: https://fef.msua01.manage.microsoft.com/ReportingService/DataWarehouseFEService

Data Tables

Devices

Master device inventory with compliance states

Records: ~1,000-50,000 Refresh: 12 hours

DeviceCompliance

Policy compliance details per device

Records: ~5,000-250,000 Refresh: 12 hours

SoftwareInventory

Installed applications per device

Records: ~10,000-500,000 Refresh: 12 hours

Users

User details and department information

Records: ~500-25,000 Refresh: 12 hours

Key Measures

Total Devices
Compliance Rate
Non-Compliant Devices
Devices Missing Encryption
Recently Active Devices
Total Policy Violations
Software Inventory Count

Resources & Documentation

📖

Authentication Guide

Step-by-step authentication setup with Intune API

View Guide
📋

README Documentation

Complete project overview and setup instructions

View README
🔗

Base Connection Script

M language query for establishing Intune API connection

Download Script
📊

Device Query Script

Power Query M script for device data extraction

Download Script
📐

Compliance Measures

DAX measures for compliance and security calculations

Download DAX
🆘

Support & Issues

Get help with troubleshooting and report issues

GitHub Issues