Power BI continues to evolve with updates that make it easier to explore data, generate insights, and build more polished reports. This month’s release brings improvements across Copilot and AI experiences, reporting and modeling enhancements, new data connectivity flows, and updates to visualizations—helping you move faster from data to decisions.

______________________________________________________________

The European Microsoft Fabric and SQL Community Conference take place September 28 to October 1 in Barcelona, Spain, bringing together Microsoft experts and community leaders for exclusive content, live demos, and key announcements, along with more than 130 sessions spanning Fabric, Azure AI, Databases, Power BI, and Microsoft Purview. And of course, the live Dataviz World Championships finale!

The most recent event in Atlanta sold out. Don’t miss out and register for the Barcelona event with code FABCMTY200 to save €200.

______________________________________________________________

Copilot and AI

Explore Improvements

Set perspectives for Explore
If your report is built using a large data model, you can provide report consumers using Explore a more focused list of tables and fields by creating a perspective and then setting it as the Exploration perspective for your report. This makes the fields easier for them to navigate.

Figure: The perspective being used is visible in the data pane.

First, create your perspective. Then, you can set it in one of two ways

With the report open in the service, navigate to File > Settings > Report settings and then set your Explore perspective.
In desktop navigate to File > Options and settings > Options > Current File > Report settings and then set your Explore perspective.

Improved Auto-Expand Behavior for Matrix in Explore

Previously, when you added or reordered fields in the field well for your matrix, the matrix hierarchy wouldn’t always expand to show your newly added fields. Now, the matrix automatically adjusts which fields are expanded so the new field is visible, making it easier for users to see their changes. This behavior might be different from what you experience in your reports, depending on the settings the author has chosen.

Show or hide totals in tables and matrices

Users can now show or hide totals on matrix and table visuals right from the Explore toolbar.

Figure: Show or hide totals in Explore.

Report formatting carry-over

When users launch an exploration from a formatted matrix in a report, the formatting applied to that matrix during authoring is now carried over and visible in the exploration. Formatting that's part of the theme won't be carried over. If you'd like to clear any of the formatting, navigate to the more menu (...) in the visual toolbar, and select "Clear formatting"

Figure: Clear formatting with this option in the "more" menu.

______________________________________________________________

Copilot summary shortcuts

Summarize shortcut on the ribbon the Summarize shortcut, available on the report ribbon in Power BI Service, helps consumers quickly get a high-level understanding of their data. When selected, Copilot opens the report pane and generates a concise, report-wide summary that surfaces key trends, performance highlights, and notable changes across pages and visuals. This experience is designed to help users orient themselves quickly before diving deeper into the report.

Figure: The new Summarize button highlighted in the report ribbon.

Copilot summary shortcut on the visual header

For deeper analysis of a specific chart, Copilot summary is also available directly from the visual header. With a single click, Copilot opens the report pane and produces a visual-level, insight-focused summary of the selected visual. The summary calls out what stands out in the chart, such as trend shifts over time, differences across categories or regions, and key drivers of change, without requiring users to manually interpret every data point.

Figure: The new Copilot summary option highlighted on the visual header.

Learn more about these updates at Summarize a report with Copilot

______________________________________________________________

Copilot Narrative visual now supports embedding in customer applications (Preview)

The Copilot narrative visual now supports the app‑owns‑data scenario. Previously, Copilot narratives were available only in embed scenarios where the user owns the data or in secure environments. With this update, the narrative visual can also be embedded in customer applications where report consumers don’t need to sign in.

Learn more at Create a narrative visual with Copilot for Power BI.

______________________________________________________________

New Copilot Tooling Format (Preview)

The new Copilot tooling format for ‘Prep data for AI’ is now available in preview to store your Copilot metadata. Support for this format will roll out incrementally over the coming weeks, after which you can begin adopting it in your workflows.

This new Copilot tooling format offers multiple benefits:

Git-Friendly and Documented Format: The new Copilot tooling format is designed to be Git-friendly, making it easier for teams to collaborate, track changes, and resolve conflicts. Unlike the previous JSON-based LSDL format, which was difficult to edit and undocumented, the new format is structured, documented, and intended for direct editing and source control.
Customer and Developer Usability: The new format addresses developer pain points by providing a clear, documented structure for Copilot metadata, making it easier for advanced users and third-party tools to interact with and customize Copilot settings.
Decoupling and Futureproofing: Decoupling Copilot from Q&A simplifies the user experience while ensuring alignment with the planned Q&A deprecation.
Performance and Scalability Improvements: By moving Copilot metadata outside the Analysis Services database, the new format reduces the need to load large semantic models into memory just to access metadata, improving performance and scalability, especially for scenarios where only metadata is needed.

To learn more, refer to the Prepare Your Data for AI (preview) documentation.

______________________________________________________________

Reporting

Visual calculations and custom totals (Generally Available)

Visual calculations and custom totals allow you to create calculations for your visuals in a new way. Add running sums, moving averages, percent of parent, and other calculations directly in your visual without adding DAX measures to your semantic model. Visual calculations operate on aggregated data within the visual and they are aware of their row position within the visual giving you more flexibility on how you can define your calculations. To get started, select a visual, then New visual calculation from the ribbon or context menu, then use built-in templates or write your own expressions.

Figure: Create a new visual calculation directly from the ribbon or context menu.

To learn more, refer to the Using visual calculations documentation.

______________________________________________________________

Custom totals: None and Average (Generally Available)

Custom totals now include None and Average options in addition to the existing Sum, Min, Max, Count, and Count Distinct options. Right-click a numerical column in your table or matrix and select Customize total calculation to choose the aggregation method for your total row.

Figure: Choose “None” or “Average” as the total calculation for a numeric column.

To learn more, refer to the Custom totals documentation.

______________________________________________________________

Set as landing page (Generally Available)

Use landing pages to guide viewers to the right starting point. Designate any page in your report as the landing page to ensure report viewers always start on the right page. Right-click a page tab and select Set as landing page or use the page formatting pane to configure this setting. Use this when your report has a specific page, such as an overview or summary page, that provides the best starting point. With this set, no need to make sure you are on the correct page after you make changes to the report before publishing.

Figure: Set a report page as the landing page from the page tab menu.

To learn more about setting the landing page on your report, refer to the Set as landing page documentation.

______________________________________________________________

Default format string locale for dates and numbers (Generally Available)

You now have a report setting to display dates and numbers in a specific locale, regardless of your viewers' browser settings. When you set the format string locale for your report, all locale-aware format strings (e.g. date formats marked with an asterisk in Format options) use your specified locale instead of the viewer's browser locale.

This is useful when you need consistent formatting across your organization or when your report targets a specific region. Note that this setting only affects the report -- how values display in visuals—it doesn't change the semantic model's awareness of user culture. USERCULTURE() and metadata translations still use the viewer's browser locale.

Figure: Set a report-level format string locale for consistent date and number formats.

To learn more about report settings, refer to Default format string locale Power BI report setting documentation.

______________________________________________________________

Translytical task flows: optional parameters and default values (Generally Available)

Translytical task flows now support optional parameters and default value awareness. Reports pre-populate input fields with default values from your user data functions, and you can submit task flows without specifying every parameter value. This reduces friction when users interact with data function buttons in your reports.

Figure: Task flow input fields can pre-populate with default values.

Figure: Submit a task flow without specifying every parameter value.

To learn more, refer to the Translytical task flow overview documentation.

______________________________________________________________

Input slicer numeric column support (Generally available)

The input slicer now supports numeric fields and a numeric input mask. Add a numeric column to the input slicer then use operator syntax to filter values with expressions like ranges (1-2), greater than (>2), less than (<2), or simply add each number. Without a data column, you can also limit the slicer to numeric entry for translytical task flows, and invalid input now shows clear feedback.

Figure: Use numeric input and operator syntax in the input slicer.

To learn more, refer to the Create and use an input slicer documentation.

______________________________________________________________

Matrix auto-expand for embedded visuals and Explore (Generally Available)

Set a property so fields added to the matrix visual automatically expand in embedded scenarios. Use this when you're embedding reports in applications and want the matrix to display expanded hierarchies by default without requiring user interaction. Explore feature also now auto-expands as field are added to the matrix.

Figure: Enable matrix auto-expand behavior for embedded scenarios.

To learn more, refer to the Power BI Playground documentation.

______________________________________________________________

Text box in Power BI reports list formatting improvements (Generally Available)

Lists in text boxes now preserve formatting correctly, indentation renders as expected, and you can paste bulleted lists directly from Word. These improvements make it easier to add formatted text content to your report pages.

Figure: Bulleted and numbered list formatting in text boxes now pastes and renders correctly.

To learn more, refer to the Add Text Boxes, Shapes, and Smart Narratives to Power BI Reports documentation.

______________________________________________________________

Azure maps formatting pane (Generally Available)

The Azure Maps visual now has an updated formatting pane that aligns with the modern formatting experience in Power BI. Find map settings, layer options, and style controls organized in a consistent layout that matches other visuals.

Figure: Updated Azure Maps formatting pane aligned with the modern formatting experience.

To learn more about the Azure Maps visual and its capabilities, refer to the Get started with Azure Maps Power BI visual documentation.

______________________________________________________________

Modern visual defaults improvements (Preview)

This month's improvements to modern visual defaults continue to make your reporting experience faster. The theme dropdown now has an updated look and the title to remove custom theme is now with a new look and says reset to default. This functionality is not new, but the tile is updated to be clearer. This update also includes fixes: the slicer now defaults to dropdown mode without issues, and the first page of your report correctly uses the new canvas size.

Figure: Updated theme dropdown and “reset to default” label in modern visual defaults.

To learn more, refer to the Visual defaults in Power BI reports documentation.

______________________________________________________________

Column fixed and default width for table and matrix (Generally Available)

Specify exact pixel widths for columns in your tables and matrix visuals. In the formatting pane, type in any width value you want, or set a default width that applies to all columns. Auto-size behavior now includes a fixed width option, in addition to fitting to content and grow to fit options. The fixed width option lets you simply specify the exact default width to use on columns.

This preview feature gives you precise control over column sizing instead of relying on automatic sizing behavior and manually resizing a column on the visual itself with the mouse. These widths can be set differently between desktop and mobile views, giving you the ability to fine tune your visuals no matter where it’s viewed.

Figure: Set fixed pixel widths and default column widths for tables and matrices.

To learn more about table formatting options, refer to the Table and matrix visual overview documentation.

______________________________________________________________

Subscriptions support for Power BI reports in org apps (Preview)

You can now create and manage email subscriptions for Power BI reports directly within org apps (Preview), bringing a familiar and highly requested capability to this new content packaging experience.

With this update, consumers viewing reports in an org app can stay informed with scheduled email snapshots and links back to reporting, just as they would when accessing reports elsewhere in the Power BI service. This closes a key gap in org apps leading up to general availability, which previously didn’t support subscriptions like found in workspace apps.

Figure: Subscribe in org app and Subscription for a report in an org app.

To learn more about how subscriptions work for reports in org apps, refer to Email subscriptions for reports.

______________________________________________________________

Version History in Power BI Desktop

Version History in Power BI Desktop is now available for Power BI files saved to OneDrive and SharePoint.

Figure: New Dialog in Power BI Desktop showing Version History.

Capabilities

View previous versions of their reports directly in Desktop.
Open older versions in a new window for comparison or reuse.
Find key details like version number, last modified date, and who modified the file.
Work from earlier versions without overwriting the current file.

To access this feature, navigate to the top left flyout in Power BI desktop, and select ‘Version History’ button at the bottom of the flyout. Upon selecting the button, a dialog will open (pictured above) listing out all the versions and its relevant details.

Figure: New Version History Button in Power BI Desktop.

To enable Version History, your Power BI file must be saved to OneDrive and SharePoint, and you must have Save and Share to OneDrive and SharePoint enabled in Power BI Desktop.

To learn more, refer to the Power BI Desktop OneDrive and SharePoint integration documentation.

______________________________________________________________

Modeling

Faster access to Web Modeling for Semantic Model authors

Power BI is improving the authoring experience for users with edit permissions on semantic models. Going forward, when you access a semantic model, you’ll be taken directly to the web modeling experience instead of the model details page. Most of the generally available actions on the model details page are now integrated directly into the model view.

Figure: Web Modeling view page.

Figure: Semantic Model details page.

This change is designed to streamline your workflow by reducing extra navigation steps and helping you jump straight into model view for faster updates, smoother iteration, and a more intuitive authoring flow overall.

______________________________________________________________

Data connectivity

New Get Data experience in Power BI Desktop (Preview)

Getting started with data in Power BI is now simpler than ever. In the May release, we’re introducing the new Power Query Get Data experience (Preview) — a completely redesigned way to help you discover and connect to your data faster, bringing a unified place to find all your data sources.

Key highlights include improved data source discovery, a streamlined connection flow, and built‑in accessibility features such as keyboard navigation and dark mode. It also brings greater consistency to Power Query across Microsoft Fabric, Power BI Desktop, and Microsoft Excel.

Figure: New Get Data experience in Power BI Desktop.

To learn more about the new Get Data experience and how to get started, refer to the New Get Data experience in Power BI Desktop documentation.

______________________________________________________________

Visualizations

Card with States

Introducing the new Card with States: faster, smarter, and fully unlocked

The new generation of Card with States by OKVIZ, is a popular Power BI visual for KPI storytelling. After a period of pause, development is officially back and stronger than ever.

This new version has been completely modernized to align with the latest Power BI APIs, ensuring full compatibility with current features and readiness for what’s coming next.

What’s new:

Modern platform support - Fully updated to the latest Power BI APIs for future-proof compatibility.
Advanced color rules editor - Enterprise-grade conditional formatting, now available in a free visual.
All features unlocked - No licenses, no restrictions—everything is included.
Simplified experience - Cleaner options and improved usability.
Better stability - Multiple bug fixes and performance improvements.

Card with States continue to help you track performance through dynamic states, variance indicators, and trend lines—but now with more control, better usability, and a future-proof foundation.

Please note: the previous version is now labeled Card with States Legacy and will no longer receive updates or support.

We’re just getting started—more features are already on the roadmap. To learn more, refer to Card with States.

______________________________________________________________

Financial Reporting Matrix by Profitbase – Now with advanced sorting!

When reviewing financial performance, stakeholders need to quickly find the highest the outliers that drive decisions. Version 9.0 of the Financial Reporting Matrix puts that power in the hands of end users. You can now sort rows and columns alphabetically or by value, on the fly, with sorting state and formatting fully preserved in the Excel export.

The new version also includes:

Hide blank column children or those matching the parent name
Native drill-down, for significantly faster performance on large datasets
Conditional formatting by column index - no more hardcoded names that break when your data structure changes
For more feature details, refer to Financial Reporting Matrix v9.0.0.0-rc.

Additional capabilities for Financial Reporting Matrix:

Subtotals
In-cell commenting
Custom measures
Export to Excel with formatting
Custom measure placement
Hide empty columns
Specify thousand and decimal separator
Cross-highlighting/cross-filtering
Multiple column headers/pivoting
Expand/collapse columns and rows
Ragged hierarchy
Sticky column and row headers
Conditional formatting
Custom columns with calculations and much more

Resources

______________________________________________________________

Lollipop Chart by Powerviz

The Powerviz Lollipop chart is a variation of a bar chart that uses lines and dots to represent data points. It is perfect for highlighting specific trends to help stakeholders make informed decisions.

Key Features

Chart Options: Easily switch between vertical/horizontal charts.
Marker Style: Choose from Shapes, Charts, Icons, Images, or Upload a custom image.
Small Multiples: Split your visual into multiple smaller visuals.
Error Bars: Add error bars to show data variability, improving analysis accuracy.
Reference Lines & Bands - Add reference lines and bands to highlight benchmarks, targets, or important ranges.
Data Colors: Access to 30+ color palettes, including color-blind-safe options.
Race Chart: Enhance the chart by adding animations to show data changes over time.
Cut/Clip Axis: Trim/Adjust the axis to accommodate the outliers.
Dynamic Deviation: Analyze the deviation between two bars in a glance.
Preview Slider: Easily explore various sections of a chart in large datasets using a slider.
Conditional Formatting: Easily find outliers by using rules for measures or categories.

Additional features included are IBCS Support, Templates, Import/Export Themes, Data Colors, Ranking and more.

Resources

Try the Lollipop Chart visual for FREE from AppSource
Find all the visual features
Refer to the Lollipop Chart documentation for Step-by-step instructions
Lollipop Chart (Step by Step Tutorial) YouTube Video
Learn more about visuals
Follow Powerviz on LinkedIn

______________________________________________________________

TMap 3.1

The newly released TMap 3.1 has added new features for generating grid layer from point data in the marker layer or reference layers by aggregation or interpolation.

Grid map in the TMap visual can bridge the gap between proportional symbol map and choropleth map in providing geospatial and business intelligence. Grid-based heat map can be used for crime intelligence analysis, pandemic dispersal pattern analysis and disaster (tornado, earthquake, etc.) density analysis.

Figure: The map shows shooting incidents in Toronto during 2004-2025 by grid map and choropleth map.

The map shows spatial pattern and hot spots for shooting incidents in Toronto easily, that is, Jane-Finch area, Lawrence Heights, Downtown area extending east to Regent Park and west to Bathurst St.

Figure: A proportional symbol map shows shooting incidents in Toronto during 2004-2025. Note: With the symbols overlapped, it is difficult to retrieve accurate data.

Resources

Download and test TMap from Microsoft AppSource.
To learn more, refer to the TMap Tutorials, and the TMap blog about Grid Map.

______________________________________________________________

Drill Down Timeline PRO by ZoomCharts

Drill Down Timeline PRO now introduces dynamic thresholds, allowing targets to automatically adjust based on data or DAX measures instead of relying on static limits. This makes it easier to monitor performance against changing expectations and quickly identify when results exceed or fall below targets.

Designed for time-based analysis, Timeline enables users to explore trends and drill down through time hierarchies from years to milliseconds to understand exactly when performance changes occur.

New features:

Dynamic thresholds calculated from data or DAX measures
Threshold lines or areas automatically update based on filters, parameters, and data context

Key features:

Drill down through time hierarchies with a single click
Combine columns, lines, and areas in one visual
Display up to 25 time-based series
Show threshold lines or areas to track targets
Conditional formatting to highlight important changes
Cross-filtering across visuals
Pan across the timeline to move the selected time range
Animations for a more intuitive analysis experience

Use cases:

Track seasonal sales performance against monthly targets
Detect operational issues when metrics exceed safe limits
Compare actual results against dynamic budgets or forecasts
Track event trends over time

Get Drill Down Timeline PRO on AppSource.

______________________________________________________________

Multiple Sparklines

Multiple Sparklines now include several usability improvements. You can now switch between rows and columns of the visual with a single click. You can hide the rotate button from the Format Pane>>Table Settings. You can also add variance between bars in column chart by dragging the variance filed to compare any two columns. In addition, drill down or up to any level by clicking on level number, making it easier to navigate your data hierarchy.

Resources

Check out the Multiple Sparklines Update (April 2026) YouTube video.
Download the visual from APPSOURCE.
Download a sample pbix file.
For more information refer to Multiple Sparklines or contact us.

______________________________________________________________

Closing

That’s a wrap for this month! We hope these updates help you explore your data more efficiently, streamline report creation, and deliver clearer insights to your users. As always, we’re continuing to invest in improving the core Power BI experience—from AI-powered features to everyday usability—so you can build with confidence.

Watch the Power BI Update - May 2026

Download Power BI Desktop

noahfox · ‎05-20-2026

Gosh it would be really cool if these still went to my email like they did years ago.

PareshD · ‎05-20-2026

@murray-kp Would like to see the PowerBI Desktop for MacOs users.

PBI_VL · ‎05-20-2026

Can you still give a sql query as source when you use a database connection? It seems we can only load tables.

Tiemen-H · ‎05-21-2026

@murray-kp since this update the totals are in a different font, is this a known issue? In the screenshot below I expect Segoe UI Bold but it is a different Font? My cuurent version is: 2.154.956.0 64-bit (mei 2026)

Tiemen-H · ‎05-21-2026

@PBI_VL yes you can

PiotrVerde · ‎05-21-2026

Hello,

Regarding -

Default format string locale for dates and numbers (Generally Available)

When trying it out in Thin Report (connected live to semantic model) I've been hit with this message:

"Regional settings are not available because this file uses live connection to another model"

I can see that these settings are clearly on report level (json). Would it be possible to remove this constraint?

D_M_2 · ‎05-21-2026

@noahfox Hi. You can do this actually, not sure if it works as it 'used to' though (I may have missed it but didn't see anything similar in years prior), but if you 'Subscribe' on the main page you get emails for every blog post including the monthly release (I think this is new since they moved to the new forum style format?).

Mike_Carlo · ‎05-21-2026

for the feature Set perspectives for Explore, what happens when we have multiple perspectives?

can I select which perspective the exploration should be using?
I would want to be able to select from multiple perspectives in the explorer view

noahfox · ‎05-21-2026

@D_M_2, that must be pretty new. It used to be on the right hand side panel and trying to resubscribe hadn't worked for two years (after Fabric). I will see if this subscribe button works.

D_M_2 · ‎05-21-2026

To MS team,
In the 'modern visual default' preview[s], are there any plans to allow us to 'truly' set a different default page size via the JSON theme file?

We have a scenario where the 'old' page size works well and the new page size is far too big (when viewed on a smaller screen with several elements of 'page furniture' on a customer facing website/platform).

I can set a custom size in the JSON theme file per MS guidance, however if the user clicks 'Reset to default' it still defaults back to the original (new) larger size, which differs to how settings given/provided by the theme file normally behave?

jack555 · ‎05-22-2026

Please stop including third party visuals as part of monthly updates which is not available for so many reasons for majority of the users. If you wish, have a separate post for that. Those updates are not components of your products. Keep the monthly updates which are related to the first party only.

gveg · ‎05-23-2026

Was default landing page the most wanted feature? Doubt it as you could set the landing page by simply saving the report on the intended start-up page. Sadly there are many much more requested features sitting for years in Microsoft ideas forum with no attention.

AnalyticsAaron · ‎05-26-2026

I am able to utilize the new numeric field filter option via the Input Slicer when working from Desktop, however, once the report is published, the Input Slicer switches itself back to text which does not allow the slicer to be utilized at all since the associated data field is a numeric one. Any way to correct this or is this an expected discrepancy between desktop and the service?

DataZoe · ‎05-26-2026

@D_M_2

To MS team,
In the 'modern visual default' preview[s], are there any plans to allow us to 'truly' set a different default page size via the JSON theme file?

We have a scenario where the 'old' page size works well and the new page size is far too big (when viewed on a smaller screen with several elements of 'page furniture' on a customer facing website/platform).

I can set a custom size in the JSON theme file per MS guidance, however if the user clicks 'Reset to default' it still defaults back to the original (new) larger size, which differs to how settings given/provided by the theme file normally behave?

To have the experience you are looking for, you can set the new page size in the custom theme and then in the canvas settings all new pages will take the page you specify in the custom theme added to the report. You can't simply edit the base theme in the PBIP, changes there are ignored.

DataZoe · ‎05-26-2026

@AnalyticsAaron
I am able to utilize the new numeric field filter option via the Input Slicer when working from Desktop, however, once the report is published, the Input Slicer switches itself back to text which does not allow the slicer to be utilized at all since the associated data field is a numeric one. Any way to correct this or is this an expected discrepancy between desktop and the service?

This is still being rolled out, and depending on which region you are in it should start showing later this week or early next week.

AnalyticsAaron · ‎05-26-2026

Thank you!

D_M_2 · ‎05-27-2026

@DataZoe Regarding your response:

"To have the experience you are looking for, you can set the new page size in the custom theme and then in the canvas settings all new pages will take the page you specify in the custom theme added to the report. You can't simply edit the base theme in the PBIP, changes there are ignored."

Thank you for taking the time to respond, and I understand and have done this, but that was not my enquiry sorry. Specifically I have not attempted to edit the 'base theme' in the PBIP (I work solely with the JSON theme file in that regard, at scale editing the PBIP across hundreds of reports vs. a centralised theme file would not be logical), I'm specifically referring to what is expected behaviour for the JSON theme file in general, and the fact that the page size seems to behave differently. I understand why this might be the case right now, but wanted to know if there were any plans to change it so behaves like normal JSON theme file settings, as currently this could confuse our users due to the different behaviour.

To explain explicitly, let's say I decide I need the JSON THEME DEFAULT for the visual title[s] to be 18pt (I'm being extreme to make the point clearer). If I do this in my theme file, it will appear as the default, with no override, like so:

If I now change this to a more sensible 10pt in my theme file, assuming again no manual overrides are applied in addition, this too becomes the (true) default.

In both cases, as you can see, 'Reset to default' is greyed out, as the 'new default' has been supplied by the JSON theme file. This is expected behaviour.

By comparison, the 'default page size' JSON theme file setting does NOT behave in the same, consistent manner. Instead, the custom page size behaves like an override, which is auto-applied at the point of creating a new page (per your suggestion), but does NOT actually apply as a new/true default.

If I make this page size the classic size, for example, it looks like so when adding a new page (post theme file application).

As you can see, the option to 'Reset to default' is now live (not greyed out), indicating the new size isn't actually considered as the true default in PBI, and if the user clicks 'Reset to default', it reverts to the new page size (not given by the PBI theme file that's been applied).

I can appreciate this might seem a minor detail, but given the importance (for us as a company) of NOT using the new, larger page size, this small change in behaviour will be quite confusing for users who for years have had the experience of always being able to rely on 'Reset to default' to revert back to intended settings, including page size, hence my question.

I hope this is clearer now, thanks again.

MattB-Motive · ‎05-27-2026

Hi PBI team

Before this update I could use a measure in the image visual with an IF() statement that determines the visual output. After the update I can't add this measure anymore and get an error: InvalidOrMalformedSemanticQueryDefinition_MissingSelect

DataZoe · ‎06-01-2026

@PiotrVerde the scenario to set the report locale is supported for live connected reports, so this message is a bug which is fixed and will roll out in the coming weeks!

DataZoe · ‎06-01-2026

@MattB-Motive can you share more details?

DataZoe · ‎06-01-2026

@D_M_2 Ah! Yes, this is a bug, it should do as you expected, a new page size set in custom theme should become the "Reset to default" option. Thank you so much for taking the time to explain it fully. I'll work with the team to get this corrected.

AnalyticsAaron · ‎06-03-2026

@DataZoe I am still having the same issue with the updated input slicer functionality in regards to numeric values (when report is published to the service). Can you please advise on the specifics on rollout by region?

tjessome · ‎06-03-2026

Hello,

I utilize Analyze in Excel quite extensively to create connected Excel tables to semantic models (I am not referring connected pivot tables) . I noticed that the behaviour of these connected tables has changed since the latest update. It seems that when a connected table is generated using a MDX query (the default when drilling through a pivot table), "amount" columns seem now to be excluded by default. If I rewrite the query using DAX syntax, these columns show up again. This behaviour also only seems to happen when the model is published to PowerBI.com. For example, the following MDX query will not return any columns that are flagged in the service as an "Aggregation" type:

DRILLTHROUGH MAXROWS 500000 SELECT FROM [Model] 
WHERE (
   ([Measures].[BurdenedCost_USD],
   [ProjectInquiry_Test].[PROJECT NUMBER].&[036C243029])
)

However, if I rewrite the query using DAX, the "aggregation" type columns are returned as expected:

EVALUATE
CALCULATETABLE(
	DETAILROWS( [BurdenedCost_USD] ),
	ProjectInquiry_Test[PROJECT NUMBER] = "035C230306"
)

The table I am referencing in the above queries does not have an explicit "detail rows expression" specified, so it will just return whatever is in the table that the measure is housed in. I have tested that an explicit detail rows expression will force MDX to return "amount" / "aggregation" type columns when drilling through on a pivot table in Excel. So the moral of the story is to always be explicit with what you want to return when drilling through.

All that being said, I would like to understand whether this change in functionality / behaviour was intended, or perhaps a bug. @murray-kp @DataZoe any thoughts on this? This could significantly impact users exploring data in Analyze in Excel who aren’t familiar with detail rows expressions in tabular models.

murray-kp

@noahfox Please select the subscribe button on the landing page. Then you'll receive a notification when a new blog post is posted.

Power BI May 2026 Feature Summary

Contents

Events and Announcements

Build better data stories one visual at a time

Join Us at FabCon Europe in Barcelona

Copilot and AI

Explore Improvements

Copilot summary shortcuts

Copilot Narrative visual now supports embedding in customer applications (Preview)

New Copilot Tooling Format (Preview)

Reporting

Visual calculations and custom totals (Generally Available)

Custom totals: None and Average (Generally Available)

Set as landing page (Generally Available)

Default format string locale for dates and numbers (Generally Available)

Translytical task flows: optional parameters and default values (Generally Available)

Input slicer numeric column support (Generally available)

Matrix auto-expand for embedded visuals and Explore (Generally Available)

Text box in Power BI reports list formatting improvements (Generally Available)

Azure maps formatting pane (Generally Available)

Modern visual defaults improvements (Preview)

Column fixed and default width for table and matrix (Generally Available)

Subscriptions support for Power BI reports in org apps (Preview)

Version History in Power BI Desktop

Modeling

Faster access to Web Modeling for Semantic Model authors

Data connectivity

New Get Data experience in Power BI Desktop (Preview)

Visualizations

Card with States

Financial Reporting Matrix by Profitbase – Now with advanced sorting!

Lollipop Chart by Powerviz

TMap 3.1

Drill Down Timeline PRO by ZoomCharts

______________________________________________________________

Multiple Sparklines

Closing

Get Fabric or SQL Certified for Free.

Power BI May 2026 Feature Summary

Contents

Events and Announcements

Build better data stories one visual at a time

Join Us at FabCon Europe in Barcelona

Copilot and AI

Explore Improvements

Copilot summary shortcuts

Copilot Narrative visual now supports embedding in customer applications (Preview)

New Copilot Tooling Format (Preview)

Reporting

Visual calculations and custom totals (Generally Available)

Custom totals: None and Average (Generally Available)

Set as landing page (Generally Available)

Default format string locale for dates and numbers (Generally Available)

Translytical task flows: optional parameters and default values (Generally Available)

Input slicer numeric column support (Generally available)

Matrix auto-expand for embedded visuals and Explore (Generally Available)

Text box in Power BI reports list formatting improvements (Generally Available)

Azure maps formatting pane (Generally Available)

Modern visual defaults improvements (Preview)

Column fixed and default width for table and matrix (Generally Available)

Subscriptions support for Power BI reports in org apps (Preview)

Version History in Power BI Desktop

Modeling

Faster access to Web Modeling for Semantic Model authors

Data connectivity

New Get Data experience in Power BI Desktop (Preview)

Visualizations

Card with States

Financial Reporting Matrix by Profitbase – Now with advanced sorting!

Lollipop Chart by Powerviz

TMap 3.1

Drill Down Timeline PRO by ZoomCharts

______________________________________________________________

Multiple Sparklines

Closing