This time we’re going bigger than ever. Fabric, Power BI, SQL, AI and more. We're covering it all. You won't want to miss it.
Learn moreDid you hear? There's a new SQL AI Developer certification (DP-800). Start preparing now and be one of the first to get certified. Register now
Welcome to the March 2025 update for Power BI!
This month, we're thrilled to share with you a host of new features and improvements designed to enhance your data analysis and visualization experience. We've made significant strides in performance and usability, ensuring that Power BI continues to be a powerful tool for your data needs.
Some of the highlights include Desktop start-up performance improvements, Copilot generated DAX queries using user-created hierarchies, create semantic models in Direct Lake storage mode, and improved language understanding for data questions and ad hoc calculation support for data questions.
FabCon started off with a bang! Dive in to explore these exciting features and see how they can help you make the most of your data and be sure to check the Fabric Feature summary to find out what’s happening in the rest of the data landscape.
A_group_of_people_on_a_yellow_background_AI-generated_content_may_be_incorrect
After reviewing 500 entries over 4 weeks, judges have selected 4 incredible competitors who will be joining us on stage in Las Vegas for the Grand Finale! They will be building their visualization LIVE in front of hundreds of DataViz enthusiasts as they vie for the title of WORLD CHAMPION!
Congratulations to Santhanalakshmi, Injae, Jon, and Javier, our four finalists! Check out their data visualizations and over 40 other judges favorites!
A_yellow_sign_with_black_text_Description_automatically_generated
Version number: v: 2.141.1228.0
Date published: 3/30/25
Contents
Power_BI_March_2025_Feature_Summary
Figure 1: The GIF demonstrates a comparison between opening a blank report with the new improvements vs. the old version.
Power_BI_March_2025_Feature_Summary
Figure 2: The GIF demonstrates the comparison between opening a PBIX report with the new improvements vs. the old version.
To continue using the Report view Copilot chat pane, upgrade to the February 2025 version. It may not work as expected for versions before February 2025 after April 30, 2025.
This feature enables users to understand the content of a Power BI item more easily.
The button will be displayed for items that support Copilot and for users who have Copilot enabled.
This feature is available on all Teams and Outlook platforms, including desktop, browser, and mobile.
Power_BI_March_2025_Feature_Summary
Power_BI_March_2025_Feature_Summary
For instance, you can reference measures grouped in a specific folder to be shown by a hierarchy, and Copilot will generate a DAX query with those measures by that hierarchy with a simple user request. Using hierarchies and display folders streamlines the process of writing complex DAX queries. Especially in models with many measures or columns, display folders can help organize and logically group them.
A_screenshot_of_a_computer_AI-generated_content_may_be_incorrect
Columns and measures can be added to display folders using the Properties pane in the Model view. Patrick LeBlanc has a 2-minute video on how you can create hierarchies with EASILY create a Hierarchy in Power BI Desktop.
This is in addition to the recent updates allowing Copilot to understand your data better by using descriptions and synonyms on columns, tables, and measures. And including sample values from columns. Read more about how this improves Copilot at Microsoft Fabric Copilot to write DAX queries in Power BI update.
Previously, certain questions required the report author to curate terms to ensure Copilot could correctly understand and answer accurately. Now, with the full power of an LLM, Copilot can understand significantly more questions out-of-the-box, saving the report author curation time and saving the Copilot user time clarifying common terms.
| Before | After |
| Previously, Copilot struggled to understand that tea is a synonym for chai in the data without the report author adding this mapping to Q&A setup.
|
Now, Copilot understands this out-of-box because chai is a commonly known synonym for tea.
|
| Previously, Copilot struggled to understand what ‘export’ could mean in relation to products and suppliers.
|
Now, Copilot understands this by default and saves the user a click to confirm this common relationship.
|
| Previously, Copilot needed clarification for which instance value Ana refers to, even though there’s only 1 match in the data.
|
Now, Copilot correctly understands and saves the user a click because there is only 1 Ana in the data, no need to clarify first to produce the answer.
|
This month we’ve brought over the same DAX query generation capability you know and love from DAX query view to the Copilot pane. Now, Copilot pane can generate DAX queries to answer questions that require ad hoc calculations.
Questions such as:
A_screenshot_of_a_phone_AI-generated_content_may_be_incorrect
A_screenshot_of_a_chat_AI-generated_content_may_be_incorrect
Note: This is currently only available from Edit Mode of reports using Copilot. This is not yet available while using Copilot in read mode.
We are pleased to announce a public preview of the new enhancement that allows users to make their presentations even more engaging by adding data point annotations to the visuals incorporated into their slides.
A_screenshot_of_a_computer_AI-generated_content_may_be_incorrect
Annotations enable users to add descriptive text directly to visualizations, offering contextual explanations or highlights that improve communication and understanding. This feature transforms data storytelling by allowing users to communicate insights with greater efficacy and enhance the engagement and informativeness of presentations.
To utilize annotations, you first need to embed a single visual within the add-in in a slide. Then, simply select a data point on the visual, right-click, and choose ‘Annotate.’ You can then begin typing your text. You can reference the data point’s measure value and category values in the annotation, ensuring the content is connected to the actual data point. Typing ‘/’provides options that can be included in the annotation text.
A_screenshot_of_a_computer_AI-generated_content_may_be_incorrect
Annotations will display whenever the data point is visible. If the visual is filtered, resulting in the disappearance of the data point, the annotation will likewise disappear. Additionally, if the data updates and the data point is no longer part of the visual, the annotation will not be shown as well.
Annotations are specific to the presentation and slide where the visual was added, allowing users to provide content that is truly in the context of their presentation.
Notes:
A_screenshot_of_a_computer_AI-generated_content_may_be_incorrect
You now have the option to activate a global report setting in Power BI Desktop, enabling the ability to copy any report object name—including pages, visuals, bookmarks, and filters—to the clipboard.
Go to File > Options and settings > Report settings > Report objects and check the box next to ‘Copy object names when right clicking on report objects’.
A_screenshot_of_a_computer_AI-generated_content_may_be_incorrect
Once the setting is enabled, right-clicking on any report object will present the option ‘Copy object name’, which copies the object name to the clipboard.
A_screenshot_of_a_graph_AI-generated_content_may_be_incorrect
You can subsequently enter the name into the search bar of Windows Explorer or Visual Studio Code to efficiently locate or identify the object name within the PBIR folder:
A_screenshot_of_a_computer_AI-generated_content_may_be_incorrect
Copy report object name in the Service
It is also possible to copy report object name within the service during report editing. To do so, you must first enable the report user setting: open any report settings and enable the ‘Copy object names when right clicking on report objects’ option. (while it’s configured per report it’s a user setting, you don’t need to enable it for each report).
A_screenshot_of_a_computer_AI-generated_content_may_be_incorrect
When editing a report, you now have the capability to right-click on any report object and copy its name:
A_screenshot_of_a_computer_AI-generated_content_may_be_incorrect
This functionality is beneficial not only for identifying file names in PBIR file format, but also for performance troubleshooting through Workspace Monitoring or Log Analytics to link the DAX query to a visual in the report.
For example, you can easily find the DAX query of a visual by searching for its visual name:
A_screenshot_of_a_computer_AI-generated_content_may_be_incorrect
Running Sum = RUNNINGSUM([Sales Amount], [Fiscal Year])
A_screenshot_of_a_visual_matrix_showing_Sales_Amount_and_Running_Sum_by_Fiscal_Y
Additionally, the referenced column highlights can be turned off and on using the matrix highlights toggle that is on the right of the formula bar in visual calculations edit mode:
The_toggle_button_to_show_or_hide_matrix_highlights._It_is_located_on_the_right
This is only the beginning of making visual calculations even easier to use, so stay tuned for more! Learn more about visual calculations.
A_graph_with_a_line_AI-generated_content_may_be_incorrect
3. For Line and stacked column and Line and clustered column charts, we now support reference lines on the Y-axis. Dynamic reference lines (Min, Max, Average, etc.) are only available for Line and clustered column charts.
A_graph_with_blue_lines_and_numbers_AI-generated_content_may_be_incorrect
Mostly more formatting control, including Tile Layout for the multiples (M0 was Tabular Layout only)
A_screenshot_of_a_computer_AI-generated_content_may_be_incorrect
3 The titles of the small multiple headers can be oriented to the left, top, right, or bottom.
A_screenshot_of_a_computer_AI-generated_content_may_be_incorrect
4 You can now apply conditional formatting to elements of your new card based on the logic of each category.
A_screenshot_of_a_computer_AI-generated_content_may_be_incorrect
Remember, the new card visual is still in preview, to enable this new visual, follow these steps:
Users can now create personalized style presets. This new feature allows users to change multiple formatting options simultaneously while eliminating the need to manually change each formatting option individually.
A_screenshot_of_a_graph_AI-generated_content_may_be_incorrect
By creating and importing a custom JSON theme file that includes your desired style presets, you’ll unlock a new Style presets menu option within the Format Visual section of the Visualizations pane. Utilizing the Style dropdown, you can easily select any of your predefined style presets from the newly imported theme file to automatically apply formatting options to visual elements in their report, such as positioning elements or altering colors.
Power_BI_March_2025_Feature_Summary
When crafting a custom theme file, users can specify which style preset will be the default after importing, as shown here. If no preset is selected or defined, Power BI’s default settings will be applied, ensuring there are always fallback formatting options for visual elements.
In the following example, Demo Preset 1 sets the legend position to the bottom center and changes the gridline color of the value axis.
A_screenshot_of_a_computer_AI-generated_content_may_be_incorrect
In this next example, Demo Preset 2 moves the legend to the right side and changes the gridline color and the label color of the value axis.
A_screenshot_of_a_graph_AI-generated_content_may_be_incorrect
An error condition will occur, as shown below, when the theme is changed, causing the report to lose the reference to the preset definitions. This results in an author-only error message indicating that the preset cannot be found.
A_screenshot_of_a_graph_AI-generated_content_may_be_incorrect
This new style presets feature is available with this March 2025 update, so have a look and share your feedback.
For more information about custom theme files, JSON, and more, have a look at the MS Learn article entitled Using report themes in Power BI Desktop.
The Core Visuals team is dedicated to enhancing our features and functionality continuously. We’re committed to advancing our capabilities and we highly value all feedback. Please share your insights regarding this enhancement in the comment section.
Business users now have a dedicated Insights category, bringing together a comprehensive view of their key analytics assets. This category includes Reports, Dashboards, Organizational Apps, Fabric Insights such as Real-time Dashboards and AI Skills, and more. With this new category, users can effortlessly discover actionable insights tailored to their data, improving decision-making and overall analytics engagement.
A_screenshot_of_a_computer_AI-generated_content_may_be_incorrect
Create these Direct Lake semantic models in just a few clicks in Power BI Desktop.
With the preview feature turned on, select a Lakehouse or Warehouse from the OneLake catalog then Connect.
A_screenshot_of_a_computer_AI-generated_content_may_be_incorrect
Direct Lake semantic models read the OneLake data directly and are created in the workspace. Give the semantic model a name, pick a workspace, and select the tables you want to include then OK.
A_screenshot_of_a_computer_AI-generated_content_may_be_incorrect
The semantic model is created in the workspace and now you are live editing the semantic model in Desktop, easy as that!
A_screenshot_of_a_computer_AI-generated_content_may_be_incorrect
To bring in other tables, return to the OneLake catalog and pick another Lakehouse or Warehouse. Like when you created the semantic model, just pick a Lakehouse or Warehouse and click Connect. And it’s added to the semantic model.
From you can continue data modeling: add relationships, measures, calculation groups, hierarchies. DAX query view is available to view data in the tables and try out calculations.
For more information and any limitations about Direct Lake on OneLake during public preview see the Direct Lake overview documentation.
A_screenshot_of_a_computer_AI-generated_content_may_be_incorrect
Please note that if you rename or remove an object using TMDL view, it is essential to include Power BI metadata annotations changed Property and PBI_RemovedChildren to ensure your customizations are retained the next time you synchronize your Direct Lake semantic model with the Lakehouse.
For further information on tracking customizations, please refer to the Direct Lake in Power BI Desktop (Preview) documentation.
Screenshot_showing_the_version_history_pane
Additionally, you have the option to manually save versions to the version history for your semantic model.
Screenshot_showing_how_to_manually_save_version_history_from_the_File_menu
We highly value your feedback, so please share your thoughts using the feedback forum. For more details on this feature, including limitations, please refer to the Use semantic model version history (Preview) documentation.
On by default preview for Pro workspaces
With the release of semantic model version history for pro workspaces, we will start enabling the workspace-level preview feature for editing data models in the service. The Users can edit data models workspace setting will be turned on by default for Pro workspaces. If you prefer, you can still disable the workspace preview for your workspace, but we recommend keeping it enabled! Power BI administrators will still have the ability to enable or disable data model editing in the service for the entire organization or specific security groups through the admin portal.
For more details on the subject, reference the Edit data models in the Power BI service (preview) documentation.
Please continue to submit your feedback directly in the comments of this blog post or in the feedback forum.
Coming this month, you can now seamlessly open your Direct Lake semantic models for editing in Power BI Desktop directly from the web. Just like in Office products, simply select the Edit in Desktop (preview) option from the web to launch Power BI Desktop with the same Direct Lake model open and ready for editing.
A_screenshot_of_a_computer_AI-generated_content_may_be_incorrect
More details on the feature, including requirements, considerations, and limitations can be found in the Direct Lake in Power BI Desktop (preview) documentation.
We highly value your feedback on this feature and encourage you to share it through our feedback form or the Power BI Community.
A_screenshot_of_a_computer_AI-generated_content_may_be_incorrect
We are offering the following out-of-the-box experiences for your semantic models:
Best Practices Analyzer – When you run this notebook, the Best Practice Analyzer (BPA) will offer tips to improve the design and performance of your semantic model. By default, the BPA checks a set of 60+ rules against your semantic model and summarizes the results. These rules come from experts within Microsoft and the Fabric Community. You’ll get suggestions for improvement in five categories: Performance, DAX Expressions, Error Prevention, Maintenance, and Formatting.
A_screenshot_of_a_computer_AI-generated_content_may_be_incorrect
Memory Analyzer - When you run this notebook, the Memory Analyzer will show you memory/storage statistics about the objects in your semantic model (i.e. Tables, Columns, Hierarchies, Partitions, and Relationships). These statistics may be used to identify areas of performance optimization and memory reduction for your semantic model.
A_screenshot_of_a_computer_AI-generated_content_may_be_incorrect
Additionally, we are very excited to announce the Power BI Community notebooks gallery! Here you can explore and submit notebooks you’ve created to enhance your Power BI data analysis and reporting with the rest of the Power BI community.
For more details on this feature, including limitations, please refer to the What is semantic link? documentation.
We highly value your feedback, so please share your thoughts using the feedback forum.
More details on how to get started
A_screenshot_of_a_computer_AI-generated_content_may_be_incorrect
Git integration Microsoft Fabric empowers org app developers to seamlessly integrate their development processes, tools, and best practices directly into the Microsoft Fabric workspace. Setting up Git is as easy as a couple of clicks. Configure the Git repository and branch details in the workspace settings to set up a connection. Once set up, commit org app changes with confidence, knowing you can version or branch as you iterate on org app items and included items in your workspace.
Image_illustrating_Git_integration_benefits_work_with_versions_keep_a_history_co
Git enables org app developers to:
Items included in an org app (preview), like reports, use the source item in the workspace for display in the org app, unlike workspace apps that display versioned copies of included items after workspace app update. To date, workspace apps have allowed report authors to iterate on reports across just two stages without impacting the published copy of the report in a workspace app.
Now, with deployment pipelines support for org app items, you can create, manage, and deploy in stages that match your workflow. Compared to workspace apps that support just two stages, org apps support for deployment pipelines gives you the flexibility to add several stages based on your needs.
For example, after changes have been finalized, Fabric deployment pipelines enable org app authors or developers to automate or manually control the deployment of changes across different workspaces used for 1. development, 2. testing, 3. review, and 4. production stages.
Screenshot_of_new_deployment_pipelines_interface_illustrating_four_stages_of_org
Deployment pipelines enable org app authors and developers to:
With these updates, you're seeing the future of workspace apps being prepared within org apps (preview) by building on the power of the Fabric platform. As we work towards org apps general availability, we look forward to hearing your feedback and continuing to build out org apps to meet your consumer distribution and consumption needs.
For more information, see Microsoft Learn documentation related to CI/CD and org apps:
Previously, org apps had separate navigation panes; one for the org app itself and another for the report in view. With the combined navigation experience, you can now choose to show a single pane with report pages within the app navigation pane, eliminating the need for two separate navigation panes. This means that the pages of reports will be shown underneath the reports listed in the org app navigation pane, providing a more streamlined and cohesive user experience.
Screenshot_showing_that_the_combined_navigation_setting_for_org_apps_is_now_avai
Covered in the original org apps (preview) announcement, org apps offer a level of customization beyond workspace apps. And by adding this new combined navigation option you can customize an org app even more. Starting with whether you prefer to have the org app navigation collapsed or expanded by default. Or even turn off the org app navigation completely. And for those who prefer to show org app navigation, the combined navigation experience offers additional flexibility and control. Or, when a report is in view, you can choose to show a separate navigation of pages in the report. Explore these configurations and other combinations for your org apps. This level of customization ensures that you can create a unique and tailored experience for different groups within your organization.
This new option of combining the org app navigation and report navigation is like the previous version of org apps offered, known as workspace apps. Workspace apps allowed for a unified navigation experience, and the combined navigation experience in org apps builds on that foundation by providing even more customization options. By combining the navigation panes, org app consumers can enjoy a seamless and efficient way to access and interact with data in your org apps that may be familiar to them from workspace apps.
For more information on how you can customize your org apps, from custom branding to navigation settings, see Microsoft Learn documentation for org apps (preview):
Get started with org apps (preview).
https://youtu.be/dCJbMYuTyu4
Now, we are adding to the semantic model the ability to see which reports are connected to it as well.
Understanding which reports were created from a semantic model in Power BI is crucial for several reasons. It ensures the consistency and reliability of the data being used across different reports. When users know that the reports are linked to a common semantic model, they can trust that the metrics and calculations are standardized. This is particularly important in collaborative environments where multiple stakeholders rely on accurate data to make informed decisions.
To see the connected reports, open any semantic model in the app, and select ‘Linked content’ from the info pane. You can now view related reports you have access to, including those from different workspaces. The origin workspace of each report is shown below its name.
Learn more about working with semantic models in Power BI Mobile: Work with semantic models in the Power BI apps for mobile devices
A_screenshot_of_a_phone_AI-generated_content_may_be_incorrect
https://youtu.be/dCJbMYuTyu4
Furthermore, you can create a category hierarchy with multiple columns, which will allow the user to drill down with just a click or tap directly on the chart. Combo PRO provides intuitive user experience with full touch support, and it seamlessly cross-filters with other visuals to provide instant insights that enable swift and fully informed decisions.
Main features:
A_screenshot_of_a_graph_AI-generated_content_may_be_incorrect
A_screenshot_of_a_graph_AI-generated_content_may_be_incorrect
Key features:
Business use cases:
A_screenshot_of_a_screen_with_a_circular_chart_AI-generated_content_may_be_incor
A_diagram_of_a_company_Description_automatically_generated
Now, we’re excited to announce expanded capabilities with support for Rare Event Control Charts — specifically, the T chart and G chart. These charts are essential for monitoring events that occur infrequently, allowing for more nuanced control in scenarios where traditional control charts may not be sensitive enough. The T chart helps monitor the time between rare events, while the G chart tracks the count of opportunities between events. These new additions make the Attribute Control Chart even more versatile, enabling organizations to gain insights into low-frequency incidents, which are often critical yet challenging to monitor.
By expanding Power BI’s Attribute Control Chart functionality, we continue to support diverse business needs, helping teams identify issues promptly and maintain high-quality standards across all processes.
Ready to experience the Attribute Control Chart? Download it from AppSource today and explore its capabilities with your own data – try for free!
We hope that you enjoy the update! If you installed Power BI Desktop from the Microsoft Store, please leave us a review.
As always, keep voting on Ideas to help us determine what to build next. We are looking forward to hearing from you!
A_yellow_sign_with_black_text_Description_automatically_generated
You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.