Michael Kellett – Mym111

Crafting compelling narratives through creative writing, digital artistry, and analytical insight

BI Analyst’s AI Roadmap: 2026–2027

Nov 11, 2026 · @Michael Kellett

In 2026 Copilot in Power BI went from a side pane you chat with to agents that build and edit your models and reports. The next five months are mostly about retirements: Microsoft 365 Copilot replaces the standalone Copilot (turned on by default December 8, 2026), Q&A stops working in February 2027, and R and Python visuals stop working in May 2027.

Four things changed this year:

  • Agents now write the code. The Desktop Bridge, the Power BI authoring MCP servers and the Skills for Fabric let an AI agent change a semantic model or report and then check its own work. Power BI Agentic Experiences went GA at FabCon Europe in September.
  • Your semantic model is now the AI’s context. Fabric IQ sends the measures, relationships and RLS from Power BI semantic models into Microsoft Copilot Chat and Cowork. A well-documented model is now what makes Copilot useful.
  • Code-first is the default. PBIP, PBIR and developer mode are GA. Git integration in Fabric added selective branching and branched workspaces, and Microsoft now officially supports the fabric-cicd deployment tool.
  • Snowflake and OneLake share one copy of the data. Two-way Iceberg interoperability went GA early in the year. Snowflake extended mirroring followed in September. The open standard Apache Ossie is starting to move semantic definitions between Snowflake Semantic Views and Power BI (TMDL).

The log below runs newest first, so you can see the latest changes at the top. Status is as published by the vendor at the time. Previews change, so check the linked source before you build anything on one.

2026, month by month

The biggest months were June (agents enter Power BI Desktop) and September (agentic experiences, PBIP and Git branching go GA at FabCon Europe). The quieter months mostly delivered the plumbing those two depended on.

MonthAreaWhat happenedStatus
Nov 2026CopilotMicrosoft announced it is retiring standalone Copilot in Power BI (MC1546429). Microsoft 365 Copilot in Power BI and Fabric replaces it and is on by default from Dec 8. Standalone Copilot goes away mid-January 2027.Announced
Nov 2026Power BIBuilt-in R and Python visuals retire in May 2027. Python scripts in Power Query are not affected.Announced
Nov 2026SnowflakeBUILD, a virtual event on Nov 3–6, focused on CoCo (Snowflake’s AI coding agent) and CoWork (its agent for business users).Event
Oct 2026CopilotIn the October update, the Power BI Report skill (Skills for Fabric) can add, bind and format custom visuals.GA
Oct 2026Power BIA Gantt chart and a dropdown mode for the list slicer were added. Semantic models now report capacity usage while long operations run, so surge protection can act sooner.Gantt and slicer in preview
Sep 2026CopilotFabCon Europe, Barcelona: Power BI Agentic Experiences let agents create or change semantic models and reports and then check their own work. Fabric IQ now answers questions from Power BI semantic models in Copilot Chat and Cowork, with RLS respected.GA (some underlying skills still in preview)
Sep 2026CopilotMicrosoft 365 Copilot inside Power BI and Fabric: licensed preview, off by default at launch.Preview
Sep 2026DevOpsDeveloper mode and the PBIP format went GA. PBIR is now the default report format in Desktop and the service. Reports still in PBIR-Legacy are converted automatically when edited.GA
Sep 2026DevOpsFabric Git integration: compare and commit, selective branching, branched workspaces and bulk import/export APIs went GA. A local Power BI authoring MCP server for Desktop, PBIP and TMDL went GA; the hosted version is in preview.GA
Sep 2026DevOpsPreviews: deployment plans (ordered rollouts on a canvas, backed by YAML), file-level commits, and sensitivity labels in item definitions.Preview
Sep 2026FabricCapacity overage is now billed at three times the pay-as-you-go rate. Modern Report Builder was shown as a sneak peek: you describe an app in plain language, and it can include inputs and writeback.Overage GA; Report Builder not yet in preview
Sep 2026CopilotQ&A retirement moved to February 2027. Copilot now runs on every Fabric capacity from F2 up, and Fabric Copilot Capacity covers users in Pro and PPU workspaces.Announced
Sep 2026SnowflakeSnowflake extended mirroring into OneLake went GA. Microsoft contributed a Power BI converter to Apache Ossie: it converts between Power BI models (TMDL) and Snowflake Semantic Views, and DAX is now a recognised expression language in the spec.Mirroring GA; converter early stage
Aug 2026CopilotCopilot summaries can read visuals hidden behind bookmarks, with RLS and OLS still enforced. Fabric data agents in Copilot Studio went GA.GA
Aug 2026DevOpsPower BI Desktop detects outside edits to PBIP files and opens the project in VS Code. The service gained refresh options for schema only, data only, or one table.Shipped
Aug 2026SnowflakePower BI ingestion for Semantic View Autopilot: upload a Power BI file to seed a Snowflake Semantic View.GA (Aug 18)
Jul 2026Power BIMeasure descriptions written as /// comments in DAX query view are saved into the model. TMDL view is available on the web. Fabric REST APIs added create, read, update and delete for org apps. Planning in Fabric IQ went GA.Shipped
Jun 2026CopilotJune update: the Power BI Desktop Bridge lets agents work against a running Desktop session. Copilot in web modeling and the report-authoring agent skills both arrived. Fabric Apps launched.Preview
Jun 2026Power BIDAX user-defined functions went GA and gained optional parameters.GA
Jun 2026SnowflakeSummit (Jun 1–4): Cortex Code was renamed CoCo and Snowflake Intelligence was renamed CoWork. Cortex Sense was announced and Iceberg v3 went GA. AtScale announced an XMLA endpoint that lets Power BI and Excel query Snowflake Semantic Views live.Mixed; XMLA endpoint in private preview
May 2026CopilotCopilot summary shortcuts for a whole report or a single visual. The Copilot narrative visual can now be embedded in customer apps.Shortcuts shipped; embed in preview
May 2026Power BIVisual calculations and custom totals went GA. A new Get Data experience arrived in Desktop.GA / preview
Apr 2026CopilotCopilot in Power BI mobile became a full chat, grounded in the open report, with citations.Shipped
Apr 2026Power BIUnmaterialised calculated columns on Direct Lake tables. The old Desktop file picker was removed.Preview / retired
Mar 2026FabricFabCon Atlanta: Direct Lake on OneLake and Fabric data agents went GA, and translytical task flows went GA. Fabric IQ ontologies were announced. PBIR became the default format in Desktop.GA
Mar 2026Power BITMDL view in web modeling and DAX user-defined functions arrived in preview. The Copilot pane was redesigned.Preview
Mar 2026SnowflakeStandard SQL querying of Semantic Views went GA on Mar 2.GA
Feb 2026CopilotThe Copilot prompt limit rose from 500 to 10,000 characters, and Copilot came to Power BI apps. The Fabric Copilot capacity tenant setting was turned on by default from Feb 8.Shipped
Feb 2026DevOpsMicrosoft began officially supporting fabric-cicd, the Python tool for promoting Fabric items from Dev to Test to Prod.Supported
Feb 2026SnowflakeOneLake and Snowflake interoperability went GA, co-announced at Snowflake BUILD London. Each platform can read the other’s Iceberg tables, and Snowflake-managed Iceberg tables can be stored in OneLake.GA
Jan 2026CopilotThe “Prepped for AI” setting was renamed Approved for Copilot. Standalone Copilot got an entry point on the Power BI Home page. The Q&A retirement notice went out on Jan 16.Shipped
Jan 2026DevOpsFrom Jan 25, new reports in the service are saved as PBIR by default.Rolled out

What’s coming: December 2026 to 2027

The dates that will force you to act are December 8 (Microsoft 365 Copilot turns on by default), mid-January (standalone Copilot goes), February (Q&A stops working) and May (R and Python visuals stop working). The rest of 2027 is set by four conferences, where previews usually move to GA.

The deadlines are bunched into December to May. Everything after that depends on what goes GA at the conferences.

Reports that still use a Q&A visual will show an error where the visual was. So will R or Python visuals after May. Neither has a fallback, so take an inventory now. On-premises Power BI Report Server users have two more dates: Office Online Server retires on Dec 31, 2026, and the SSRS, PBIRS and SSAS SCOM management packs lose support after January 2027.

In preview with no GA date yet

These were announced in 2026 and are the likeliest to go GA at Ignite (Nov 17–20) or FabCon Atlanta (March 2027). Treat that as a guess, not a commitment.

ItemWhat it doesWhere it stands
Modern Report BuilderBuilds a Power BI app from a plain-language description, with inputs and writeback through Fabric Apps. Pro and PPU users get up to 1 GB per app.Sneak peek; preview “forthcoming”
Microsoft 365 Copilot in Power BI and FabricMicrosoft 365 Copilot inside Power BI and Fabric, with shared conversation history. Replaces standalone Copilot.Preview; on by default Dec 8
Hosted Power BI authoring MCP serverAgents edit semantic models in Fabric workspaces without local software.Preview (local version GA)
Unified Copilot in FabricOne Copilot that keeps project context across Fabric and supported IDEs.Private preview
Deployment plansOrdered rollouts across workspaces, defined in YAML, with validation steps.Preview
Fabric IQ ontologiesBusiness entities that reuse your existing DAX measures. Includes Git and CI/CD support.Preview
Semantic views in OneLakeNot yet documented: Microsoft hasn’t said how calculations or security will work.Sneak peek
Snowflake Semantic Views XMLA endpoint (AtScale)Lets Power BI and Excel query Snowflake’s governed metrics live.Private preview
Apache Ossie Power BI converterConverts semantic models between Power BI and Snowflake.Early, community-driven

What this means for a BI analyst

The job is shifting from building every visual yourself to curating the model that agents and Copilot read, and reviewing what they produce. A sloppy model used to mean a confused report reader. Now it means a confident, wrong answer in Copilot Chat, delivered to someone who will never open your report.

Before February 2027

  • Inventory every Q&A visual and “Ask a question” box, including embedded and dashboard tiles, and choose a Copilot replacement for each.
  • Check with your admin how Microsoft 365 Copilot in Power BI is licensed before it turns on December 8, and which tenant settings disappear in January.
  • Find every R and Python visual and plan its replacement, whether a core visual, a visual calculation or a custom visual, before May 2027.
  • Update Power BI Desktop. Versions from March 2026 or earlier can no longer save to OneDrive or SharePoint.

Make your semantic models ready for Copilot

  • Add a /// description to every measure in DAX query view. Copilot, Fabric IQ and agents all read these descriptions.
  • Mark trusted models Approved for Copilot. Hide helper columns and use plain business names.
  • Test row-level security through Copilot Chat as well as in the report, now that answers reach Copilot Chat and Cowork outside Power BI.

Start working code-first

  • Save new work as PBIP, so the model is in TMDL and the report in PBIR, and commit it to Git (Azure DevOps or GitHub).
  • Try a branched workspace for one feature, then a fabric-cicd pipeline that promotes Dev to Test to Prod with a parameter file.
  • Move repeated DAX patterns into user-defined functions. They are GA and easy for agents to reuse.

Learn to work with agents, on a copy

  • Point an agent at a copy of a model through the local Power BI authoring MCP server or the Desktop Bridge, and ask it to add measures and descriptions. Read the diff in Git before you accept anything.
  • Write down what you would and wouldn’t hand to an agent. Most teams will need that policy in 2027.

If your organisation uses Snowflake

  • Decide per table: mirroring into OneLake (simplest for Direct Lake) or a shared Iceberg copy (cheaper for very large tables, but more setup).
  • Decide where governed metrics live. Snowflake Semantic Views and Power BI semantic models can now be converted into each other, so pick one as the source of truth before the two drift apart.

The longer-term skills that grow out of these are data modeling, Git and CI/CD, writing metadata clearly, and reviewing generated DAX. That is the work of an analytics engineer, which is where this role is heading.

How to keep tracking

Five feeds cover almost all of this. Checking them about once a month, after each Power BI release, is enough.

  • What’s new in Power BI and the monthly update archive: the official summary of each release, with preview flags.
  • Microsoft 365 Message Center, readable in public through mirrors such as mc.merill.net: retirements and default-on changes, each with an “act by” date. Search for “Power BI” and “Fabric”.
  • The Microsoft Fabric Updates Blog and the Fabric roadmap: Git, CI/CD, OneLake and Fabric IQ, which the Power BI summaries often skip.
  • Snowflake release notes: Semantic Views, Cortex, and anything that mentions Power BI or OneLake.
  • Conference keynotes: Ignite (Nov 17–20, 2026), FabCon Atlanta (Mar 8–12, 2027), FabCon APAC Sydney (Apr 6–9, 2027), Snowflake Summit (Jun 7–10, 2027) and FabCon Europe Amsterdam (Oct 25–28, 2027).

Sources

Leave a Reply