What's new and planned for Power BI in Microsoft Fabric
Important
The release plans describe functionality that may or may not have been released yet. The delivery timelines and projected functionality may change or may not ship. Refer to Microsoft policy for more information.
Microsoft business intelligence (BI) helps drive a data culture where everyone, at every level of an organization, can make confident decisions with data at any scale. To enable organizations to drive a data culture, we continue to invest across three key themes that we've introduced before: Power BI makes it easier than ever for every individual, every team, and every organization to work with data.
Empower every individual, Power BI provides familiar Office-like experiences and infuses artificial intelligence (AI) to increase user productivity. With the introduction of Power BI Copilot, we’re transforming how users interact and work with data by automating steps in the report creation workflow.
Empower every team, Power BI is integrated deeply with Office. It brings insights to Teams and Outlook, where everyone collaborates with deep integration in key experiences, such as meetings, channels, and chats.
Empower every organization, Power BI provides scale to meet the most demanding needs of large enterprises. With centralized administration, governance, and industry-leading security capabilities in Power BI, IT always has full visibility and control.
Estimated release timeline: Q4 2024
Release Type: Public preview
Subscriptions delivered to your email are a great way to ensure that you don't miss reports which help you drive your business. With copilot summaries in the email, we do the heavy lifting for you and deliver the most important insights so that you can focus on acting on the insights instead of deriving them. Copilot summaries are optional and can be added as a part of the subscription setup for new or existing subscriptions.
Estimated release timeline: Q4 2024
Release Type: General availability
Service principal profiles (SPPs) allow ISVs to build scalable applications that enable better customer data isolation and establish tighter security boundaries between customers. We have heard from customers that lack of XMLA support for SPPs limits the ability of ISVs to meet the requirements of their customers for more advanced BI solutions. With XMLA-based support for SPPs, ISVs can enable their customers to work with 3rd-party tools, automation scripts, and other solutions that rely on XMLA. For more information, see Use service principal profiles to manage customer data in multitenant apps.
Estimated release timeline: Q4 2024
Release Type: Public preview
TMDL View offers a "semantic modeling as code" experience with Tabular Model Definition Language (TMDL) within Power BI Desktop. It enables users to script, modify, and apply changes to semantic model objects in a modern code editor, significantly enhancing user efficiency. Future updates will integrate Copilot for handling time-intensive tasks such as model translations, documentation, bulk operations, among others.
Estimated release timeline: Q4 2024
Release Type: Public preview
This feature aims to empower self-service users by providing confidence to recover from critical mistakes when editing semantic models on the web. Versions will be automatically captured in an Office-like version history pane for your web-edited Premium semantic models, allowing you to easily select and restore to any of these previous version of your semantic model. We plan to support Pro workspaces as well in a future release.
Estimated release timeline: Q1 2025
Release Type: Public preview
With this release, the data model editing in the web preview will be enabled by default for Premium workspaces. This allows Power BI users to modify existing semantic models on the web by editing relationships, creating DAX measures, and managing row-level security. We plan to support default on for Pro workspaces as well in a future release.
Estimated release timeline: Q1 2025
Release Type: General availability
Use Fabric Copilot for Power BI to create descriptions for your semantic model measures. The description property is important documentation for your measures, as only the measure name and description are available to those who are making reports from your semantic model. Fabric Copilot can make your semantic model documentation easier by generating measure descriptions for you. This is when you create the measure and when you update the DAX formula of a measure, at each stage Copilot can quickly generate or update the measure description, helping you maintain your documentation and maintaining your workflow.
Estimated release timeline: Q1 2025
Release Type: General availability
DAX query authors can use Copilot for DAX query generation to write, edit, or explain DAX queries on their model data. Ask what data you want to see returned and Copilot will give you the DAX query. Copilot can also be used to add a column or formatting to an existing DAX query, even finding the column in your data. Finally, Copilot can explain what a DAX query is doing or tell you more about specific DAX functions. This is a huge productivity boost in authoring DAX queries.
Estimated release timeline: Q1 2025
Release Type: Public preview
Annotations allow users to add descriptive text to a specific data point within a visualization. They serve as contextual explanations or highlights, aiding viewers in comprehending the visualization. Annotations benefits are: Enhanced Communication: Annotations aid in effectively communicating insights, explanations, or observations within the visualization itself, reducing the need for external documentation or additional explanations. Its main purpose is to highlight key insights, or mark data that need to be explained. Contextual Clarity: Annotations provide contextual information directly on data points, allowing viewers to better understand the significance of specific elements. Presentation and Collaboration: Annotations facilitate effective presentation of visualizations and enable collaboration by providing a platform for discussions and shared insights within the visualization.
Estimated release timeline: Q1 2025
Release Type: Public preview
Supporting deeper questions in Power BI’s Copilot will enhance the tool’s diagnostic capabilities by enabling users to ask "why" questions directly in a conversational format, and offering the “why” behind interesting spikes/dips in data pre-emptively in summary responses. Leveraging AI, Power BI can provide more context, automatic data exploration, and suggest possible explanations based on the underlying data, without requiring the user to manually perform complex analyses.
Copilot in Power BI will detect patterns in the data, highlight drivers of change, and present users with visual and natural language explanations, making it easier to understand why certain trends or anomalies are occurring. This will improve the user experience by providing on-demand, intelligent assistance.
Estimated release timeline: Q1 2025
Release Type: Public preview
Updated experiences in Power BI Desktop will allow users to easily create reports from a metric and it's related dimensions rather than the entire source semantic model where the original measure lives. The desktop data pane will include updated icons that make clear which items are measures, and which dimensions are associated with them for easy creation experiences.
This will make it easy to:
- Bring in multiple metrics from different semantic models in one go
- Identify metrics in the data pane
- Identify related fields in the data pane
Estimated release timeline: Q1 2025
Release Type: Public preview
The assistive Copilot in app experiences currently answers questions based on the specific report in view. With this improvement, Copilot will help users understand what reporting is available in the App through app-wide summaries, find specific reports in the App by topic, and continue to answer questions based on specific reports.
Estimated release timeline: Q1 2025
Release Type: Public preview
Introduce robust support for Application Lifecycle Management (ALM). The Public Preview of Org Apps will be updated to support change management via Git and can leverage Fabric Deployment Pipelines. This enables scenarios such as source control integration, version management, Continuous Integration and Continuous Delivery (CI/CD) for repeatable mission-critical deployments.
Estimated release timeline: Q1 2025
Release Type: Public preview
When Fabric Org Apps rely on a semantic model built on Direct Lake, Read access will be granted when Org App access is granted. Item permissions are propagated from the Report item to the underlying Semantic Model and, if necessary, the Lakehouse or Warehouse.
Estimated release timeline: Q2 2025
Release Type: Public preview
We are continiously making a ton of improvement in the core visuls space and in this upcomming update we will be working on several of your top items including:
- New Azure Map Layers
- Continued slicer improvements, including a new text slicer
- Updates to our new Card visual
Estimated release timeline: Q2 2025
Release Type: Public preview
In this update, it will now be possible to interact with visual calculations using a point and click UI similar to that of Excel. We are also extending the available functions and templates.
Estimated release timeline: Q2 2025
Release Type: Public preview
This improvement to Fabric Org Apps will add support for defining user access and content display by audience(s), like the functionality in Power BI workspace Apps. Audiences will allow for conditional display of content in the Org App according to the audience or audiences a user belongs to. For instance, app creators can create one audience that can see only a subset of report within the app, but another audience with managerial oversite to make use of all of the reporting.
Estimated release timeline: Q2 2025
Release Type: Public preview
We are introducing easily discoverable entry points for semantic link templates within Power BI. This enhancement will simplify leveraging the power of semantic link and notebooks by providing access to valuable templates like the Best Practice Analyzer and VertiPaq Analyzer, with all configurations pre-set for you.
Estimated release timeline: Q2 2025
Release Type: Public preview
Power BI is standardizing on open-data formats by adopting Delta Lake and Parquet to help you avoid vendor lock-in and reduce data duplication. This minimizes data silos and fragmentation, offering a single source of truth across the enterprise. Direct Lake accelerates time to data-driven decisions by unlocking incredible performance directly against OneLake, without the need to manage costly, time-consuming data refreshes for large volumes of data in OneLake.
Create Direct Lake semantic models from Power BI Desktop from any OneLake source, not only Lakehouse or Warehouse. This feature allows users to build and maintain Power BI semantic models that query data directly from the lake, without depending on the SQL endpoint, enabling faster performance, simpler security management.
Estimated release timeline: Q2 2025
Release Type: Public preview
TMDL View Copilot is an inline assistant designed to help semantic model developers automate tasks like translating models into different languages or setting description properties for documentation. It also supports AI-powered script manipulation for bulk operations, such as renaming or batch creation of measures. TMDL View Copilot helps you focus on what you love and handle tasks you don't.
Shipped feature(s)
Copilot in Power BI Mobile apps
Shipped (Q4 2024)
Release Type: Public preview
Helping the on th go user to get immidiate answers to their data questions but asking Copilot data questions directly from their mobile app. Helping the users to uncover insights that exist in the model, but might not always be visible in the visuals on the report, or just hard to understand from the mobile form factor.
Visual improvements
Shipped (Q4 2024)
Release Type: Public preview
We are continiously making a ton of improvement in the core visuls space and in this upcomming update we will be working on several of your top items including:
- Layout options for the matrix visual
- Reference layer enhancements for the Azure Maps visual
- Improved legends for cartesian charts
- More flexible markers for line and scatter charts
- A completely revamped list slicer
NFC Support in Power BI Mobile apps
Shipped (Q3 2024)
Release Type: Public preview
Integrating Power BI Mobile apps with NFC card, to enable organizations to make Power BI reports easily accessible for their frontline workers, who work in various places and need quick access to data for making informative decisions. Using the Power BI Mobile app, user can configure an NFC card with any Power BI item. Later, other employees can use their mobile app to see this report just by tapping the same NFC card.
Connect to Power Query data sources and create paginated reports using PBI Report Builder
Shipped (Q3 2024)
Release Type: General availability
Create print-ready paginated reports in Power BI Report Builder by connecting to over 100 data sources using the Get Data experience. You can transform and load
Leverage parameterized, paginated reports functionality from PBI Report Builder with 100+ data sources by connecting using Power Query. Create pixel-perfect, print-ready paginated reports using data sources such as Snowflake and Databricks without requiring ODBC or an on-premises data gateway, and publish them to the Power BI service.
Organizational Apps for Fabric
Shipped (Q3 2024)
Release Type: Public preview
Power BI apps are one of the easiest ways to package up and securely distribute Power BI reporting to your organization in a customized and easy-to-use experience. Previously one Power BI app could be created per workspace. With apps rebuilt for Fabric, multiple organizational apps can be created per workspace. Apps can contain more than just Power BI items like reports, but Fabric items like notebooks too. And the app experience can be customized in new ways with more control over the color (choose any color), navigation style, and landing experience.
Live edit of Direct Lake semantic models in Power BI Desktop
Shipped (Q3 2024)
Release Type: Public preview
Previously, you could only create and edit semantic models using the incredible query performance of Direct Lake for your lakehouse based reports from the Power BI service. With live edit of Direct Lake semantic models in Power BI Desktop, you can also edit these semantic models in Power BI Desktop. Access the full power of semantic modeling capabilities and Git integration provided by Power BI Desktop for Direct Lake models! You can live edit semantic models by selecting the semantic model in OneLake Data Hub and simply click “Edit”.
Dark mode support in Power BI Desktop
Shipped (Q3 2024)
Release Type: Public preview
This feature allows users to toggle dark mode insiode Power BI Desktop
Dynamic per recipient subscriptions
Shipped (Q3 2024)
Release Type: General availability
With dynamic per recipient subscriptions, you can set up a single email subscription that delivers a different copy of a report to each recipient. Using data in a Power BI dataset, you can dynamically specify who should receive the subscription and with what data. For example, consider a multi-geo sales report. You can now send this report to all salespeople, with each receiving an email with an exported copy of the report with only sales data from their region. Support for dynamic subscriptions will be extended from only paginated reports to also include Power BI reports.
Deliver subscriptions to a OneDrive and SharePoint location
Shipped (Q3 2024)
Release Type: General availability
With the ability to deliver Power BI and paginated report subscriptions to a OneDrive or SharePoint location, users can now view reports that are too large to be delivered to their inboxes. Accessing these reports from OneDrive or SharePoint locations makes finding reports easy too. Users can also keep all the historical reports that they need.
XMLA endpoint support for service principal profiles
Shipped (Q3 2024)
Release Type: Public preview
Service principal profiles (SPPs) allow ISVs to build scalable applications that enable better customer data isolation and establish tighter security boundaries between customers. We have heard from customers that lack of XMLA support for SPPs limit the ability of ISVs to meet the requirements of their customers for more advanced BI solutions. With XMLA-based support for SPPs, ISVs can enable their customers to work with 3rd-party tools, automation scripts, and other solutions that rely on XMLA.
Copilot GA
Shipped (Q2 2024)
Release Type: General availability
Copilot in Fabric for Power BI is now Generally available. This capability allows report authors to quickly and easily create brand new reports using the natural language to express intent. Copilot will take the intent and will quickly convert it to a brand new report page consisting of visuals, measures and filters automatically layed out by Copilot.
Copilot answer questions
Shipped (Q2 2024)
Release Type: Public preview
This feature allows users to ask questions against their data model using Copilot even if the answer is not currently within the report
Create and run DAX queries with Query view in Power BI Desktop
Shipped (Q2 2024)
Release Type: General availability
The DAX query view allows BI developers to create and run DAX queries in Power BI! Use the existing DAX query syntax to quickly query your data model.
DAX expressions are used to define any measure, calculated column, calculated table, dynamic format string, calculation item, and row level security on your model. But that is not all you can do with DAX. With the DAX EVALUATE keyword, you can also use DAX to create a DAX query. This is much like a SQL query where you can specify columns and aggregations to return in a result table. You can learn more about DAX queries at DAX queries.
This powerful way to interact with your data model will be available in the new DAX query view! We give you several ways to help you be as productive as possible with these DAX queries:
- Quick queries in the context menu of the Data pane tables, columns, or measures gives you a head start by creating a DAX query to preview data or show summary statistics to help you understand the data without creating visuals and for DirectQuery you no longer must go back to Power Query to see some sample data.
- Right-click in the Data pane to get the DAX expression of all measures or a specific measure in a DEFINE statement with an EVALUATE statement to run as a DAX query and add any additional columns.
- If you modify that DEFINE measure from the model definition, a time saving option to update model can overwrite the current model definition with your changes – you don’t have to copy paste it back manually.
- If you use DEFINE to create a measure not in the model already, a time saving option to add to model can be used to add this measure to your model! Again, saving you the step of going new measure and then copy pasting the DAX expression over.
- If your measure references another measure, you can define the measure and all the references, meaning all the measures DAX expressions are visible on one screen! Now you can see the full context of how this measure is calculated from the source columns.
- Performance Analyzer already lets you copy the visual DAX query. Now you no longer need to take that DAX query and use another tool to view and run it – simply run the visual DAX query in Power BI.
Author calculation groups in Power BI Desktop
Shipped (Q2 2024)
Release Type: General availability
Calculation groups provide a simple way to reduce the number of measures in a model by grouping common measure expressions. Calculation groups work with existing explicit DAX measures by automating repetitive patterns. For example, a sales analyst might want to view sales and order quantities by month-to-date (MTD), quarter-to-date (QTD), year-to-date (YTD), orders year-to-date for the previous year (PY), and so on. With this enhancement, data modelers will be able to create calculation groups by using Power BI Desktop.
Model explorer provides easy navigation to author objects
Shipped (Q2 2024)
Release Type: General availability
The model explorer provides a convenient tree view of all the semantic model objects in the Data pane. The semantic model is all the metadata about your data, and it impacts how your data shows in reports and DAX queries. Model explorer shows all the semantic model items at-a-glance. Find items fast with the search. Focus on what you want to do by expanding and collapsing different item sections. Know how many of each item you have with counts on each section.
- Semantic model: Clicking on the top semantic model node shows a properties pane with semantic model settings such as discourage implicit measures.
- Calculation groups: Full authoring capability for calculation groups and calculation items. Including the only way to view and edit the calculation items.
- Cultures: Visibility only into the cultures of this semantic model.
- Measures: Visibility and authoring capabilities of all the measures in this semantic model, even when they are residing in different tables and folders.
- Perspectives: Visibility only into the perspectives of this semantic model.
- Relationships: Visibility and authoring capabilities for relationships. Including creating a new relationship with the properties pane.
- Roles: Visibility and authoring of row-level security in this semantic model.
- Tables: All the tables with sub-sections for columns, measures, hierarchies, and partitions.
Connect to new datasources and create paginated reports on PBI Report Builder
Shipped (Q1 2024)
You can create print-ready paginated reports from PBI Report Builder from datasources such as Snowflake and Databricks without requiring ODBC. You can then publish and share these reports on Power BI service.
Manage access to hidden content and link to content in Power BI organizational apps
Shipped (Q1 2024)
A new setting will allow organizational app creators to propagate access to an app’s hidden content to app users. In addition to improved control over access propagation, app creators will be able to copy links to content in apps from the app edit experience. The hidden content setting and ability to grab links to content give app creators control over the app navigation experience they have been asking for.
Stored credentials for Direct Lake dataset security in Microsoft Fabric
Shipped (Q1 2024)
By default, Direct Lake storage mode accesses data in a Microsoft Fabric lakehouse or warehouse by using single sign-on (SSO). With SSO, the credentials of the user interacting with the Power BI report (or XMLA client tool) must have permission to query the underlying lakehouse or warehouse. However, it’s possible to use stored credentials, in which case the dataset owner can disable SSO. That means end users don’t require permission to query the underlying lakehouse or warehouse, and data security can be set up in the Power BI dataset. Direct Lake datasets can implement dataset data security, like row-level security (RLS) and object-level security (OLS).
Copilot in Power BI
Shipped (Q1 2024)
Release Type: Public preview
Copilot in Power BI brings advanced generative AI to experiences across Power BI report creation and consumption experiences. Copilot assists users to create new report pages by providing suggestions on how to analyze their data. It can also automatically create, format, and lay out visuals based on their natural language requests. Further, users can chat with Copilot in order to update and refine their report designs and to learn about the data presented in visuals. And most importantly, with Copilot the user is always in control. They decide what to keep, modify, or discard, and their data always remains their data.
Narrative with Copilot in Power BI
Shipped (Q1 2024)
Report creators in Power BI can use the new Narrative with Copilot visual to add generative AI summaries of their data within reports. Copilot provides suggested prompts that are used to summarize and find insights in data. Optionally, report creators can customize these prompts to fine tune the language, scope, and formatting of generated summaries. All insights generated by Copilot include citations that describe the sourced report data. Copilot summaries automatically regenerate when filters change, and they enforce any Power BI data security (like row-level security).
Copilot for DAX query generation
Shipped (Q1 2024)
DAX query authors can use Copilot for DAX query generation to write, edit, or explain DAX queries on their model data. Ask what data you want to see returned and Copilot will give you the DAX query. Copilot can also be used to add a column or formatting to an existing DAX query, even finding the column in your data. Finally, Copilot can explain what a DAX query is doing or tell you more about specific DAX functions. This is a huge productivity boost in authoring DAX queries.
Combine existing mapping visuals into one with Azure Maps
Shipped (Q1 2024)
Release Type: Public preview
Customers will get the best features of all mapping visuals rolled into a single visual. The new mapping visual supports the use of shapes, points, shading, and adding more data points than the current default map visual.
Control visual formatting with improved capabilities
Shipped (Q1 2024)
Release Type: Public preview
Power BI will add new formatting capabilities that will provide users with more control over the appearance of their visuals. New format options will allow setting the padding and margins of visuals, and their default values will apply good design practices that will result in appealing visuals.
Create reports in the Power BI service with new data sources
Shipped (Q1 2024)
It will be possible to create new reports in the Power BI service by using over 100 connectors and 300 transformations, supported by the full capability of Power Query Online.
Automatic mobile report layout in Power BI Desktop
Shipped (Q1 2024)
Power BI Desktop already supports creating an alternative report layout that’s optimized for mobile devices. However, the mobile layout is a blank canvas, which requires the report creator to add, size, and format visuals.
To increase productivity, a new experience will automatically generate the mobile layout by selecting a button. Report creators can accept this layout as the final design, or they can use it as their starting point.
Visual calculations
Shipped (Q1 2024)
Release Type: Public preview
A visual calculation is a DAX calculation that's defined and executed directly on a visual. Visual calculations make it easier to create calculations that were previously hard to create, leading to simpler DAX, easier maintenance, and better performance. See Using visual calculations.
Author calculation groups
Shipped (Q1 2024)
Calculation groups are a simple way to reduce the number of measures in a model by grouping common measure expressions. Calculation groups work with existing explicit DAX measures by automating repetitive patterns. For example, a sales analyst might want to view sales and order quantities by month-to-date (MTD), quarter-to-date (QTD), year-to-date (YTD), orders year-to-date for the previous year (PY), and so on. Calculation groups are supported by Power BI models, however they’re an engine-only feature. With this enhancement, data modelers will be able to create calculation groups by using Power BI Desktop.
Create and run DAX queries with Query view in Power BI Desktop
Shipped (Q1 2024)
Release Type: Public preview
Professional BI developers can write and run DAX queries natively within Power BI. Previously, as DAX queries is an existing feature, a BI developer would have needed to use third party external tools or use an API in order to write and run DAX queries. Now, they can write and run DAX queries natively in Power BI in context and with additional tools to quickly get started and productively use DAX queries.
Periodic refresh in Power BI Storytelling add-in to support Slideshow
Shipped (Q1 2024)
A Microsoft PowerPoint presentation can be configured to run in a continuous loop. This can be useful for general data displays, kiosks, or any other informational display that will run with or without interaction.
We are adding a setting to Power BI add-in that will tell the add-in to automatically refresh the data in the slide every configured interval, so when the presentation is set for a continuous loop, the data keeps updating showing the most recent insights.
Enhancing image capture in Power BI add-in for PowerPoint
Shipped (Q1 2024)
Previously, when users add Power BI report or visual to a PowerPoint presentation using the Power BI add-in, Power BI checks the user permissions before presenting any live data to those who view the presentation. But if the add-in was set as image, and when PowerPoint uses screen capture as a thumbnail, there is no check on who the user is. In this update we will allow users to tell PowerPoint whether to show the image to every user who has access to the presentation or to limit that only to those who have access to the report in Power BI. In addition, the default thumbnail will be disabled.
Dynamic per recipient subscriptions
Shipped (Q1 2024)
Release Type: Public preview
With dynamic per recipient subscriptions, you can set up a single email subscription that delivers a different copy of a report to each recipient. Using data in a Power BI dataset, you can dynamically specify who should receive the subscription and with what data. For example, consider a multi-geo sales report. You can now send this report to all salespeople, with each receiving an email with an exported copy of the report with only sales data from their region. Support for dynamic subscriptions will be extended from only paginated reports to also include Power BI reports.
Customize content access request messages for Power BI organizational apps
Shipped (Q4 2023)
Release Type: General availability
This feature will allow setting a custom entry point for each Power BI organizational app to an organization's internal access management system from Power BI Access Request messages. This feature will be especially useful for organizations that rely on security groups to control access to content.
Balance user queries with query scale-out GA
Shipped (Q4 2023)
Release Type: General availability
Query scale-out is a Power BI Premium feature that load balances user queries across multiple dataset read replicas in a pool of Power BI Premium nodes. Essentially, it speeds up query response times for high user-concurrency workloads. Additionally, dataset refresh operations benefit from increased isolation from the read replicas that protect user queries and improve performance. The management of query scale-out in Power BI is highly automated compared to other platforms, such as Azure Analysis Services. Also, adding and removing read replicas is performed dynamically based on live usage.