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 Power BI July 2025 Feature Summary!
This month’s update marks a notable evolution for Power BI. With richer connections to Microsoft 365, smarter Copilot features, and the integration of reporting through PBIRS and SQL Server 2025, users are set to benefit from more seamless workflows and intelligent insights. Whether you’re eager for enhanced collaboration or advanced AI, this month’s innovations are designed to open new possibilities for every Power BI enthusiast.
The Microsoft Fabric Community Conference is back x2! Join us in Vienna and Atlanta!
Expanded data sharing with M365
PBIRS Will Consolidate On-Premises Reporting Services from SQL Server 2025
Improvements to standalone Copilot answers
Limit Copilot search to prepped content
Verified answers from Copilot search
AI Data Schema – updates (Preview)
Customized instructions for summaries through subscriptions
Narrative visual available in subscription snapshot and export
Textual responses for Data inquiries
New Power BI App Navigation Menu in Teams
Influencing sort for visual calculations (Preview)
Field parameters (Generally Available)
Organizational themes (Preview)
Improvements to Pie and Donut Charts
Direct Lake in Desktop from Mirrored and SQL databases
DAX query view and web modeling view switcher
Support for PQO Gateway Connections for Paginated Reports
Snowflake connector implementation 2.0 (Generally Available)
New Google BigQuery (Microsoft Entra ID) connector implementation (Preview)
New Databricks connector implementation (Preview)
Connect to Netezza database with the user-installed ODBC driver (Preview)
PostgreSQL connector adds support for Microsoft Entra ID authentication
Home in the Power BI mobile app has been reorganized
Power BI Enhanced Report Format (PBIR) Update
Stacked Bar Chart with Line by JTA - a Data Scientist's Visualization Tool
Drill Down Shape Map PRO by ZoomCharts
Inforiver Premium Table – High-Performance, Formatted, and Scalable Table Visual for Power BI
Inforiver Analytics+ 4.7 is here with 100+ Charts, Gantt, KPI Cards, and Tables
Version number: v:2.145.1105.0
Date published: 07/14/25
https://youtu.be/RABiSIUiCH4
Tune in for a special live episode on July 24 with behind-the-scenes stories, product evolution highlights, and a sneak peek at what’s in store for the future. Don’t miss the live Q&A, where you can ask your burning questions or just wish Power BI a happy birthday. Save the date.
Join us for contests and special giveaways to mark this milestone. Find all the activities at https://aka.ms/pbi10.
Let's make this a birthday to remember! #PBI10
Don’t miss out. Register here and use code MSCATL for a $200 discount on top of current Super Early Bird pricing!
Don’t want to wait until March? Join us at FabCon Vienna from September 15-18, 2025.
Register and use save €200 with code FABCOMM.
The previous version of M365 data sharing was limited to barebones metadata like report names and creation dates. To enable consumers to find data from where they usually work in M365, Power BI will begin sending more context about reports to M365 services. From chart titles and the descriptive text on your dashboards to the model’s last refreshed date, we know this extended metadata will make it easier to find the right reporting to make a data-driven decision.
June 2025 marks a change of terms for the scope of the data shared as controlled by the tenant admin setting. To learn more, refer to the Share data with your Microsoft 365 services documentation.
Stay tuned for updates in the upcoming months as new capabilities are shared.
For more information, refer to the Reporting Services consolidation FAQ documentation.
Full details can be found in the Standalone Copilot experience in Power BI (preview) documentation. Try it out and tell us what you think!
Admin settings have been introduced to support these use cases. Tenant admins can now set the default behavior for Power BI’s standalone Copilot to limit search responses to only items that creators have marked as Prepped for use with AI. Workspace admins can refine that control using the delegated workspace setting to allow Copilot to search across all content, or limit focusing on just prepped content.
A_screenshot_of_a_computer_AI-generated_content_may_be_incorrect
These settings will only affect the search functionality of Copilot. It is designed to give admins control to mitigate the risk of Copilot finding an ill-maintained or purpose-built report in a corner of your PBI tenant and using that report to answer a user’s data question.
Attaching an item directly allows data teams to test Copilot with new reports before they're ready, while business users can still get assistance from Copilot with their preferred reports. We encourage you to configure these settings to establish default behaviors that align with your organization’s needs and to utilize workspace settings to help your team access the most relevant content.
Tenant admins can find details in the tenant settings documentation. Workspace administrators can refer to the Copilot search documentation for instructions.
The question approved by the creator for the visual is included in the results list. This may closely match your original wording or simply contain related keywords. We display the question (also referred to as the prompt) to confirm its suitability as a starting point for Copilot to address your inquiry.
Common_questions_to_human-reviewed_answers_will_now_show_as_suggested_content_to
In this example, the first two options appear promising according to different reports. You can view the verified answers by typing ‘show me the first’ or by clicking the button ‘Use 1’. It is also possible to extend the conversation by requesting a summary of the associated report from Copilot, or by asking for a breakdown of veggie pizza sales by quarter.
As you continue to experiment with Copilot, we look forward to your feedback on how verified answers show up in our experiences and what you’re hoping for next. For a comprehensive understanding of Copilot search and our matching process, please refer to the Find content with Power BI Copilot search documentation.
Search box for fields: The new search box feature allows users to locate specific fields within their semantic model efficiently. This functionality simplifies the process of including or excluding fields in an AI data schema and is particularly useful when dealing with large models.
A_screenshot_of_a_computer_AI-generated_content_may_be_incorrect
Visibility indicators for hidden fields: A show/hide icon has been introduced to indicate which fields are not visible in the report view, offering information about the semantic model during the AI data schema definition process.
A_screenshot_of_a_computer_AI-generated_content_may_be_incorrect
These updates are designed to streamline your workflow and make it easier to prepare your data for AI. For more details, refer to the documentation on how to Prepare your data for AI - AI data schema. Please continue to submit your feedback directly in the comments of this blog post or in the feedback forum.
A_screenshot_of_a_report_AI-generated_content_may_be_incorrect
A_screenshot_of_a_computer_AI-generated_content_may_be_incorrect
To learn more, please refer to the Create a narrative Visual with Copilot for Power BI documentation.
Screens_screenshot_of_a_screenshot_of_a_phone_AI-generated_content_may_be_incorr
The textual answer also helps you understand why your visual answer may have been blank before. If your question resulted in no results from the data e.g. there were no sales in the region you’re asking about, now Copilot’s textual answer will respond accordingly to ‘there were no sales in that region’ and hide the blank visual. You can still explore the blank visual to swap out fields or add filters through Explore experience.
To learn more about asking data questions in Copilot, refer to the Ask Copilot for data from your model documentation.
Picture_1_Picture_Picture
To learn more about the Power BI app for Teams, refer to the documentation.
This improvement increases the flexibility and capability of visual calculations, allowing for advanced computations based on data sorting. For instance, you can now use RUNNINGSUM for Pareto analysis by sorting data in descending order.
To visualize your top-selling product colors, use a chart as demonstrated in the example:
A_blue_bar_graph_with_black_text_AI-generated_content_may_be_incorrect
This chart is sorted by sales amount in descending order, so the colors are not arranged alphabetically. To include the Pareto analysis, first calculate the percentage of the grand total sales that each color represents, using the provided visual calculation template 'Percent of grand total':
Percent of grand total = DIVIDE ( [Sales Amount], COLLAPSEALL ( [Sales Amount], ROWS ) )
Pareto = RUNNINGSUM ( [Percent of grand total] )
A_graph_with_blue_lines_AI-generated_content_may_be_incorrect
Creating a true Pareto line requires a more complex DAX statement, for example using SUMX and WINDOW:
Pareto using WINDOW =
SUMX (
WINDOW ( 0, ABS, 0, REL, ROWS, ORDERBY ( [Sales Amount], DESC ) ),
[Percent of grand total]
)
While this method is functional, utilizing RUNNINGSUM with the new ORDERBY parameter offers greater convenience. It significantly simplifies the process of adding the Pareto line:
Easy Pareto = RUNNINGSUM ( [Percent of grand total], ORDERBY ( [Sales Amount], DESC ) )
A_graph_with_a_line_going_up_AI-generated_content_may_be_incorrect
This is an example of how this new parameter enables more advanced and flexible calculations using visual methods. We encourage you to try it and share your feedback with us! To learn more about visual calculations, refer to the documentation.
This month, we improved how a matrix retains its expanded or collapsed state. Previously, if using a field parameter in an expanded matrix and switching the dimension or measuring the parameter selected, the matrix would collapse. Starting this month, efforts have been made to keep the matrix in the same state as possible. While it is not always possible or desirable to keep the same expansion state, it can often be useful. For example, in a matrix that shows sales by Product Category, a field parameter called Product Aspect can be added to allow choosing between product Class, Color, and Model. Upon selecting the product Class and expanding the first Product Category node (Accessories), the matrix appears as follows:
A_screenshot_of_a_computer_AI-generated_content_may_be_incorrect
Now, switching the column selected by the Product Aspect field parameter to Color will no longer collapse the entire matrix. Instead, starting this month, the expand and collapse state is preserved as much as possible. Therefore, when transitioning to Color, the initial Product Category (Accessories) remains expanded:
A_screenshot_of_a_product_category_AI-generated_content_may_be_incorrect
To refine the scenario, we will categorize Product Aspect as the primary level, with Product Category as the secondary level. Please expand the Color ‘Black’ to review the sales distribution for each Product Category within this Color:
A_screenshot_of_a_computer_AI-generated_content_may_be_incorrect
Switching Product Aspect to Class will expand the matrix for all classes due to the data split by Product Category. Without the ‘Black’ value (since Color is removed), we can't keep that specific item expanded, so we default to expanding the whole field selected by the Product Aspect parameter to maintain detail.
A_screenshot_of_a_computer_AI-generated_content_may_be_incorrect
To collapse everything up to Class, utilize the Drill up button located in the visual header:
A_screenshot_of_a_computer_AI-generated_content_may_be_incorrect
With this latest addition to field parameters, they are now generally available. To learn more about field parameters, refer to the documentation.
A_screenshot_of_a_computer_AI-generated_content_may_be_incorrect
A_screenshot_of_a_computer_AI-generated_content_may_be_incorrect
When a theme is uploaded, it is disabled by default; administrators have the option to enable it.
A_screenshot_of_a_computer_AI-generated_content_may_be_incorrect
Enabling a theme in the Admin Portal makes it available in the theme gallery for report creators to use in both Power BI Desktop and the Power BI Service. Previously, this gallery was only accessible on Desktop, but with the introduction of Organizational Themes, it is now available across both platforms—ensuring a consistent and branded experience no matter where reports are created.
A_screenshot_of_a_computer_AI-generated_content_may_be_incorrect
A_screenshot_of_a_computer_AI-generated_content_may_be_incorrect
A key feature is the Copilot toggle, which allows admins to designate a theme as the default for Copilot-generated reports. When enabled, Copilot will apply the selected theme to the first page of any new report it creates, ensuring AI-generated content is on-brand from the start. Report creators can still override this by selecting a different theme from the theme gallery.
A_screenshot_of_a_computer_AI-generated_content_may_be_incorrect
As a bonus, the theme previously used exclusively by Copilot is now available to all users. It appears at the end of the theme gallery list, allowing anyone to apply its clean, modern style—even when building reports manually. Themes with the ‘Default theme Copilot’ toggle enabled can work in copilot without being enabled for the gallery.
A_screenshot_of_a_computer_AI-generated_content_may_be_incorrect
Organizational themes can be configured by administrators only. Report creators have access to the themes provided to them, but only administrators can define, manage, and publish these themes centrally through the Admin Portal.
To learn more about Organizational Themes, refer to the blog post on the Power BI Core Visual channel.
The format pane includes a 'Slices' section where report creators can adjust slice colors, transparency, and borders. Users can apply settings to all slices or target individual series using the ‘Apply settings to’ dropdown. Selecting a specific series allows you to adjust both color and transparency; selecting 'All' limits you to adjusting transparency only.
A_screenshot_of_a_computer_AI-generated_content_may_be_incorrect
Additionally, users can now modify the inner border width of slices and even hide inner borders entirely mirroring the clean look available in stacked bar and column charts.
A_screenshot_of_a_computer_AI-generated_content_may_be_incorrect
These updates not only enhance visual polish but also improve accessibility and design consistency.
To dive deeper into this feature and stay up to date with the latest developments, be sure to check out our dedicated blog post on the Power BI Core Visual channel.
A_screenshot_of_a_computer_AI-generated_content_may_be_incorrect
You can now view and navigate to the Fabric data source selected from the OneLake catalog during the creation of the Direct Lake model. This will open in your web browser so you can validate the data you need there, then return to Power BI Desktop to continue creating the semantic model.
A_screenshot_of_a_survey_AI-generated_content_may_be_incorrect
Once the semantic model is created, you can open it in the web to create reports or explorations or go to File. Then Blank report to open a new instance of Power BI Desktop to create a report using the model you just created.
To learn more, refer to the Direct Lake in Power BI Desktop (preview) documentation.
A_screenshot_of_a_computer_AI-generated_content_may_be_incorrect
To learn more, refer to the DAX query view documentation.
For additional information about supported on-premises data sources, refer to the Service Gateway Data Sources documentation. Details on connecting paginated reports to data sources with PQO are available in the Connect paginated reports to data sources using Power Query in Power BI Report Builder documentation.
For example, when comparing the ODBC implementation (1.0) to the new ADBC implementation (2.0) using the NYC Taxi and Limousine green dataset, the load time improvements were measured as:
A_screenshot_of_a_computer_screen_AI-generated_content_may_be_incorrect._Picture
We greatly appreciate your trial and feedback on this connector since the preview in January 2025. Along with this GA release, we’ve upgraded the connector with the following improvement:
To learn more, refer to the Snowflake connector documentation.
To access this feature, in Power BI Desktop, navigate to Options and settings (under the File Menu) > Options > Preview features, click the checkbox to enable the Use new Google BigQuery connector implementation option. Once the option is on, all the newly created connections will automatically use the new connector implementation.
Power_BI_July_2025_Feature_Summary
Your existing connections remain unchanged. You can also test the new feature by editing the queries. Learn more about the Google BigQuery (Microsoft Entra ID) connector from Google BigQuery (Microsoft Entra ID) documentation.
We highly value your feedback on this feature and encourage you to share the feedback with us.
Learn more about this feature, including the configuration instructions, from the Azure Databricks connector and Databricks connector documentation.
To access this feature, in Power BI Desktop, navigate to Options and settings (under the File Menu) > Options > Preview features, click the checkbox to enable the Use user-installed Netezza ODBC driver option.
Power_BI_July_2025_Feature_Summary
More details about this feature, including the driver installation and configuration instructions, can be found in the IBM Netezza database documentation.
A_screenshot_of_a_computer_AI-generated_content_may_be_incorrect
A_screenshot_of_a_phone_AI-generated_content_may_be_incorrect
With this update, we addressed the final set of limitations in PBIR, including:
Overview
This custom Power BI visual from JTA - The Data Scientists seamlessly blends the clarity of a traditional bar chart with the flexibility of a stacked bar, enabling an insightful view of multiple metrics in a single, cohesive display.
Each category features two bars:
Key Features:
Resources
Key Features:
Business Use Cases:
Sales Performance Tracking, Project Milestone Monitoring, Financial KPI Analysis,
A_screenshot_of_a_computer_AI-generated_content_may_be_incorrect
Bring your geographic data to life with Shape Map PRO! With this Power BI certified custom visual, you can create slick and easy-to-explore map charts for the most interactive reports. In addition to providing quick and actionable insights, the map chart will also seamlessly integrate with other visuals as an interactive filter for the entire report – for example, click on a country to filter data in other visuals.
Key features:
A_screenshot_of_a_cellphone_AI-generated_content_may_be_incorrect
A_screenshot_of_a_cell_phone_AI-generated_content_may_be_incorrect
Unlike matrix visuals that primarily pivot numerical data, Inforiver Table shines in displaying categorical data with rich formatting & Excel-like control. Built for business users, it supports rich formatting, inline edits, and custom calculations — no DAX or coding required.
Key Highlights:
Built for Wide & Long Tables
A_screenshot_of_a_computer_AI-generated_content_may_be_incorrect
A_screenshot_of_a_computer_AI-generated_content_may_be_incorrect
Inforiver Analytics+ addresses key gaps in Power BI by introducing 50+ chart types that are unavailable natively.
Latest Updates:
A_screenshot_of_a_computer_AI-generated_content_may_be_incorrect
A_screenshot_of_a_graph_AI-generated_content_may_be_incorrect
We hope the information provided in this update is useful. 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_AI-generated_content_may_be_incorrect
You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.