Table of Contents
Data professionals and report creators can now streamline their analytical workflows with the Power BI April 2026 update, which introduces expanded Copilot capabilities and highly requested modeling features. Power BI Desktop version 2.153.910.0 officially rolls out significant quality-of-life improvements, including a smarter Narrative visual and dynamic user-context-aware columns. This release focuses heavily on reducing manual formatting while pushing AI-driven insights directly to mobile users.
Microsoft is also cleaning up the authoring experience by clearly separating preview features and enforcing modern visual defaults. Whether you are building complex data models or designing mobile-friendly dashboards, this update requires a few immediate adjustments to your workflow, particularly regarding file management and database connectors.
AI and Copilot Enhancements
The integration of artificial intelligence continues to deepen, with In-Report Copilot in Power BI Mobile Apps now offering expanded features. Users can ask natural-language questions and explore insights directly within a report on their mobile devices. This allows stakeholders to interrogate data on the go without needing a desktop environment.
For report authors, the Narrative visual now features a smarter default behavior. If a user holds a Copilot license, the Narrative visual will open in Copilot mode by default, accelerating the generation of AI-powered insights. Furthermore, the character limit has been increased to 10,000, enabling richer prompts and more detailed storytelling. Authors retain full control and can toggle back to Custom mode at any time.
Advanced Modeling: Direct Lake and DAX Updates
Data modeling receives a massive boost with the introduction of Direct Lake calculated columns and tables, currently available as a preview feature. To utilize this in Power BI Desktop, users must manually enable the Direct Lake calculated columns (unmaterialized) preview feature switch. This addition bridges the gap between massive OneLake datasets and the flexibility of traditional calculated columns.
Additionally, Microsoft is introducing user-context-aware calculated columns in preview. This allows columns to dynamically respond to specific DAX functions, enabling advanced scenarios like dynamic data translations based on the active user. The supported DAX functions include:
UserCulture()UserPrincipalName()CustomData()This context awareness can be configured using the Expression Context property on Direct Lake on OneLake, Import, and DirectQuery tables. For detailed implementation steps, refer to the Create calculated columns in Power BI Desktop documentation. The update also introduces a preview for DAX user-defined functions, further expanding custom calculation capabilities.
Visuals and Reporting Improvements
Report aesthetics are getting a structural overhaul with modern visual defaults and improvements to the customize theme dialog. A new base theme switcher allows users to revert to older themes if their custom designs conflict with the new defaults. Table and matrix built-in styles have been corrected, now featuring banded rows by default and proper structural colors for axes, resolving previous issues with the Innovate and Orchid themes.
The card visual has received significant interactivity updates. Selecting a category header now highlights the chosen card while dimming others, providing clear visual feedback. Furthermore, top-level images now display correctly when the image data is base64 encoded. Layout flexibility has also been improved with fixed-size options for card visuals, button slicers, and list slicers.
To reduce confusion during report creation, preview visuals are now explicitly labeled with "(preview)" in the Visualizations pane. They are also grouped below a divider, separating them from generally available tools. For mapping enthusiasts, the Azure Maps Power BI visual now syncs the map style picker directly with the format pane.
Actionable Steps: Deprecations and Updates
This release includes two critical deprecations that require attention to ensure uninterrupted workflows. Follow these steps to adapt to the April changes:
- Adopt the New File Picker: Starting with the SU04 release, the old file picker experience is permanently deprecated. The updated, intuitive file picker is now the mandatory default, and users can no longer toggle back to the legacy view. No manual action is required, but teams should prepare for the UI shift.
- Update the Netezza ODBC Driver: The built-in IBM Netezza ODBC driver is being deprecated in favor of a newer, Generally Available version. While you can reuse your existing connector, you must manually download and install the new ODBC driver to maintain connectivity.
The Shift Toward AI-Driven Reporting
Microsoft is clearly positioning Copilot not just as an optional add-on, but as the foundational starting point for data storytelling. By forcing the Narrative visual to default to Copilot mode for licensed users, Power BI is actively nudging report creators away from manual text summaries and toward automated, scalable insights. The expansion to a 10,000-character limit further proves that enterprise users are demanding deeper, more nuanced AI analysis rather than surface-level bullet points.
On the backend, the introduction of Direct Lake calculated columns signals a critical maturation of the Microsoft Fabric ecosystem. Previously, relying on Direct Lake meant sacrificing some of the granular, row-level flexibility that DAX developers rely on. By bringing unmaterialized calculated columns and user-context awareness to OneLake datasets, Microsoft is eliminating the final barriers preventing large enterprises from fully migrating their massive data models to the cloud.
