In Short: What Is Microsoft IQ?
Microsoft IQ is Microsoft's new organisational intelligence platform, launched in 2025, that measures how effectively an organisation is using its Microsoft platform investments - AI, data, and productivity tools - and provides prescriptive guidance on where gaps exist and how to close them.
For Microsoft Fabric customers specifically, Microsoft IQ introduces a new layer of visibility into adoption quality, capacity utilisation, semantic model health, and AI readiness that was previously only available through manual assessment or third-party tooling. Understanding what Microsoft IQ measures, and acting on what it surfaces, will increasingly determine which organisations extract maximum value from their Fabric investments versus which ones pay for capability they are not fully using.
What Problem Microsoft IQ Addresses
Most organisations adopting Microsoft Fabric, Copilot, and the broader Microsoft AI stack face the same challenge: the platform delivers capability, but measuring whether that capability is being used effectively - and by whom - is difficult without purpose-built tooling.
Teams know their Fabric environment is running. Reports are being generated. Dashboards are being viewed. But is the semantic model being queried in the ways it was designed for? Is capacity being consumed efficiently or wasted on poorly structured queries? Are Copilot features being adopted by the users they were rolled out for? Is the Fabric estate structured in a way that AI features like Rayfin can operate over effectively?
These are the questions Microsoft IQ is designed to answer - systematically, at scale, and connected to prescriptive improvement recommendations rather than just descriptive metrics.
Core Capabilities of Microsoft IQ
Platform Adoption Measurement
Microsoft IQ tracks feature adoption across your Microsoft tenant - which Fabric workloads are actively used, which capabilities have been provisioned but not adopted, and where usage is concentrated versus where it is absent. This goes beyond simple active user counts to measure the quality and depth of engagement with each capability.
Semantic Model and Capacity Health
For Fabric and Power BI specifically, Microsoft IQ evaluates semantic model quality indicators: query performance, measure complexity, relationship structure, refresh reliability, and Direct Lake vs. Import mode efficiency. It surfaces models that are consuming disproportionate capacity relative to their business value and highlights optimisation opportunities that would reduce cost or improve performance.
AI Readiness Scoring
Microsoft IQ includes an AI readiness dimension that evaluates how well-prepared your Fabric estate is for AI features - including Rayfin, Fabric Data Agents, and Copilot integration. This covers data governance completeness, semantic model naming conventions, Gold-layer coverage, and sensitivity label application. Organisations can use this scoring to prioritise the governance work that unlocks AI capability rather than investing broadly and hoping AI features work.
Prescriptive Recommendations
The distinguishing feature of Microsoft IQ relative to the usage analytics that existed before it is the recommendations layer. Microsoft IQ does not just tell you what is happening - it prescribes specific actions: consolidate these two semantic models, reduce query scope on this workload, apply row-level security to this dataset before enabling Rayfin, promote these five users from viewer to contributor based on their engagement patterns.
Why Fabric Customers Specifically Should Care
Fabric customers operate under a capacity-based commercial model. Every F-SKU represents a fixed pool of compute that is shared across all Fabric workloads. If that capacity is being consumed inefficiently - by poorly written Spark notebooks, by oversized Import-mode datasets that should be Direct Lake, by refresh schedules that do not align with business need - the cost is real and direct.
Microsoft IQ provides the visibility to identify exactly where capacity is being consumed inefficiently and what changes would recover that capacity. For organisations on F32 and above, the savings from capacity optimisation informed by Microsoft IQ can be material relative to the cost of the platform itself.
Beyond cost, the AI readiness scoring is increasingly important. Microsoft's roadmap - Rayfin, Fabric Data Agents, Foundry integration - requires specific governance foundations to be in place. Microsoft IQ identifies which of those foundations are missing and quantifies their absence in terms of AI capability that cannot yet be unlocked.
How Microsoft IQ Connects to Fabric Data
Microsoft IQ ingests usage telemetry, capacity metrics, semantic model metadata, and governance status from your Microsoft 365 tenant and Fabric environment. It stores and processes this data within OneLake (for Fabric customers), meaning the same data used to power Microsoft IQ reports is accessible to your own analytics and Data Agent workflows.
This creates an interesting capability: organisations can build their own Fabric-native dashboards and alerts on top of the Microsoft IQ data surfaced in OneLake, customising the reporting and alerting experience beyond what Microsoft IQ provides out of the box.
Getting Started with Microsoft IQ
Microsoft IQ is available to organisations with Microsoft Fabric capacity and eligible Microsoft 365 licences. Activation is through the Microsoft 365 Admin Centre, with Fabric-specific views available within the Fabric Admin Portal.
The most effective way to use Microsoft IQ at initial activation is to focus on the three dimensions with the highest ROI impact:
- Capacity health - identify the top five consumers of F-SKU capacity and evaluate whether that consumption is proportionate to business value
- Semantic model quality - identify models with poor refresh reliability or high query latency and prioritise refactoring
- AI readiness gaps - use the readiness scoring to build a targeted governance roadmap focused on unlocking Rayfin and Data Agent capabilities
Our Power BI and analytics team and Fabric implementation practice regularly work with organisations to interpret Microsoft IQ findings and build remediation roadmaps that close the gaps between current state and full platform value.
