Built on Azure OpenAI, this AI assistant in Power BI and Fabric takes plain-language prompts and produces KQL, SQL or DAX code, summaries and visuals. Whatever it does is charged against Fabric capacity CUs.
Read more: Microsoft Learn
In the Ultra Transcenders books
Each book explains Copilot in Fabric in context, with comparison tables and the common traps.
Terms in this definition
- Azure OpenAI
Use of OpenAI models in Azure, including GPT, o-series, embeddings, image and Whisper, through either a Foundry resource or an Azure OpenAI resource. Content Understanding isn't available from a standalone Azure OpenAI resource.
- Chat message roles
Labels on chat messages: instructions go under system, the person's input under user, the model's previous answers under assistant, and results returned by a called tool under tool (or function).
- Power BI
Microsoft's analytics and reporting service. It reaches data held on-premises through the on-premises data gateway.
- KQL
Kusto Query Language, used read-only to query Azure Data Explorer, Log Analytics and Microsoft Sentinel; log alert rules are written in it too.
- Serverless
Compute tier for single Azure SQL databases that scales automatically, pauses when idle and charges by the second. It is offered in General Purpose and Hyperscale, not Business Critical, and reserved capacity does not apply.
- DAX
Short for Data Analysis Expressions, the formula language you write measures, calculated columns and row-level security rules in, within tabular semantic models in Power BI, Excel Power Pivot or Analysis Services.
- Fabric capacity
The compute behind Microsoft Fabric, sized in capacity units (CUs). Microsoft recommends F SKUs, purchased via Azure with per-second billing.
Related terms
- Microsoft Copilot experiences
A location you can pick in retention policies and in Communication Compliance to capture what people ask Microsoft-built Copilots and what those Copilots answer, covering, for example, Copilot Studio, Security Copilot, Copilot in Fabric and Microsoft Copilot. Copilot messages used to fall under the older Teams chats and Copilot interactions location.