Home / Fabric / Introduction to Fabric Data Agents
Introduction to Fabric Data Agents
Learn what Fabric Data Agents are with Nick Lee. Connect to datasets, craft AI instructions, test with example queries, and publish for teammates: answers grounded in your data.
In Introduction to Fabric Data Agents, Nick Lee explains what data agents are and how they sit on top of your trusted Microsoft Fabric data to answer questions in natural language. You’ll see where agents fit in a modern analytics stack, common use cases (exploratory Q&A, quick summaries, guided lookups), and how grounding to governed data helps keep answers relevant and reliable.
Then you’ll build one step-by-step. Nick walks through creating a data agent, connecting it to the right datasets, and crafting effective AI instructions that shape tone, scope, and guardrails. You’ll test with example queries to iterate on accuracy and user experience, then learn simple ways to publish and share your agent so teammates can start using it. By the end, you’ll have a clear blueprint: define purpose, build, instruct, validate with examples, and deploy.
Course Outline ( Free Preview)
Module 00 - Introduction
In this course module, Nick Lee introduces Microsoft Fabric Data Agents, guiding students through the essential prerequisites and tenant settings required to enable and use this powerful generative AI feature within their organization. The module explains the purpose and benefits of data agents, contrasts them with the standalone co-pilot experience, and provides practical steps for building, tuning, publishing, and sharing data agents. Students will also learn about current limitations, compliance considerations, and how to navigate the Microsoft Fabric environment to manage these settings effectively.
Module 01 - What Are Data Agents?
In this module, Nick introduces data agents as powerful tools that create curated, AI-driven experiences by connecting to specific data sources and tables, enabling precise and customized querying beyond what standalone Copilot offers. He explains how data agents leverage natural language processing to translate user questions into complex queries across multiple data environments, reducing the need for technical expertise and improving data accuracy and trust. The session also highlights the advantages of data agents in managing data overload, tuning AI behavior, and integrating seamlessly across platforms like Teams and co-pilot studio for targeted business insights.
Module 02 - Building a Data Agent16 min.
In this module, Nick guides you through creating a data agent within the Microsoft Fabric environment by setting up a sample data warehouse and connecting relevant data sources. You’ll learn how to customize your data agent by selecting specific tables, asking natural language questions, and reviewing the generated SQL queries to validate results. This hands-on approach emphasizes the iterative process of refining your data agent to ensure accurate and meaningful insights from your data.
Module 03 - AI Instructions15 min.
In this module, Nick guides students through the essential process of adding AI instructions to data agents to create a more precise and user-friendly experience. He explains how to customize agent behavior by setting response guidelines, clarifying ambiguous queries, and formatting outputs to align with specific business contexts. Through practical demonstrations, learners will understand how to refine AI responses, manage synonyms, and troubleshoot common issues to ensure consistent and accurate results.
Module 04 - Example Queries9 min.
In this module, Nick demonstrates how to enhance data agents by adding example queries in KQL and SQL to improve their ability to handle complex user requests. He explains how example queries help the generative AI understand table relationships and parse intricate data structures, ensuring consistent and accurate results. The lesson also covers practical steps to create, import, and test these queries within the data agent environment, highlighting their value in optimizing performance for challenging scenarios.
Module 05 - Publishing and Sharing8 min.
In this module, Nick guides students through the process of publishing and sharing data agents within Microsoft Fabric, emphasizing the importance of managing access permissions to ensure data security. Students learn the distinction between draft and published versions of data agents, how to provide meaningful descriptions for better discoverability, and the various platforms from which these agents can be accessed. By the end, learners will understand how to effectively share their data agents with colleagues while maintaining control over data visibility based on user permissions.
Nick has been a dedicated trainer and consultant since 2018, leveraging his extensive experience working with major companies, including Fortune 200 corporations, professional sports organizations, government entities, and leading firms in the finance and healthcare sectors. With a specialized focus on Power BI and data engineering, Nick has consistently demonstrated his ability to drive data-driven decision-making and optimize business processes. His commitment to excellence and his in-depth technical expertise have made him a trusted advisor and sought-after expert in the industry.