Microsoft Fabric IQ Ontology, Step by Step Guide: Lakehouse to Graph | Ep 1
Have you shopped at Yuktikara Store? It's a fictional outdoor retailer with 18 stores and an online shop, and I'm building its whole data platform in Microsoft Fabric, by hand, one episode at a time. Episode 1 builds the foundation on a free Fabric trial: - A workspace with folders and a task flow - A lakehouse with schemas and 17 tables, loaded by one notebook - A quick check with the SQL analytics endpoint - A Fabric IQ ontology: 15 entity types, bindings, and 22 relationships - Refreshing the graph and exploring instances - A sneak peek of a data agent over the ontology, where it goes wrong and how it gets it right Video: https://youtu.be/jN6p5nTa0zA Episode 2 adds a semantic model and a data agent that gets the numbers right. Feedback and questions welcome.Fabric IQ MCP: Connect Power BI to Claude Code (Full Setup + Demo)
Connect Claude Code to a Power BI semantic model with the Fabric IQ MCP server, step by step: sign in, install Skills for Fabric, check the connection, and work around one Claude Code gotcha. Then a real investigation on a retail model, from "sales are down" to one product and its supplier, plus a row-level security check with a Viewer account. Every command is in the description. https://youtu.be/dJAolgqNAAs
Fabric Monday 120: Using SCD with Master Data in Plan Objects
📋 Master data changed. Should the old value disappear? This week's Fabric Monday continues the demo from episode 116. Last time: maintaining master data with Plan Objects. This time: adding SCD to that maintenance process. ⚙️ I show how to configure SCD for master data in the Plan Object. ⚙️ Then the Plan Object manages the SCD behavior automatically while the data is maintained. ⚙️ Instead of simply overwriting values, the process preserves the historical versions. That is the interesting part: The business user keeps working in the Plan Object. The history is handled as part of the process. watch?v=cIq8mlMC820Fabric Monday 119: Business Events
📡 Every team defines their own "OrderPlaced" event. Different fields. Different formats. Nothing talks to anything. Microsoft Fabric just fixed that. 🧩 BUSINESS EVENTS IN REAL-TIME HUB Business Events is a new capability in Fabric Real-Time Intelligence (Preview) that lets you define custom business signals with a shared schema — so every publisher and every consumer speak the same language. You define the event once in the Schema Registry. Every component in Fabric uses that same contract. No mismatches. No custom mapping. No surprises. 📤 WHO TRIGGERS THEM? ⚡ Activator — from Power BI reports, KQL queries, Dashboards, Warehouse SQL 📓 Spark Notebooks — from your analytical workflows 𝑓 User Data Functions — custom logic fires the event 🌊 Eventstream — streaming data published as events 📥 WHERE DO THEY GO? 🏠 Eventhouse — captured as KQL rows, queryable and historical 🔔 Activator — alerts via Email or Teams ⚙️ Power Automate — downstream process automation 📊 Notebooks / Spark — analytics and AI/ML on event data In this week's Fabric Monday I show what Business Events are, how to create them, how to trigger them, and how to capture their values in an Eventhouse. watch?v=g1sGWoRkV0sFabric Monday 116: Master Data Management with Plans
📋 Master data changes don't just happen. They need to be reviewed. The Plan object in Fabric IQ handles exactly that. 🗂️ POWERTABLE + APPROVAL WORKFLOW Inside the Plan object, PowerTable lets you edit master data directly in Fabric. But changes don't go straight to the database. They go through a governed approval process: 📤 Author makes changes and submits for review — description, due date, priority. ⏳ Approver sees pending requests. Updated values in blue. Deleted rows in red. 💬 Approver can comment, request changes, approve, or reject. ✅ Approved changes are written back to Fabric SQL. Both sides receive email notifications at every step. 💾 GOVERNED BY DESIGN No external MDM tool. No manual reconciliation. No spreadsheet passed around by email. Master data changes are tracked, reviewed, and committed — entirely inside Fabric. watch?v=Fa8rVZvTuqEFabric Monday 114: Making Plans
📊 A budget in a spreadsheet stops being true the moment actuals change. 📁 Planning lives in one file, the numbers it's measured against live somewhere else, and keeping the two in sync is a manual job that never really ends. The Plan object fixes this. 🗂️ 🧩 In Microsoft Fabric, Plan brings budgeting, forecasting and scenarios onto the same governed model as your data. The Planning sheet is where it happens — the closed period holds your actuals, the open period holds the forecast. 📈 In this week's Fabric Monday, I show how to use the Plan object and build a Planning sheet for forecasting scenarios — and compare outcomes side by side. 🎥 watch?v=5M40KClj1mgMicrosoft Fabric Ontology explained by Devang Shah at Guy in a Cube
You’ll learn: ✔️ What Fabric IQ actually is ✔️ What an ontology means in Microsoft Fabric ✔️ How entity types and relationships work ✔️ How to bind ontology to Lakehouse & Eventhouse ✔️ Why AI agents need context (to avoid hallucinations!) ✔️ How knowledge graphs improve reasoning watch?v=XEyq1qL147MFabric IQ presentation at Ignite 2025 by Yitzhak Kesselman and his team
Discover how Fabric IQ transforms your data into a live, semantic model of your business. Learn how teams and AI agents can collaborate from a shared understanding of entities, relationships, and rules -- enabling real-time insights, smarter decisions, and autonomous operations. See how Fabric IQ works seamlessly within Microsoft Fabric to power the next generation of intelligent enterprise. watch?v=yy7M_O_z_wQ?si=SRDY9iSUzTTrmj-I
