Welcome to the June 2025 update!

pleblanc · ‎06-10-2025

Welcome to the June 2025 update!

This month’s update highlights several exciting preview features and an important action-required item for Power BI users. In preview, you’ll find updates to visual calculations, enhancements to numeric range and field parameters, both designed to offer greater flexibility and analytical power within your reports.

Additionally, there are new tenant settings for the Azure Maps visual, which require administrators to take action to ensure seamless integration and continued support. For a comprehensive look at these updates and further enhancements, we invite you to read on for more details in the following sections.

Power_BI_June_2025_Feature_Summary

Version number: v: 2.144.679.0

Date published: 6/9/2025

We have several updates for visual calculations this month. We are not only taking initial steps towards achieving the vision of reducing the need for typing, but we are also enhancing the robustness of visual calculations, so they are less prone to error when the visual type is changed. To top it off, we are adding visual calculations in Explore.

To learn more, refer to the visual calculations documentation.

Create visual calculations faster with parameter pickers

It is now even easier and faster to write visual calculations thanks to the parameter pickers. When you load a template or use one of the functions exclusive to visual calculations, the parameter pickers for all required parameters with defined options will appear.

A_screenshot_of_a_computer_AI-generated_content_may_be_incorrect

Then it’s just a matter of selecting the value you want from the drop down and you’re done. A couple of clicks is all that is needed. This makes creating visual calculations a breeze, demonstrated in the screenshot example:

A_screenshot_of_a_computer_AI-generated_content_may_be_incorrect

Of course, the colored highlights between the formula bar and the visual matrix will match:

A_screenshot_of_a_computer_AI-generated_content_may_be_incorrect If you still want to type or make more advanced changes you can do that still! Simply change the value and the parameter picker will disappear. As soon as you enter a valid value, the parameter picker will reappear.

Note that the parameter pickers right now are only available for required parameters on functions that are exclusive to visual calculations (and select other functions) that have a defined list of options. Required parameters that can take any text, or numerical value will not get a parameter picker, and neither will many DAX functions.

Visual calculations are more resilient to changes in the visual

If you previously created a visual calculation with an axis reference, such as COLUMNS, and then changed visual types resulting in the absence of COLUMNS, the visual calculation would produce an error and the visual would return an error. Starting with this release, a reference to a non-existent axis is permissible and will be ignored.

Additionally, if you write RUNNINGSUM([Sales Amount], COLUMNS) on a bar chart (which does not have a COLUMNS axis), the result will simply equal the value of Sales Amount:

A_screenshot_of_a_computer_AI-generated_content_may_be_incorrect

We often change visual types to find the best way to present your data. Visual calculations should now work without breaking due to invalid axis references, making them easier to use. For instance, here's the same visual calculation on a card (which has no real axis):

Power_BI_June_2025_Feature_Summary

The visual calculation did not produce an error, even though it referred to an axis that was not present. An axis that is not present is simply ignored.

Easily create calculations in Explore

This month, we added visual calculations to Explore. With Explore, it’s easy to perform quick and powerful data analysis. Visual calculations do the same but for calculations, so bringing the two experiences together made a lot of sense and makes Explore even more effective. Once you have opened your data in Explore, you can create a visual calculation from either the matrix or the visual by selecting ‘New visual calculation’:

A_screenshot_of_a_computer_AI-generated_content_may_be_incorrect

This opens the visual calculations edit mode which should feel familiar to you. Here you can enter your visual calculation just like you are used to doing in reports. The same tools are available, including the highlights, templates and parameter pickers:

A_screenshot_of_a_calculator_AI-generated_content_may_be_incorrect

After adding the visual calculation, the other visual will show the visual calculation as well (depending on the visual type):

Power_BI_June_2025_Feature_Summary

If the other visual is unable to display data after the addition of the visual calculation, it will enter an error state. In such cases, you may either remove the visual calculation or modify the visual type.

Visual calculations in Explore make exploring data even easier and more powerful.

Sparklines (Generally Available)

Sparklines are tiny charts shown within cells of a table or matrix that make it easy to see and compare trends quickly. They’ve been in preview since December of 2021 and are now generally available! Also, we have added great new functionality for those who work with both sparklines and calculation groups together as you can now decide how a calculation group is applied to the sparkline. You can choose between ‘Individual values’ (default) or ‘Entire sparkline’.

For new sparklines, calculation group selections will be applied to the individual values on the sparkline by default. If you change the setting to ‘Entire sparkline’, the calculation group will be evaluated over all the points on the sparkline. Existing sparklines will remain unchanged, and calculation group selections will continue to apply to the entire sparkline unless you change their configuration.

An example of this in practice is a measure that calculates the Sum of Gross Sales by totaling the Gross Sales.

Sum of Gross Sales = SUM( financials[Gross Sales] )

A measure called IsBigSales has been added, which compares the Sum of Gross Sales against a BigSalesSize cutoff value set to 1,000,000 using a field parameter.

IsBigSales = IF ( 'financials'[Sum of Gross Sales] >= BigSalesSize[BigSalesSize Value], TRUE, FALSE )

A calculation group was added that contains three calculation items:

Calculation Item Name	Expression	Description
Actual	Actual = SELECTEDMEASURE()	Show value always
Actual For BigSales Only	Actual For Big Sales Only = IF( [IsBigSales], SELECTEDMEASURE(), BLANK() )	Show value for big sales, otherwise return blank
Percentage Of Grand Total	Percentage Of Grand Total = DIVIDE( SELECTEDMEASURE(), CALCULATE( SELECTEDMEASURE(), ALLSELECTED() ) )	Returns the percentage of the grand total

A matrix was created to display the sum of gross sales by product. Additionally, a sparkline was added to illustrate the sum of gross sales by month.

A_screenshot_of_a_computer_AI-generated_content_may_be_incorrect

The sparkline that shows Sum of Gross Sales by Month Number is set to the default behavior of applying the sparkline to Individual Values:

A_screenshot_of_a_computer_AI-generated_content_may_be_incorrect

When switching the calculation group to 'Actual for Big Sales Only' using the slicer, it will evaluate each value on the sparkline. Therefore, it will display only values for months and brand combinations exceeding the 1,000,000 BigSalesSize cutoff. To enhance clarity, I have included a matrix that displays Gross Sales by Month and Product, utilizing conditional formatting to emphasize values above the cutoff. The highlighted values correspond with those on the sparkline:

A_screenshot_of_a_computer_AI-generated_content_may_be_incorrect

Let's set the sparkline to apply the calculation group to the entire sparkline. Now all sparklines appear because the calculation evaluates the total values without considering the X-axis (Month Number). Since each Product's Gross Sales exceed the cutoff point, all sparklines display. If we raise the cutoff to 3,000,000, some sparklines will disappear. I added a matrix with conditional formatting below to illustrate this behavior:

A_screenshot_of_a_computer_AI-generated_content_may_be_incorrect

The Sum of Gross Sales exceeds the cutoff for almost all Products, except Carretera and Montana. Consequently, it's not displayed in the matrix or as a sparkline for these products. Sparklines appear normally for other Product/Country combinations. 'Show items with no data' is enabled to display brands where the sparkline and Sum of Gross Sales return BLANK(); otherwise, those brands would be hidden.

It is important to recognize that applying a calculation group item, which performs an arithmetic operation, to a sparkline set to ‘Apply to entire sparkline’ is not supported. To illustrate this, I will change the calculation group to Percent of Grand Total (which indeed performs an arithmetic operation using DIVIDE). As a result, the visual showing the sparkline will show an error and prompt you to set the sparkline to 'Individual values' to display it correctly again:

Power_BI_June_2025_Feature_Summary

Pressing Convert or setting the sparkline to ‘Individual values' again will make the visual show again:

Power_BI_June_2025_Feature_Summary

Calculation groups and sparklines are a powerful combination! For more information about sparklines and calculation groups refer to the documentation.

Updates to numeric range and field parameters (Preview)

Numeric range parameters and Field parameters are a great way to provide flexibility to your report users. When working with a Power BI Project (PBIP) in Power BI Desktop with a semantic model that contains Direct Lake tables, you are remotely connected to that semantic model. This scenario is often called remote modeling. Field parameters were not supported in this scenario until today! As soon as you connect to that semantic model, you will be able to create field parameters:

A_screenshot_of_a_computer_AI-generated_content_may_be_incorrect

Additionally, this month we are enhancing accessibility to field parameters generated by UI. A button has been added in the model view within Desktop:

Power_BI_June_2025_Feature_Summary

You will also find a button when editing a semantic model in the Power BI service.

A_screenshot_of_a_computer_AI-generated_content_may_be_incorrect

Together, these changes make numeric range and field parameters just that little bit more powerful! More is coming soon, so stay tuned. In the meantime, learn more about field parameters and numeric range parameters in the documentation.

New Tenant Settings for Azure Maps Visual (Action Required)

We’re excited to share an important update to the Azure Maps visual in Power BI that gives you greater control over data residency and governance, while also simplifying the experience for administrators.

Historically, enabling Azure Maps required an admin opt-in due to reliance on third-party services for geocoding, which introduced compliance complexities around data leaving your tenant’s region. That’s now changing.

What’s new?

After work in recent years, the Power BI Azure Maps visual no longer requires sub processors for geocoding and guarantees EU and US customers’ data resides within the US and Europe geographic boundaries.

To support a wider range of customer needs, we’re also introducing granular tenant settings that let you:

Decide whether data can be processed outside your tenant’s geographic region.
Enable or disable the use of services (such as selection tools) that are supported by certified Microsoft Online Services sub processors.

These changes offer increased flexibility for organizations with stringent data-handling requirements. These tenant switches are included in the June release.

Power_BI_June_2025_Feature_Summary

The state of the tenant settings, outlined in the table below, will be dependent on whether you’ve enabled the previous Azure Maps setting or not.

Setting Name	Description	Default State
Users can use the Azure Maps visual.	When this setting is on, users will be able to create and view the Azure Map visual. Note: This does not control whether data is able to leave your region/compliance boundary for mapping purposes.	On by default, except for existing tenants that have explicitly turned Azure Maps off
Data sent to Azure Maps can be processed outside your tenant's geographic region, compliance boundary, or national cloud instance.	Azure Maps services are currently not available in all regions and geographies. With this setting on, data sent to Azure Maps can be processed in a region where the service is available, which might be outside your tenant's geographic region, compliance boundary, or national cloud instance.	Off by default, except for existing tenants that have turned Azure Maps on
Data sent to Azure Maps can be processed by Microsoft Online Services Sub processors.	Some Azure Maps visual services, including the selection tool, may require mapping capabilities provided in part by Microsoft Online Services sub processors. This setting will control the availability of these features.	Off by default, except for existing tenants that have turned Azure Maps on

Required Actions

To support these new capabilities, your organization must be on the April release of Power BI Desktop or later. If you’re on an older version, the Azure Maps visual will no longer work in your reports.

Additionally, customers outside the US and EU will need to explicitly enable a new tenant setting: Data sent to Azure Maps can be processed outside your tenant’s geographic region, compliance boundary or national cloud instance’ to allow Azure Maps mapping features to work as expected. If the visual is not enabled, the users in your organization will see this error message.

A_screenshot_of_a_computer_AI-generated_content_may_be_incorrect

This change will roll out to the various regions over the coming weeks, so if you still see just a single Azure Maps tenant setting, check back in over the coming week. In the meantime, check out the documentation for detailed guidance.

Support for mapping South Korean locations

For all users outside of South Korea, the Azure Maps visual in Power BI now supports geospatial scenarios involving South Korea. This enables you to build rich, map-based reports using Korean addresses and location data as part of global datasets.

To enable this functionality, you must turn on all three Azure Maps tenant settings, as Azure Maps depends on a mapping sub processor to provide geolocation support in South Korea:

Use Azure Maps visual.
Allow data to be processed outside your tenant’s geographic region, compliance boundary, or national cloud instance.
Allow Microsoft Online Services Sub processors to process data.

These settings ensure that address lookup and map interactions involving South Korea can be handled through sub processors hosted outside your local region.

Support for South Korea launching noon

While we can now support geocoding location data for South Korea for users in all our currently supported regions, South Korea itself is still currently unsupported. That said, we’re actively working to also enable Azure Maps support for South Korea within its geo-boundaries. Stay tuned for future updates as we work toward making the Power BI Azure Maps visual available in the South Korea.

Support for adding paginated reports to org apps (Preview)

It is now possible to include paginated report items in your organizational applications (preview). When you add content to your organizational application, please select the paginated reports you wish to incorporate and save the changes.

Power_BI_June_2025_Feature_Summary

Unlike workspace apps and unique to org apps (preview), the org app will propagate access to the paginated report AND the underlying semantic model that informs the paginated report. Your org app consumers can then view the paginated report from the org app. To learn more about Get started with org apps (preview), refer to the documentation.

Power_BI_June_2025_Feature_Summary

Use Copilot on reports in org apps (Preview)

Copilot is now available on reports in org apps (preview). In organizations where Copilot is enabled and licensed for use, the same Copilot available on reports viewed in workspace apps is now available for use on reports in org apps. From the Copilot pane you can understand what a report is about with summaries or get insights faster with questions about your data.

Screenshot_of_a_demo_org_app_with_an_report_loaded_in_the_content_area_and_the_C

Learn more about the preview of org apps and Copilot for reports.

Modeling

Power Query editing in the web for import models (Preview)

We know many of you were eagerly awaiting Power Query editing in the web for import models, and we’re just as excited to bring it to you. However, during the rollout, we encountered an unexpected issue that has delayed the release beyond June. The capability is now planned to ship in July. We apologize for the delay and any inconvenience this may cause.

Once available, this update will unlock a major enhancement to the existing preview experience for data model editing in the Service : the ability to make changes using Power Query for existing import models directly in the browser.

This means you'll be able to use Power Query in the web to:

Get data

Add new import tables to your existing semantic models directly on the web using the familiar Power Query ‘Get Data’ experience. Simply select ‘Get data’ from the Home tab of the ribbon to choose your connector and bring in new data to your semantic model.

Power_BI_June_2025_Feature_Summary

Transform data/Edit queries

Shape your data with the full Power Query editor, now available on the web. Select ‘Transform data’ from the Home tab of the ribbon to launch the rich, modern Power Query user interface.

Power_BI_June_2025_Feature_Summary

Refresh

Refresh both schema and data right from the web editing experience. Simply select ‘Refresh’ from the ‘Home’ tab while editing your semantic model.

For more details on the subject, refer to the documentation. Please continue to submit your feedback directly in the comments of this blog post or in the feedback forum.

Expanded support for write operations via External tools

External tools have become an important part of the Power BI ecosystem, especially for semantic modeling. They offer model authors enhanced capabilities to develop, manage, and optimize semantic models.

Previously, some write operations were restricted, blocking external tools from altering tables, columns, or query expressions, with changes reverted to the next Power BI Desktop refresh. Now, you can use external tools for any write operation on your semantic model.

Learn more about supported changes from external tools in the documentation.

Data Connectivity

Connect to Vertica database with the user-installed ODBC driver (Generally Available)

In February 2025, we announced the option to use the user-installed ODBC driver to connect to Vertica database, which allows you to leverage the native client tool provided by the data source. Now this feature is generally available.

Along with this update, note starting June 2025, connecting to Vertica database without on-premises data gateway (cloud connections) will no longer be supported and will result in an error. If you have such workload, please change to use the on-premises data gateway and install the Vertica ODBC driver.

To learn more, refer to the Vertica database connector documentation.

QuickBooks Online (Beta) connector under deprecation

The QuickBooks Online (Beta) connector is under deprecation. Starting June 2025, the connector will not be shown in the Power BI service, and the entry will be removed from Power BI Desktop in the upcoming July 2025 release. To learn more, refer to the QuickBooks Online connector documentation.

Connect to PostgreSQL database without manual driver installation

When connecting to a PostgreSQL database using an on-premises data gateway, you no longer need to manually install the Npqsql provider. Since the June 2025 release of the on-premises data gateway, we have provided a built-in Npqsql provider, ensuring a streamlined setup experience. For more information, refer to the PostgreSQL connector documentation.

Mobile

Org apps are now available in Power BI mobile! (Preview)

Org apps, which were introduced in the Power BI service earlier this year, are now available in the Power BI mobile apps, bringing all the same powerful capabilities to mobile. View org apps next to workspace apps in the app section or reach them via the workspaces you have access to. Navigate an org app using the overview page, optimized for mobile and featuring support for app color themes. Org apps function like any other item type in Power BI mobile, appearing on the home page, searchable, and can be marked as favorite. Fabric artifacts that are not supported in mobile will appear in the org app content and can be viewed in the browser.

For additional information about org app, please visit Get started with org apps (preview). More details about org apps in Power BI mobile can be found at Using org apps (preview).

Power_BI_June_2025_Feature_Summary

Developers + API’s

Power BI Project (PBIP) public JSON schemas

To support developer-friendly file formats, reports and semantic models saved as Power BI Project (PBIP) files, exported to Git, or accessed through the Fabric Get Item Definition API will in the coming weeks include a public JSON schema reference at the top of JSON files such as definition.pbir or definition.pbism.

A_screenshot_of_a_computer_AI-generated_content_may_be_incorrect

The schema URL is publicly accessible, allowing users to understand all available properties and their meanings through the file's evolution. Additionally, it provides built-in IntelliSense and validation when editing with code editors like Visual Studio Code. To learn more, see PBIP Json file schemas.

Visualizations

Drill Down Waterfall PRO by ZoomCharts

Visualize financial data in a slick and interactive visual with a wide range of customization features and user-friendly drill downs. What’s more, the latest update also introduces two new and exciting features for even better data storytelling – on-chart annotations and ‘Change’ indicators.

Main features:

Custom sequence: have full control over the column order with the Sequence field.
Drill down: use multiple categories to enable drill down directly on the chart.
‘Change’ indicators: compare two values (constant or calculated) and display the difference as an upwards or downwards arrow.
Automatic subtotal calculation: display subtotals even if you don’t have them in your data.
Annotations: display markers and comments on the chart from Comment and Comment Marker fields.
Customization: customize X and Y axes, legends, tooltip content, and adjust the appearance settings for positive, negative and total columns separately.
Thresholds: display up to four constant or dynamic thresholds as lines or areas.
Cross-chart filtering: dynamically filter data across multiple visuals to create interactive, insightful and intuitive reports.

Get Drill Down Waterfall PRO on AppSource

A_screenshot_of_a_graph_AI-generated_content_may_be_incorrect

Network Graph by Powerviz

The Powerviz Network Graph is a visual representation of Nodes and the relationships or connections between them. Its primary purpose is to illustrate how different entities are related or interact with one another.

Key Features:

Line options: customize node links with different styles and colors.
Node shape: choose from various shapes, icons, or upload your own.
Labels: display categories, values, and percentage labels.
Data colors: access 30+ color palettes, including color-blind-safe options.
Fill patterns: highlight nodes with patterns or upload your own.
Conditional formatting: highlight outliers based on measures or categories rules.
Clusters: group related nodes to reveal patterns.
Relationships: analyze node connections briefly.
Animation: add pop-ups and highlight effects.
Import/export: save and reuse themes easily.
Toolbars: gain advanced control over the graph.

Other features included are sorting, ranking, lasso / reverse lasso, grid view and more.
Business Use Cases: Customer Relationship Management (CRM), Supply Chain Optimization, Social Network Analysis (SNA).

Try Network Graph visual for FREE from AppSource
Check out all features of the visual: demo file
Step-by-step instructions: Documentation
YouTube Video: video link
Learn more about: visuals
Follow Powerviz: Powerviz on Linkedin

A_screenshot_of_a_cell_phone_AI-generated_content_may_be_incorrect

A_screenshot_of_a_computer_AI-generated_content_may_be_incorrect Revenue Filter by JTA - a Data Scientist's Visualization Tool

Smarter Revenue Filtering - Designed for Precision and Ease

Overview

Revenue Filter is a custom Power BI designed to give report users a more intuitive and flexible way to filter data based on revenue columns. Instead of using the traditional slider slicer, users can apply Excel-style filtering logic directly within their reports.

This visual allows you to select from multiple comparison types - greater than, less than, equals, between and more - via a simple dropdown, then enter the value to filter by. This makes it easy for anyone viewing the report to understand the exact filter being applied briefly.

Whether you're a business analyst, data scientists, or finance professional, this tool enhances your ability to quickly explore revenue data without clutter or confusion.

Key Features:

Excel-like Filtering Options: Use dropdowns for conditions like greater than, equals, between, etc.
More User-Friendly than Native Sliders: Know exactly what’s being filtered with no guesswork.
Customizable & Branded: Match colors, text, and styling to your report’s look and feel.
Set Default States: Preconfigure default filter type and value for a guided experience.
Editable Display Text: Customize instructional text or placeholders for your audience.

Resources

Download Revenue Filter by JTA for free: AppSource
Try it: Demo
Learn more about us:JTA The Data Scientists

Power_BI_June_2025_Feature_Summary

Decomposition Tree – All Expanding

New features were added to this visual in the latest update in April 2025.

1. Now you can add a target field to perform comparisons against primary measures.

A_diagram_of_a_graph_AI-generated_content_may_be_incorrect

2. You can add images to each node. Images should be stored as base64 type.

Power_BI_June_2025_Feature_Summary

3. The visual now supports vertical orientation.

A_screenshot_of_a_computer_AI-generated_content_may_be_incorrect

Resources

Download this visual from APPSOURCE
Download demo file from APPSOURCE
For more information visit https://www.excelnaccess.com/decomposition-tree/

or contact zubair@excelnaccess.com

Closing

That’s all for this month!

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!

Power_BI_June_2025_Feature_Summary

Power BI June 2025 Feature Summary

Welcome to the June 2025 update!

Contents

Events & Announcements

Power BI is turning 10! Come celebrate with us!

The Microsoft Fabric Community Conference is back x2! Join us in Vienna and Atlanta!

General

Secure Collaboration on Sensitive Data in Power BI Desktop

Reporting