Power BI Weekly

Issue 384

20th November 2026

It's Ignite week, so there's plenty from the team. Mohammad Ali's Power BI at Ignite post introduces two public previews: Power BI Desktop for Apps, which has an agent build an app on top of a semantic model you already trust, and semantic views, which let you define governed metrics (DAX measures included) next to your data in OneLake using the open Apache Ossie standard. Apps are coming to Power BI Pro in the coming weeks and PPU later, and for those wanting to know what sits underneath, Sachin Patney has covered Fabric apps reaching general availability.

We've also received the Power BI November 2026 Feature Summary. Admins should note that standalone Power BI Copilot on the web, Teams and mobile is being retired by the end of January 2027, with tenant defaults switching to Microsoft Copilot on 8 December (existing choices are preserved, but worth a look before then). On the more practical side, my personal highlight is OneDrive and SharePoint integration finally reaching GA after three years in preview. Elsewhere, style presets are now GA, the card visual gains trend charts, tables and matrices get a Filter action button in the visual title (preview), and you will soon be able to embed a whole workspace app in SharePoint Online, navigation and all (org apps support is still to come).

Also from the team, Goutham Upadhyaya has published the on-premises data gateway November 2026 release, which brings it in line with the November Desktop and adds Dual Relay failover to a backup region (plus a security dependency fix, so worth scheduling the upgrade).

Over in the community, Marco Russo has written an introduction to full-text search for DAX, explaining the new TEXTCONTAINS and TEXTSIMILARITY functions and the indexing that makes them work.

Data Prep

  • Microsoft Ignite 2026 – přehled pro Power BI a Fabric [Czech] A Czech round-up of Ignite 2026 for Power BI and Fabric users: Power BI Desktop for Apps (preview) alongside Fabric Apps GA, semantic views built on Apache Ossie, the retirement of standalone Power BI Copilot by end of January 2027 (with tenant defaults changing on 8 December 2026), OneLake catalog replacing Purview Data Governance, plus HorizonDB, SQL analytics endpoint metadata sync and Dataflow Gen1 upgrade tooling.
  • Power BI Beginner to Intermediate Tutorial This Power BI tutorial provides a detailed, step-by-step guide from data ingestion to dashboard creation, clarifying each component's role for smoother learning in later tutorials.
  • Measure Killer: úklid modelu a column lineage [Czech] Jiří Neoral walks through Measure Killer, Brunner BI's Windows tool for finding unused columns and measures, and its new version 3 column lineage from source through Power Query to visuals. On his demo model the clean-TMDL export removed 167 columns and 15 measures but cut memory by only 8%, and he covers the Free vs Enterprise editions and the tool's lineage limitations.
  • How Multiple Developers Work on One Power BI Report: Power BI PBIP + Git Learn how to collaborate on a single Power BI report using PBIP with Git and Azure DevOps, including cloning repositories, creating feature branches, making changes in VS Code, staging commits, pushing updates, and merging through pull requests for seamless team development.
  • On-premises data gateway November 2026 release The November 2026 on-premises data gateway (version 3000.342) brings authentication, memory and caching reliability fixes, a cryptography dependency security update, Dual Relay failover to a backup-region relay, Oracle DirectQuery and diagnostics improvements, and compatibility with the November 2026 Power BI Desktop release.
  • Power BI on Databricks: Which Connection Type? Eiki Sui & Liping Huang | Fabric Insider Ep. 29 This episode explores optimal connection types for integrating Power BI with Databricks, covering performance impacts, billing differences, and ideal use cases.
  • Report Bursting With Dataflows Gen2 Revisited: Action Sequences Revisiting report bursting with the Dataflows Gen2 Send Email action, Chris Webb uses the little-documented Action.Sequence M function to send one email per table row, cutting run time from 4 minutes 15 seconds with a parameterised dataflow to 11 seconds, though he warns it isn't yet safe for production.
  • Power BI can truncate Databricks records on the ADBC driver, Microsoft says Power BI users may experience missing Databricks records when using the ADBC driver due to an LZ4 compression bug, though a workaround involving an M option is available.

Data Modeling

  • TEXTCONTAINS & TEXTSIMILARITY: New DAX Text Search The new DAX functions TEXTCONTAINS and TEXTSIMILARITY offer advanced text search capabilities with multiple matching modes, enhancing data analysis in Power BI.
  • Master Power BI Data Modeling (With 5 Practical Examples) This Power BI Data Modeling course provides five practical examples covering fundamentals like one-to-many relationships, advanced topics such as bidirectional filters and many-to-many models with bridge tables, helping learners apply concepts to real business problems.
  • Stop Trying to Write Better Prompts for Power BI Agents! Rather than chasing the perfect prompt, this video sets up an agent to build a Power BI semantic model, measures and report from a spec. It uses PBIP and TMDL so the agent can read the files, Git for rollback, GitHub Copilot CLI with the Fabric skills, team standards as skills alongside agents.md instructions, and validation of measures against expected values to a 0.1% tolerance, including what happened when validation failed.
  • Cómo usar Copilot con Power BI para crear medidas DAX | Parte 3 [Spanish] Part 3 of Guillermo Perdomo's Microsoft Copilot course (in Spanish) covers the requirements for Copilot inside Power BI, then shows an alternative for anyone without it: export the model from TMDL view to Copilot Chat, have it explain the model, propose a star schema, explain fact and dimension tables and CALCULATE, and write a new DAX measure to bring back into Power BI.
  • Protect Sensitive Data in Power BI: User-Context-Aware Calculated Column (No RLS, CLS or OLS) This video shows how to protect sensitive data like credit card numbers in Power BI using a user-context-aware calculated column without needing row-level, column-level, or object-level security.
  • Build a Client-Ready Financial Report in Power BI | End-to-End Project Walkthrough (IBCS, HTML Card) This Power BI walkthrough shows how to create a client-ready financial performance report for Aurora Nexus Group with 18 tables in a star schema, 479 DAX measures, IBCS-style visuals, animated HTML KPI cards, and five comprehensive report pages.
  • Introducing full-text search for DAX Power BI now supports full-text search in semantic models using functions like TEXTCONTAINS and TEXTSIMILARITY for precise text queries with stemming, typo handling, and relevance ranking.

Report Authoring and Interactivity

  • The DEPTH Model Checklist Juliana Smith's downloadable DEPTH checklist reviews a Power BI report, especially one AI helped build, across five layers. Dress and Elements cover colour, branding, visuals and layout, what people see. Patterns, Trust and Humans cover contrast and typography, design systems, hierarchy, chart honesty, alt text and testing, and users' access needs and keyboard navigation, what people experience. It gives concrete thresholds such as 4.5:1 text contrast, extra checks for Claude-built dashboards, and a sign-off rule that a person, not a tool, approves publication.
  • Power BI November 2026 Feature Summary The November 2026 Power BI update: standalone Power BI Copilot on web, Teams and mobile ends support by end of January 2027 in favour of Microsoft Copilot (tenant defaults switch on 8 December 2026), app-scoped Copilot is retired, and Power BI Desktop for Apps is coming to preview. Reporting brings OneDrive/SharePoint integration GA, card trend charts, style presets GA, a Filter action button for tables and matrices, Gantt totals and labels, and a date-picker default for date slicers; modeling adds semantic views and M parameters for Direct Lake on OneLake (both preview), and workspace apps can now be embedded in SharePoint Online.
  • I Built a Rotating Globe in Power BI, but Then I Had to Stop It Juliana Smith builds an animated rotating globe in Power BI from a DAX-generated SVG, using precomputed latitude rings and land dots, then adds a Play/Pause toggle so the report meets WCAG 2.2.2 (Pause, Stop, Hide), with practical questions to ask before adding animation to any dashboard. The project is shared on GitHub.
  • New on my GitHub: Power BI Design Checklists The GitHub repository provides four open-source Power BI design checklists-chart selection, chart honesty, accessibility, and alt text-to ensure reports are accurate, inclusive, and well documented.
  • Power BI Bookmarks Power BI Bookmarks turn static reports into interactive apps with toggles, popups, and guided storytelling through easy-to-follow creation, organization, and best practice steps.
  • Power BI Time Intelligence Power BI's reusable time intelligence framework lets business users analyze performance across Year-to-Date, Previous Year, and Like-for-Like comparisons with a single set of DAX measures, improving consistency and reducing duplication in semantic models.
  • A First Look at Fabric Apps: The Good, The Bad, and the Ugly Teo Lachev untangles the many meanings of "app" in Power BI and Fabric, then weighs the new custom-coded Fabric Apps: Fabric-managed hosting, authentication, data connectors and AI-assisted coding make actionable apps easy to build, but at the cost of platform lock-in, a young platform and an experience that overlaps with Power BI reports. He compares Fabric Apps with Power Automate, Power Apps, custom visuals and translytical task flows, and argues for making reports themselves more extensible instead.
  • Power BI at Ignite: Building on the momentum Microsoft's Ignite post for Power BI introduces two public previews. Power BI Desktop for Apps lets you pick a published semantic model, describe an app in natural language and have an agent build it, using new Fabric visuals with cross-filtering and accessibility support; apps come to Power BI Pro in the coming weeks and PPU later. Semantic views define governed metrics, including DAX measures, in OneLake on the Apache Ossie open standard.

Deployment, Security and Operations

  • Can Copilot Answer Questions From Your Power BI Data? Using a receivables example (£1.2M outstanding vs £340k overdue), Data Bear explains how Copilot in Power BI answers questions from report visuals and the semantic model. It covers what it needs: paid Fabric F2+ or Premium P1+ capacity rather than M365 Copilot seats, plus normal viewer licensing below F64. It then shows how to prepare a model with clearly named measures, an AI data schema, AI instructions and verified answers, tested against a closed period and as a restricted reader, and where Copilot still falls short.
  • Build governed data apps with Microsoft Fabric Apps (Generally Available) Fabric apps and Rayfin, Microsoft's open-source SDK and CLI for defining a whole app in TypeScript, are now generally available. The apps run behind Entra sign-in with SQL database or the new HorizonDB PostgreSQL (preview), OneLake file storage, and connectors that query the same Power BI semantic models and measures as your reports with their security intact. Admins get an Apps view in the OneLake governance hub, and Fabric apps are coming to Power BI Pro via Power BI Desktop for Apps.

Get Power BI Weekly in your inbox every Friday

Sign up to receive the email every week and keep on top of all the announcements.

Don't forget to confirm your subscription. We have a double opt-in sign up process to prevent spam.

We will never provide your details to any third parties. We don't spam.

Power BI Weekly Logo