Updated: 21.06.2026
8 min read
Power BI & Fabric June 2026: 7 Game-Changing Updates — A Data Platform MVP's Take
Microsoft's June 2026 updates bring a wave of transformative capabilities to both Power BI and Fabric: on the Power BI side, features like Date Picker, Matrix Auto-Expand, and DAX User-Defined Functions (UDFs) streamline report development, while on the Fabric side, SAP ABAP Add-On, SQL CDC, and SCD Type 2 support fundamentally redefine data integration. Together, these updates free data engineers and report developers from repetitive, manual tasks — making enterprise data architectures faster to build, more reliable, and significantly easier to maintain.
Power BI & Fabric June 2026: 7 Game-Changing Updates — A Data Platform MVP's Take
The data world is evolving fast, and Microsoft's June 2026 updates for Power BI and Fabric are packed with features that will genuinely transform how we work. As a Data Platform MVP, reviewing this month's release notes, I can clearly see a set of capabilities that will fundamentally reshape data engineering, reporting, and application development workflows.
In this article, I will walk through the 7 features I find most impactful for data platform professionals, framing each one around the questions: "Where does it fit?", "What advantages does it bring?", and "What problems does it solve?"
What's New on the Power BI Front?
This month's Power BI updates are squarely focused on reducing friction for both report developers and end users in their day-to-day work [1].
1. Date Picker for Slicers
Date filtering is at the heart of any good report experience. The new Date Picker feature makes date selection in slicers significantly more flexible and intelligent.
Figure 1: The Power BI Date Picker slicer combines relative and manual date selection options in a single control.
Where does it fit and what problem does it solve?
Previously, as reporting periods changed, manually updating date slicers was a tedious, repetitive task. With this new feature, once you publish a report with a relative date selection, the date range automatically rolls forward as your data refreshes. Viewers are no longer locked into that selection — they can still define their own relative or manual date ranges using the calendar or slider controls. This frees report developers from constant maintenance while giving end users the freedom to explore any time window they need.
•Report maintenance time and effort are significantly reduced
•Users can define their own date preferences independently
•Relative options (last 30 days, this month, etc.) update automatically
•Reports become more dynamic and user-friendly
2. Auto-Expand Option for the Matrix Visual
Matrix visuals are one of the most powerful ways to analyse hierarchical data. However, controlling how newly added levels appear has sometimes been unpredictable.
Figure 2: The Matrix visual auto-expand setting controls whether row and column headers are displayed as expanded by default.
What advantage does it bring?
The new Auto-expand setting lets you decide whether the matrix's row and column headers should appear expanded or collapsed by default. When enabled, any new rows or columns added to the matrix are automatically shown in an expanded state. This eliminates the need for users to manually click through each level to see the details — a significant usability improvement, especially in dynamic and personalised reports.
•Hierarchical data is presented more transparently
•Users spend less time on manual click-through interactions
•Report designers gain full control over default behaviour
•Works seamlessly alongside the Personalize This Visual feature
3. DAX User-Defined Functions (UDFs)
This is a massive step forward for the data modelling world. DAX User-Defined Functions (UDFs) are now Generally Available.
Where does it fit and what problem does it solve?
Writing complex business logic repeatedly across every measure or calculated column has always increased error risk and made maintenance harder. Now, a calculation can be defined once as a UDF and reused throughout the entire model. With typed signatures, UDFs are first-class model objects that bring structure and consistency to DAX logic. These function definitions can be saved as TMDL files and stored in Git-integrated workspaces, enabling teams to share and consume approved business logic from a single source of truth.
A Turning Point for Enterprise Data Modelling:
•The DRY (Don't Repeat Yourself) principle is finally applied to DAX
•Changes are traceable through version control and Git integration
•Team collaboration and standardisation become far easier
•Measures and calculated columns remain clean and readable
•Maintenance and debugging are significantly simplified
4. Fabric Apps for Semantic Models
Announced at Microsoft Build, Fabric Apps offer a new AI-first path to building custom web applications powered by Microsoft Fabric on the backend.
Figure 3: The Opportunity Tracker example demonstrates how Fabric Apps can deliver enterprise-grade data applications built directly on top of semantic models.
What advantage does it bring?
Analytics teams and AI coding agents now have an accelerated path to building enterprise-grade data applications directly on top of their semantic models. From financial planning to inventory management to price optimisation, a coding agent can build an application matching your specified requirements with just a few prompts. These applications use the same trusted business logic and governance as the rest of your analytics stack.
•Persona-based views are generated automatically (e.g., Executive dashboard, Opportunities view)
•Complex features such as custom calendar interfaces are made trivial
•Work that previously required significant engineering effort can now be handled by AI agents
•Time to code and deploy is drastically reduced
•Operational applications remain within the same governance framework
•Reporting and operational apps share the same data source (semantic model)
A Revolution in Data Integration on the Fabric Side
The Fabric updates this month take data movement and integration to a significantly more powerful and enterprise-ready level [2].
5. Integrate SAP Data Using Copy Job with ABAP Add-On
SAP systems sit at the heart of many large enterprises, and moving that data to analytics platforms has always been a challenging process.
Figure 4: The ABAP Add-On option in Copy Job enables direct data copying from SAP tables (e.g., VBAK) into Fabric Warehouse.
What problem does it solve?
The ABAP Add-On support added to Fabric's Copy Job dramatically simplifies the integration of SAP data into the Fabric environment. Without the need for complex middleware or lengthy development cycles, this feature reads SAP's own language and structures to move data securely and efficiently into Fabric. The ABAP Add-On can read directly from SAP tables (VBAK, VBELN, ERDAT, etc.) and copy them into Fabric Warehouse.
•For organisations running SAP ECC or S/4HANA, this is a critical capability that can reduce integration timelines from weeks to days — or even hours
•More reliable data transfer using SAP's native protocol (ABAP)
•Dependency on middleware solutions is reduced
•Maintenance and support costs drop significantly
•Direct data flow from SAP to Fabric can be established
•Audit trail and compliance requirements are met
6. CDC with SQL Estates in Copy Job
Change Data Capture (CDC) is a cornerstone of modern data architectures. CDC support for SQL-based sources — Azure SQL Database, SQL Server, and Azure SQL MI — is now Generally Available within Copy Job.
What advantage does it bring?
Previously, building incremental data loads required complex pipeline logic, watermark tables, and custom queries. Now, Copy Job can automatically capture inserts, updates, and deletes from supported source databases and replicate them to the destination. Your target system stays continuously synchronised without the need for complex pipeline logic.
A Turning Point for Data Engineering:
•The burden of manual change tracking is eliminated
•Data freshness is guaranteed
•Pipeline development time is significantly reduced
•Real-time data synchronisation becomes achievable
•Data engineers can focus on more strategic work
•When CDC is enabled on the source, only changed data is transferred
7. Extended SCD Type 2 Support in Copy Job for Fabric Warehouse
Slowly Changing Dimensions (SCD) Type 2 is the industry standard model for tracking how data evolves over time.
Figure 5: The SCD Type 2 update method in Copy Job Settings, with key column definitions and merge operations configured.
Where does it fit and what problem does it solve?
Managing SCD Type 2 scenarios in data warehouse design has always required extra effort and complex SQL or ETL logic. Now, the native SCD Type 2 support within Copy Job — with effective dating and built-in soft delete handling — helps you preserve the full history of changes. This capability has now been extended to cover Fabric Warehouse as well.
For example, in dimension tables such as product information (Product, ProductCategory, ProductDescription), when a product's price changes, the old record is marked with validity dates and a new record is inserted. This makes it possible to answer questions like "What was the price of this product on 15 June 2024?"
Practical Benefits for Data Warehouse Design:
•Consistent SCD Type 2 experience across source and target systems
•Automating the tracking of how a record changes over time
•Graceful handling of deleted records
•Audit trail and compliance requirements are met
•Historical analysis and trend analysis become far easier
•Dimension tables remain clean and manageable
•Merge operations are automated once key columns are defined
Conclusion
The June 2026 updates are a strong reflection of Microsoft's vision to "make the complex simple." The UDFs and UI improvements in Power BI give report developers room to breathe, while the CDC, SCD Type 2, and SAP integration capabilities on the Fabric side make building and managing enterprise data architectures considerably smoother.
As an MVP, I am particularly excited about DAX UDFs and native CDC becoming standard practice across our projects. These features will allow data platform teams to spend less time on repetitive tasks and more time on strategic, creative work. If this momentum continues in the months ahead, I believe Microsoft Fabric and Power BI will only strengthen their leadership position in the data industry.
Insights & Updates
15.06.2026
