22-25 April 2026

Fabric and Azure AI Foundry playing nicely together

Proposed session for SQLBits 2026

TL; 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.

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