Fabric Data Agent #sql
3 items tagged with "sql"
đź“„ Articles
Apr 27, 2026
Building a Fabric Data Agent with On‑Premises SQL Server Data
Many organizations still rely on on‑premises SQL Server for core operational workloads — finance, billing, ERP, manufacturing, and regulatory systems — that cannot be easily migrated to the cloud. At the same time, the business is demanding: Conversational access to data (“Ask the data” experiences) AI‑powered insights without building fragile ETL pipelines Faster time‑to‑value from analytics and AI Strong governance, security boundaries, and system ownership Microsoft Fabric addresses this challenge by allowing organizations to bring AI to their data before moving their data to AI. By leveraging SQL Server mirroring into Microsoft Fabric, organizations can continuously replicate on-premises data into OneLake, making it immediately available for analytics and AI—without disrupting source systems. On top of this foundation, semantic models and Fabric Data Agents enable governed, natural-language interactions powered by Microsoft Copilot.
đź’Ľ LinkedIn Posts
Apr 18, 2026
Building a Fabric Data Agent with On‑Premises SQL Server Data
Many organizations still rely on on‑premises SQL Server for core operational workloads — finance, billing, ERP, manufacturing, and regulatory systems — that cannot be easily migrated to the cloud. At the same time, the business is demanding: Conversational access to data (“Ask the data” experiences) AI‑powered insights without building fragile ETL pipelines Faster time‑to‑value from analytics and AI Strong governance, security boundaries, and system ownership Microsoft Fabric addresses this challenge by allowing organizations to bring AI to their data before moving their data to AI. By leveraging SQL Server mirroring into Microsoft Fabric, organizations can continuously replicate on-premises data into OneLake, making it immediately available for analytics and AI—without disrupting source systems. On top of this foundation, semantic models and Fabric Data Agents enable governed, natural-language interactions powered by Microsoft Copilot.
Mar 26, 2026
What We Learned Building a Real-World Fabric Data Agent — The Honest Field Notes
The post is a detailed, field‑tested account of building a real‑world Fabric Data Agent on top of a complex industrial supply‑chain dataset, highlighting what works, what breaks, and what requires deliberate engineering. It walks through six major lessons: why agent instructions—not data sources—determine answer quality; how Semantic Models and Ontologies complement each other; the pitfalls of asynchronous graph rebuilds; the importance of using binding property names in GQL; common GQL query‑generation failures; and the hidden requirement to use dbo. prefixes in SQL. Despite the rough edges of a preview product, the author argues that Fabric IQ’s architecture—unifying SQL, DAX, and GQL behind a governed semantic layer—is powerful and worth understanding deeply for anyone building enterprise‑grade AI analytics.