Fabric and Azure AI Foundry playing nicely together
Proposed session for SQLBits 2026TL; DR
This session presents a solution that helps municipal supervisors prepare employee assessments by combining Microsoft Fabric and OpenAI. It automates data retrieval, analysis, and interpretation using RAG, notebooks, and LLMs to deliver insightful feedback.
Session Details
In this presentation, we will dive into a solution developed for supervisors at a municipality when they are about to conduct an employee assessment. We combine the power of Fabric and OpenAI to streamline and enhance the assessment process.
It is common for supervisors to spend a lot of time gathering quantitative information before the assessment and then analyzing and interpreting the data. We will explore a solution that uses the data processing power of Fabric and the analytical and interpretative capabilities of large language models to conduct a fair and accurate assessment and provide comprehensive and insightful feedback.
We will employ techniques like RAG (Retrieval Augmented Generation) to store guidelines for the supervisors, and we will use Notebooks and Python in Fabric with tools such as Semantic Link to retrieve data from semantic models (Power BI) and PySpark to retrieve data from Lakehouse. We will send the data to an LLM with an appropriate prompt to generate a document that guides us through the assessment.
It is common for supervisors to spend a lot of time gathering quantitative information before the assessment and then analyzing and interpreting the data. We will explore a solution that uses the data processing power of Fabric and the analytical and interpretative capabilities of large language models to conduct a fair and accurate assessment and provide comprehensive and insightful feedback.
We will employ techniques like RAG (Retrieval Augmented Generation) to store guidelines for the supervisors, and we will use Notebooks and Python in Fabric with tools such as Semantic Link to retrieve data from semantic models (Power BI) and PySpark to retrieve data from Lakehouse. We will send the data to an LLM with an appropriate prompt to generate a document that guides us through the assessment.
3 things you'll get out of this session
Explore the possibilities of interpreting Fabric data with generative AI
Explore some of the possibilities the cooperation of Fabric and Foundry offer
Explore innovative use of generative AI
Speakers
Grímur Sæmundsson's other proposed sessions for 2026
Real-Time Data Processing in Fabric: Tracking a Cycle Ride - 2026
Incident Report with Fabric, Foundry and M365 Agents - 2026
Leave the progress reports to the agents - 2026