Share via


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.

Investment areas

Feature Estimated release timeline
Copilot summary for subscriptions Q4 2024
XMLA endpoint support for service principal profiles Q4 2024
TMDL View Q4 2024
Version history support for semantic models Q4 2024
Web Modelling - Default on Q1 2025
Copilot for measure descriptions Q1 2025
Copilot for DAX query generation Q1 2025
Data point annotations in Power BI add-in for PowerPoint Q1 2025
Answers to "why questions" in Copilot summaries Q1 2025
Guided experience for Metric sets in Power BI Desktop Q1 2025
Expanded Copilot support for Fabric Org Apps Q1 2025
ALM support for Org Apps Q1 2025
Automatic permission propagation for Org Apps Q1 2025
Visual Improvements Q2 2025
Visual calculations UI Updates Q2 2025
Audience support in Org Apps Q2 2025
Semantic Link Notebook integration for Semantic Models Q2 2025
Creation of Direct Lake semantic models in Power BI Desktop Q2 2025
TMDL View Copilot Q2 2025
Copilot in Power BI Mobile apps Shipped (Q4 2024)
Visual improvements Shipped (Q4 2024)
NFC Support in Power BI Mobile apps Shipped (Q3 2024)
Connect to Power Query data sources and create paginated reports using PBI Report Builder Shipped (Q3 2024)
Organizational Apps for Fabric Shipped (Q3 2024)
Live edit of Direct Lake semantic models in Power BI Desktop Shipped (Q3 2024)
Dark mode support in Power BI Desktop Shipped (Q3 2024)
Dynamic per recipient subscriptions Shipped (Q3 2024)
Deliver subscriptions to a OneDrive and SharePoint location Shipped (Q3 2024)
XMLA endpoint support for service principal profiles Shipped (Q3 2024)
Copilot GA Shipped (Q2 2024)
Copilot answer questions Shipped (Q2 2024)
Create and run DAX queries with Query view in Power BI Desktop Shipped (Q2 2024)
Author calculation groups in Power BI Desktop Shipped (Q2 2024)
Model explorer provides easy navigation to author objects Shipped (Q2 2024)
Connect to new datasources and create paginated reports on PBI Report Builder Shipped (Q1 2024)
Manage access to hidden content and link to content in Power BI organizational apps Shipped (Q1 2024)
Stored credentials for Direct Lake dataset security in Microsoft Fabric Shipped (Q1 2024)
Copilot in Power BI Shipped (Q1 2024)
Narrative with Copilot in Power BI Shipped (Q1 2024)
Copilot for DAX query generation Shipped (Q1 2024)
Combine existing mapping visuals into one with Azure Maps Shipped (Q1 2024)
Control visual formatting with improved capabilities Shipped (Q1 2024)
Create reports in the Power BI service with new data sources Shipped (Q1 2024)
Automatic mobile report layout in Power BI Desktop Shipped (Q1 2024)
Visual calculations Shipped (Q1 2024)
Author calculation groups Shipped (Q1 2024)
Create and run DAX queries with Query view in Power BI Desktop Shipped (Q1 2024)
Periodic refresh in Power BI Storytelling add-in to support Slideshow Shipped (Q1 2024)
Enhancing image capture in Power BI add-in for PowerPoint Shipped (Q1 2024)
Dynamic per recipient subscriptions Shipped (Q1 2024)
Customize content access request messages for Power BI organizational apps Shipped (Q4 2023)
Balance user queries with query scale-out GA Shipped (Q4 2023)

Copilot summary for subscriptions

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.

XMLA endpoint support for service principal profiles

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.

TMDL View

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.

Version history support for semantic models

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.

Web Modelling - Default on

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.

Copilot for measure descriptions

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.

Copilot for DAX query generation

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.

Data point annotations in Power BI add-in for PowerPoint

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.

Answers to "why questions" in Copilot summaries

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.

Guided experience for Metric sets in Power BI Desktop

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

Expanded Copilot support for Fabric Org Apps

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.

ALM support for Org Apps

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.

Automatic permission propagation for Org Apps

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.

Visual Improvements

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

Visual calculations UI Updates

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.

Audience support in Org Apps

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.

Creation of Direct Lake semantic models in Power BI Desktop

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.

TMDL View Copilot

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.

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.