| Before the first answer | Install Power BI Desktop (Windows), connect sources with Power Query, build the semantic model, then publish it to the Power BI service. In · Power BI Desktop · Power BI service | Sign in from the browser, connect your tools or databases, or upload a spreadsheet. The Northstar sample is ready on day one. See it in ↳ Connections → overview, tables, columns |
|---|
| Definitions | You model tables, relationships and DAX measures yourself, then prepare the model for AI with descriptions and AI instructions. In · model view · DAX · Prep data for AI | An agent drafts business definitions from your schema, using metadata only with no data rows sent. You edit, approve and publish them, and every answer uses them. See it in ↳ Semantic model → generate draft → approve |
|---|
| Asking in plain words | Copilot and Fabric data agents answer questions over semantic models and other Fabric data. Both run on paid capacity: Fabric F2 or higher, or Premium P1 or higher. In · Copilot · Fabric data agents | Ask like you'd ask a colleague. You get the chart, the table and the follow-ups: compare periods, break down by segment, drill down. See it in ↳ Chat → compare period, breakdown, drill-down |
|---|
| Checking a number | Logic lives in DAX measures inside the model, maintained by whoever owns it. Data agents can show the query behind an answer. In · semantic model · data agent steps | Every answer opens to plain-language checks first, like “96 orders · nothing missing ✓”, then the rows behind it and the SQL. See it in ↳ Answer → Query panel · run ID |
|---|
| Spreadsheets | Excel files are imported as sources, and Analyze in Excel connects a workbook to a published model. In · Power Query · Analyze in Excel | SuperSheets is a spreadsheet that is itself a data source, with formulas, typed columns, column masking and live updates. CSV and Excel uploads work too. See it in ↳ SuperSheets → masked even in the formula bar |
|---|
| Scheduled reports | Subscriptions email a report or dashboard on a schedule to people who have access. In · subscriptions | Schedule any answer daily, weekly or monthly, at a set time, to workspace members. Every job shows in the Activity Monitor. See it in ↳ Chat → schedule · Activity Monitor |
|---|
| Viewers and clients | Viewers need a Pro or Premium Per User licence unless the content sits on F64 or P1 capacity and up. People outside your organisation join as Microsoft Entra B2B guests. In · Pro · Premium Per User · capacity · Entra B2B | Your team gets roles: Owner, Admin, Editor, Viewer or custom. Clients get a branded, view-only portal and see only what you publish to them, billed per active client per month. See it in ↳ Workspace → roles · Client portal |
|---|
| Governance and audit | Workspace roles, row-level security, sensitivity labels with Microsoft Purview and admin activity logs. In · workspaces · RLS · Microsoft Purview | Column masking, sensitive-data classification, enforced MFA and an audit log that also records every call from an AI assistant. See it in ↳ Workspace → audit log, CSV export |
|---|
| Keeping numbers right | Scheduled refresh keeps data current, and on-premises sources need a gateway. A changed source can make a refresh fail. In · scheduled refresh · on-premises data gateway | Schema drift is flagged after each refresh. Capped, truncated or timed-out results show “Complete data required” instead of a partial chart. See it in ↳ Model → drift flags · Chat → fails closed |
|---|
| Pricing model | Per-user licences (Pro or Premium Per User), plus Fabric or Premium capacity for Copilot, data agents and licence-free viewers. In · per user · per capacity | Plans with included seats, extra seats on Team, and client portal billing per active client. Start with a 14-day free trial of the full workflow. See it in ↳ Pricing → live catalog · See pricing → |
|---|