Get certified for free when you join Fabric Data Days 2026 and dive into Fabric, Power BI, SQL, AI, and other essential data skills.
Join nowData Days is here! Join us now for 60+ days of learning, challenges, and connection. Learn more
Welcome to the Power BI May 2023 update!
We have lots of exciting new features for you this month. With the announcement of Microsoft Fabric, you'll find a featured section on all of the new features released! See Arun Ulagaratchagan’s blog post to read the full Microsoft Fabric Preview announcement.
You'll also find the preview announcement of new Open, Save, and Share options when working with files in OneDrive and SharePoint document libraries, updates to the On-Object Interaction feature released to Preview in March, a new feature that gives authors the ability to define query limits in Desktop, data model editing in the Power BI Service, and updates to the Power BI Tabs in Microsoft Teams.
There is more to explore in Reporting, Modeling, Data Connectivity, Service, Paginated Reports, Developers, visualizations, and other announcements so please continue to read on!
Fabric is taking a bold bet on open data formats in OneLake. In addition to avoiding vendor lock-in, One Copy of data shared across the Fabric analytical engines means customers will dramatically reduce data silos and data integration costs. Power BI is adopting Delta Lake and Parquet its native storage format. By querying data directly from the lake, Power BI datasets enjoy blazing fast query performance on a par with Import storage mode without having to duplicate data or manage refreshes!
Until now, dataset creators had to choose between Import and DirectQuery mode for data access. Import mode delivers blazing-fast performance but Power BI must first copy the data during refresh. Any changes at the source are only picked up with the next data refresh. DirectQuery mode avoids having to copy data, but typically suffers performance degradation by having to submit federated queries to other database systems that are not as efficient for BI-style queries. Direct Lake mode combines the advantages of Import mode and DirectQuery: query performance on a par with Import without having to copy data or manage refreshes.
Power_BI_May_2023_Feature_Summary
Direct Lake is a fast path to query data directly from the lake for your Lakehouse/Warehouse. The data volumes for Direct Lake mode far exceed the per-dataset memory limits for Import models in Power BI Premium Gen2. Building near real-time BI solutions to unlock massive data has never been easier. Just go to your Lakehouse or Warehouse in Fabric, click on the New Power BI Dataset button, select the tables you want to include, and click Confirm. Open the data model to create measures and relationships as you would for any other Power BI dataset. Lastly click the new report button and create beautiful Power BI reports! Note the integrated experience from data in the lake through to report creation without leaving the browser or performing a refresh!
Power_BI_May_2023_Feature_Summary
Don’t miss this opportunity to take your BI solutions to the next level with Direct Lake mode for Power BI datasets in Fabric. Check out the articles in the product documentation for a quick start. Direct Lake mode opens a fundamental new way for analyzing very large data volumes in Power BI. Try it now!! Provide us with feedback! And stay tuned for more announcements related to Direct Lake mode in the coming months!
While the migration of production solutions requires careful preparation, the actual steps to migrate from AAS to Power BI couldn’t be more convenient. Just launch the Azure AS Migration Experience as in the following animated illustration, create a new migration, connect to your Azure subscription, select the AAS server and database that you want to migrate, connect to your workspace on Power BI Premium or create a new one, select the desired ADLS Gen 2 storage account, and you are off to the races. You can monitor the migration progress and status while the migration experience performs the actual work for you.
Power_BI_May_2023_Feature_Summary
The ability to redirect XMLA-based clients and rebind Power BI reports to the migrated dataset is perhaps one of the most compelling reasons to use the Migration Experience for your Azure AS migrations. The above animation already shows you how to redirect XMLA-based clients with a single mouse click. Equally convenient, you can redirect all the Power BI reports that use a migrated dataset from within the migration experience. As the following screenshot illustrates, you can also verify the rebind status of your reports and revert the rebinding if you wanted to redirect your reports back to the original dataset on Azure AS. Perhaps you only wanted to evaluate the migration experience using a temporary target workspace first before launching the actual migration effort in your production environment.
Power_BI_May_2023_Feature_Summary
After the actual migration is complete, your users can continue to use their existing reports without disruption. You can also access your migrated dataset by using any tool or application that supports XMLA protocol. You can also create reports and dashboards using Power BI Desktop or Service. And you can now take your datasets to the next level by leveraging the numerous exciting features and unique capabilities that Power BI has to offer, including:
Here are some quick links you may find useful:
Power_BI_May_2023_Feature_Summary
Pause visuals can stop visuals from sending queries when you are making changes. This can speed up your report design process, especially if you are using DirectQuery table storage mode. You can refresh individual visuals or all the visuals on a report page when you are ready.
Optimization presets lets you apply different report setting combinations to favor either Query Reduction or Interactivity between your visuals with one click. You can even use the Customize option to pick and choose which settings best suits your reporting needs. Optimization presets are particularly useful for large models and DirectQuery reports that require fine-tuning of performance and user experience.
Apply all slicers button stops slicers from instantly applying their selections when this button is added to a report page. This will reduce the number of times the other visuals refresh while report consumers are making selections across multiple slicers.
Try these features out today!
To learn more about the Optimize ribbon and how to use these features, check out the documentation:
Power_BI_May_2023_Feature_Summary
We hope you are as excited as we are about Hybrid Tables in Power BI Premium. With Hybrid Tables, you can analyze massive datasets with billions of rows interactively, while keeping up with the latest changes in your data source seamlessly. Of course, you can also create a reverse partitioning scheme with less frequently analyzed historic data in DirectQuery mode while providing the more frequently analyzed recent data in import mode for blazing fast analysis. Stay tuned for more optimizations to come in the future targeting specifically this historic partitioning scenario. To learn more about Hybrid Tables, check out the Hybrid Tables content in the product documentation. You can also read more about the benefits and scenarios of Hybrid Tables in our previous preview announcement. Happy analyzing!
However, until now this feature was limited to a single workspace per log analytics workspace. In other words, you could not connect multiple Power BI workspaces to a single log analytics workspace. This meant you had to create a new log analytics workspace for each Power BI workspace or selectively decide which workspace you wanted to analyze. With this announcement, we have lifted the limitation and customers can now connect multiple workspaces to a single log analytics workspace:
Power_BI_May_2023_Feature_Summary
With this added capability, administrators now can have full and detailed visibility into any Power BI Premium dataset usage, performance, and metrics running in their premium capacities in near real time.
Query Log Analytics with KQL
Using the Log Analytics query interface admins have the possibility to write queries using the powerful Kusto Query Language and get instant results from massive amounts of data. Here’s an example that counts the number of queries, users, CPU Average and Duration Average per workspace:PowerBIDatasetsWorkspace | where TimeGenerated > ago(30d) | where OperationName == “QueryEnd” | summarize QueryCount=count() , Users = dcount(ExecutingUser) , AvgCPU = avg(CpuTimeMs) , AvgDuration = avg(DurationMs) by PowerBIWorkspaceId
Insights with Power BI Template
Admins can also use the previous released Power BI report template to connect to Log Analytics and get historical insights for dataset usage and performance data:Power_BI_May_2023_Feature_Summary
In summary, Log Analytics provides admins with a unique way to:
Automation with REST APIs
With General Availability we will also allow admins to automate the connection of Power BI Workspaces to Log Analytics Workspace using the UpdateGroup Admin REST API, allowing admins to automate creation of the connection to Log Analytics. This is an important capability for large enterprise customers and ISVs who may have to frequently create new workspaces. Refer to this sample PowerShell script to learn how to do it.To learn more about Log Analytics and Power BI, check out our documentation.
We are pleased to announce another major enhancement that addresses customer requests related to the data hub experience. The new OneLake data hub Explorer enables users to quickly and easily locate the right data items while browsing through the list of workspaces where they have data items inside. The OneLake data hub Explorer is particularly powerful for users who have access to data across multiple workspaces, including those with tens or more workspaces. By providing an intuitive and efficient way to browse through and locate data items, the Explorer makes it easier for users to work with large volumes of data and derive valuable insights. In the Explorer pane, users can see all of the workspaces in which they have access to data, and clicking on a workspace name scopes the data to that workspace only.
The OneLake data hub is accessible on Power BI Service, Power BI Desktop, and in all Fabric workloads.
Power_BI_May_2023_Feature_Summary
To help users better understand the long chain of dependencies across workspaces, we are also improving the impact analysis experience. This will allow users to see all downstream items through the chain, in addition to the direct child items.
Overall, these enhancements to the Power BI workspace Lineage view will improve data visibility and management, making it easier for users to work with complex BI projects and ensure that data is flowing smoothly across all items.
Power_BI_May_2023_Feature_Summary
This minor change requires no preparation as all functionalities that the Power BI Free user license previously offered, still remain. The renaming of the license serves only to reflect inclusion within Microsoft Fabric.
The following connectors will appear in the “Fabric” category, in addition to the “Power Platform” category.
Reporting
With this release, you’ll find a couple more changes as we continue to improve the visual.
First, when you open a report with an existing Map visual and Azure Maps is enabled for your organization, you’ll see a window pop up encouraging you to upgrade your Map to an Azure Map.
Power_BI_May_2023_Feature_Summary
As you might have been able to infer since the release of the visual’s public preview, we are focusing our development efforts on Azure Maps as the single first-party map visual in Power BI. In fact, in a future release, we will fully deprecate our older map visuals and migrate even existing reports over to Azure Maps in order to truly unify all of our map visuals into one. However, we encourage you to convert your Maps to Azure Maps now. This will make sure that you get all the new features we ship in the future as soon as we ship them, and that your transition is as seamless as possible.
Second, we’re updating the style of all of our map tiles, including in the Azure Maps visual.
| Current Style | New Style |
Since this will affect all reports, including existing reports, we are rolling this change out to users over time, so keep an eye out for the new style in your own reports and send us feedback early if you encounter any issues.
While we’ve reached General Availability, our investment in Azure Maps won’t slow down here! We still have even more features and improvements planned for the visual in the coming releases. Thank you for all of your feedback throughout the preview period, and we look forward to continuing to work with you to make our visuals as powerful as they can be.
Measure driven data labels
This release will introduce an exciting new label capability that allows you to easily swap out your default data labels with more meaningful values based on your chosen field or measure.
Power_BI_Report_Server_May_2023_Feature_Summary
This measure-driven data label feature is just a taste of the great improvements that await you in the coming months. Get ready!
Work seamlessly in Power BI Desktop with files in OneDrive and SharePoint Power_BI_May_2023_Feature_Summary
Many report authors save their Power BI files to OneDrive and SharePoint during report creation. These new capabilities help authors with file versioning, collaborating with other authors, and ensuring they always have a backup of their files in the cloud.
Start by enabling the Preview by checking the Save to OneDrive and SharePoint and Share to OneDrive and SharePoint options in the Options > Preview Features. Note, if you have lots of recent files, there is a bug affecting the performance. This will be fixed next month and we recommend you wait to turn this feature on.
When enabled, the next time you save a new file in Power BI Desktop, you’ll see OneDrive and SharePoint folders you’ve recently used, in addition to the local folders you’ve used recently.
Power_BI_May_2023_Feature_Summary
If you don’t see the folder you need, select the More options… button which opens the new Save As experience that lists the OneDrive and SharePoint locations you have access to, and lets you navigate and create new folders. You can also Browse this device to save to a local folder.
Power_BI_May_2023_Feature_Summary
When you press Save, we’ll upload the file to the location you chose. You can press Upload later to keep working and the file will be uploaded when you close Power BI Desktop.
Power_BI_May_2023_Feature_Summary
Next time you open Power BI Desktop, you’ll be able to open the file directly from OneDrive and SharePoint document libraries. This downloads the file locally. This update does not add any collaborative editing of Power BI files.
Power_BI_May_2023_Feature_Summary
Lastly, when you’re ready to share your work with a colleague, you can click the Share button at the top right-hand corner. If the file is a local file or a new file, you’ll be prompted to save it to OneDrive or SharePoint.
Power_BI_May_2023_Feature_Summary
Then, you’ll be able to use standard SharePoint and OneDrive UI to get a shareable link or send it to the people who need it.
Power_BI_May_2023_Feature_Summary
Sharing through OneDrive and SharePoint is convenient for report authors and small teams. For larger organizations, it’s best to use the Publish option to share through the Power BI Service, where it’s easier to distribute, find, and manage trusted reports.
Power BI admins can turn off the ability to share through OneDrive and SharePoint for users in their organization in Power BI Desktop. Use the Power BI admin portal to disable the Users can share links to Power BI files stored in OneDrive and SharePoint through Power BI Desktop setting.
Power_BI_May_2023_Feature_Summary
When the setting is disabled, the Share button will be disabled for signed-in users. If the user has not signed in, they’ll need to sign in after pressing Share. If the Admin setting is disabled, the share option gets disabled. Users will still have the option to save to their OneDrive for Business or a SharePoint Document library, which many already do today by syncing their local file system with OneDrive or manually uploading files.
A seamless experience for using Power BI with OneDrive and SharePoint
These new open, save, and share experiences work together with our recently announced view in OneDrive and SharePoint experience. To get a fully seamless experience, ask your Power BI Admin to enable the Users can view Power BI items saved in OneDrive and SharePoint (Preview) tenant setting.
Distributing insights in the best way for your organization
Organizations need to build a single source of truth where everyone can find the most authoritative and up-to-date insights. Publishing to the Power BI Service and distributing through the Power BI app are critical elements of this process.
These new OneDrive and SharePoint capabilities complement existing processes by meeting the needs of authors, who often collaborate as a team before publishing official versions of reports through the Power BI Service.
It also helps organizations that are just starting out. They may have just a few people using Power BI who are already familiar with sharing content in OneDrive.
We’re just getting started on our plans for Power BI with OneDrive and SharePoint! We look forward to creating more features that will help you more easily interact with and get insights into your data through Power BI and Office integration experiences.
Matrix accessibility improvements
We are excited to announce several enhancements to the matrix visual for existing and new reports to improve usability and accessibility for all users.These updates include:
Power_BI_Report_Server_May_2023_Feature_Summary
Learn more about consuming Power BI reports using accessibility features.
Power_BI_May_2023_Feature_Summary
Power_BI_May_2023_Feature_Summary
Power_BI_May_2023_Feature_Summary
Set Query Limits in Power BI Desktop
In the Service, depending on where a Power BI report’s data is hosted, there are different limits to the time a query is allowed to run and the amount of memory that query is allowed to use. However, in Power BI Desktop, these limits do not exist. This occasionally causes confusion when a visual that works on Power BI Desktop unexpectedly errors when it is viewed in the Service.To minimize this confusion, we are giving authors the ability to define query limits in Desktop as well. This way, you can match the limits that will be found wherever your data will be hosted in the Service. You can find these new options in the Options > Report settings tab:
Power_BI_May_2023_Feature_Summary
Existing reports will be defaulted to “No query limits” to match previous behavior, but new reports will now have “Auto” limits set by default. With auto limits, Power BI will do its best to identify where the model is hosted, and otherwise default to the Shared Capacity (which tends to be the strictest) for safety.
Power_BI_May_2023_Feature_Summary
You can see the limits being set for each capacity you choose, and you can also set custom limits with the “Custom limits” option. When you set your own limits, you can use “0” to indicate “no limits”.
Power_BI_May_2023_Feature_Summary
When a query limit is reached, you will see a similar error to what you would see in the Service:
Power_BI_May_2023_Feature_Summary
Modeling
New DAX functions: MATCHBY
This month we’re introducing a new DAX function: MATCHBY. When used within any window function, this function defines the columns that are used to determine how to match data and identify the current row.For example, below is a query that returns FactInternetSales with an added column, which indicates, for each sale, the previous sales amount in descending order of sales from the same product. Using MATCHBY, we’re able to indicate that current sales should be identified by the SalesOrderNumber and SalesOrderLineNumber. Without MATCHBY, the query would return an error since there are no key columns in FactInternetSales table.
EVALUATE ADDCOLUMNS ( FactInternetSales, "Previous Sales Amount", SELECTCOLUMNS ( OFFSET ( -1, FactInternetSales, ORDERBY ( FactInternetSales[SalesAmount], DESC ), PARTITIONBY ( FactInternetSales[ProductKey] ), MATCHBY( FactInternetSales[SalesOrderNumber], FactInternetSales[SalesOrderLineNumber] ) ), FactInternetSales[SalesAmount] ) )
This function can only be used within window functions. To learn more about this function, see the documentation page: MATCHBY.
Data Connectivity
On-premises data gateway May 2023 release
We are happy to announce that we have just released the May 2023 update for the on-premises data gateway (version 3000.174.TBD).This update brings the on-premises data gateway up to date with the May 2023 release of Power BI Desktop.
Power_BI_May_2023_Feature_Summary
Power_BI_May_2023_Feature_Summary
This version of the gateway will ensure that the reports that you publish to the Power BI Service and refresh via the gateway will go through the same query execution logic/run-time as in the May version of Power BI Desktop.
Beginning on March 15, 2023, any Power BI dataflow using an on-premises data gateway version older than April 2021 might fail. To ensure your refreshes continue to work correctly, be sure to update your gateway to the latest version. Learn more about our support cycle in our documentation.
Please continue to send us feedback on what new capabilities you’d like to see in the future! You can vote for your favorite feature suggestions at Ideas (powerbi.com).
New Connectors
MongoDB Atlas (New Connector)
We are excited to announce the release of the new MongoDB Atlas connector. Here is the introduction from the MongoDB team:The MongoDB Atlas Power BI Connector allows you to access and analyze application data stored in MongoDB Atlas. Easily connect Power BI Desktop to Atlas and begin querying using SQL without the need for schema definition. Use native Power Query functionality for data transformation, advanced querying, or self-service data modeling. Perform sophisticated analysis across multiple data sources, without disrupting in-production application workloads, by leveraging the built-in federated query engine and workload isolation of Atlas.
Celonis EMS (New Connector)
We are excited to announce the release of the new Celonis EMS connector. Here is the introduction from the Celonis team:The new Celonis EMS connector for Power BI allows you to link Power BI with your Celonis EMS Instance. As a result, you can embed process intelligence produced by the Celonis EMS into Power BI to enhance reporting with insightful process knowledge. This will accelerate business transformation and deliver insights where you need them. All published Knowledge Models are automatically listed by the Celonis EMS connector for Power BI and it is easy to import Records that are defined in the Knowledge Models. To enable the full PQL experience inside Power BI, you will be able to define Records in PQL inside the Knowledge Models and load them into Power BI.
In summary - The Celonis EMS connector for Power BI will allow you to:
CloudBlue PSA (New Connector)
We are excited to announce the release of the new CloudBlue PSA connector. Here is the introduction from the CloudBlue team:CloudBlue PSA is the most complete cloud professional services automation (PSA) software on the market. Purpose-built with functionality to simplify every need of MSPs and professional services organizations, CloudBlue PSA introduces a state-of-the-art PSA system built for today’s modern service provider.
The platform empowers services organizations to scale recurring channel revenue and diminish operational complexity via its advanced product suite, which includes automated billing and reconciliation, an industry-leading customer support center and network operations center (NOC), real-time profitability analysis, and much more. CloudBlue PSA is available globally.
To learn more about CloudBlue PSA, please visit https://www.cloudbluepsa.com/
SolarWinds Service Desk (New Connector)
We are excited to announce the release of the new SolarWinds Service Desk connector. Here is the introduction from the SolarWinds team:SolarWinds Power BI connector allows you to integrate with Power BI to pull data on incidents in the SolarWinds Service desk system and create reporting, analytics, and insights in order to improve.
Wrike (New Connector)
We are excited to announce the release of the new Wrike connector. Here is the introduction from the Wrike team:The Wrike Connector for Microsoft Power BI lets you pull data efficiently from your Wrike account directly into Power BI, making the Wrike data objects available for your reporting purposes. Available data objects include Projects, Tasks, Custom Fields, Finance Fields, Job Role, Bookings, Approvals, Attachments, Contacts, Groups, Timelogs, Workflows etc. You can pull the data, that you have access to in Wrike, in the form of Account Level datasets, Space Level datasets and Project/Folder Level datasets. You can drill down through your Wrike Space/Project/Folder hierarchy in the Wrike Connector and select your required datasets for your preferred Space, Project or Folder. This will let you create focused analytical reports for your target Space/Project/Folder, without the need of manually filtering the data of your entire Wrike account.
Connector Updates
Anaplan (Connector Update)
The Anaplan connector has been updated. Here are the release notes from the Anaplan team:This version of the Power BI connector for Anaplan includes backend changes for compatibility with ongoing Anaplan infrastructure updates. There is no change to user-facing connector features.
AssembleViews (Connector Update)
The AssembleViews connector has been updated. Here are the release notes from the AssembleViews team:This update to the Assemble Views Connector adds the ability to select individual models as well as views for maximum flexibility when pulling data from your Assemble project.
Autodesk Construction Cloud (Connector Update)
The Autodesk Construction Cloud connector has been updated. Here are the release notes from the Autodesk team:Azure Databricks, Databricks (Connector Update)
The Azure Databricks and Databricks connectors have been updated. Here are the release notes from the Databricks team:BitSight Security Ratings (Connector Update)
The BitSight Security Ratings connector has been updated. Here are the release notes from the BitSight team:BQE Core (Connector Update)
The BQE Core connector has been updated. Here are the release notes from the BQE team:Update API endpoint to retrieve Contact, using /Contact instead of /Crm/Contact.
Eduframe Reporting (Connector Update)
The Eduframe Reporting connector has been updated. Here are the release notes from the Drieam team:Funnel (Connector Update)
The Funnel connector has been updated. Here is the changelog from the Funnel team:Updated labels and help texts to be more in line with the Funnel app.
Service
Data loss prevention (DLP) policies is now GA!Power_BI_November_2023_Feature_Summary
Classify and protect your Power BI data:
While organizations are taking more measures to properly classify sensitive information and install processes on how to interact with sensitive information, much of their business-critical data is still in the dark. This is precisely where the power of DLP policies comes into play: with DLP you can automatically detect sensitive information as it is uploaded to Power BI, and by thus uncover data that may have been accidentally uploaded into the wrong workspace, for instance.Security admins can set alerts to be automatically generated when sensitive information is found in datasets. They can provide customized messages to users and help guide them on how to interact with sensitive data, such as what steps they should take. For example, whenever proprietary information is detected, show Power BI users a message explaining that this information is internal and should not be shared externally. DLP is audited in the Microsoft Purview Compliance Portal, where security admins can also monitor their policies and refine them based on feedback from users, such as reported false positives.
By using DLP policies in Power BI, you strengthen your security posture and reduce the risk of sensitive information being uploaded to the cloud without your knowledge.
Learn more about DLP policies for Power BI or play with it yourself using our interactive guide.
Power_BI_May_2023_Feature_Summary
DLP identifies sensitive data within the dataset and shows the user a custom policy tip, defined by the security administrator.
Detect sensitive information using custom keywords:
Some organizations consider certain terms, such as internal project names, as sensitive information that they want to ensure is not exposed outside of the organization. With this update, you will be able to define those unique internal terms as a custom keyword sensitive info type and use it as a trigger for DLP in Power BI. Learn more about creating keyword dictionary SITs.
Power_BI_May_2023_Feature_Summary
Create a custom SIT of the Keyword Dictionary type to be used as a policy condition and trigger an alert
Complex conditions in DLP for Power BI:
Complex conditions enable security admins to create advanced rules using a combination of AND/OR/NOT operators. With a new and improved flow, you can configure granular and flexible rules that utilize a combination of conditions. A common scenario is locating sensitive data where it is not properly labeled according to the organization’s guidelines. In this case, you could also use the custom policy tip text to encourage users to set the correct label.
Power_BI_May_2023_Feature_Summary
Define a complex condition: dataset contains credit card numbers and is labeled as general, OR it contains bank account numbers but is not labeled as confidential.
DLP policies in national clouds:
All of the capabilities above have been extended to include national clouds: US Government: GCC, GCC High, DoD; China: China East.
For many years, Power BI Desktop users have been able to configure and modify aspects of their data models in the model view. However, these model view capabilities have been specific to Desktop with no additional data model support in Service. Now, we are introducing data model editing in the Service, allowing Service users a first step towards modifying their existing data models on the web. In this preview, you can modify your existing data models on the web through actions such as editing relationships, creating DAX measures, and managing RLS. We will continue to regularly release updates to this experience with the eventual goal of parity in modeling capabilities offered in the Service.
Power_BI_May_2023_Feature_Summary
We invite you to try it out for yourself. This feature is automatically turned on for datasets stored in My Workspace. To try this experience in a collaborative workspace, please turn on the workspace level Preview switch under workspace settings:
Power_BI_May_2023_Feature_Summary
Power_BI_May_2023_Feature_Summary
If you have any feedback, please share it in our feedback forum.
For more details on the feature, read Edit your data model in the Power BI Service | Public Preview (Opt-in).
New Power BI Tab configuration experiences in Microsoft Teams
We’re excited to announce updates to the Power BI Tabs in Microsoft Teams. These updates help you create tabs faster, allow you to use links to configure tabs, and help you save default filters in your tabs.When you add a Power BI Tab in Teams, you’ll see our new simplified tab UI. Just press Save to add the tab.
Power_BI_May_2023_Feature_Summary
When the tab loads, you’re greeted with a new landing page where you can paste a link. You can also browse workspaces to select content. If you’re new to Power BI, you can even click through to create a report.
Power_BI_May_2023_Feature_Summary
You can paste links to interactive and paginated reports, scorecards, and organizational apps.
Many kinds of links are supported, these include:
Links with include my changes open new possibilities for collaboration
The same report is often used by multiple teams, channels, and in many meetings. However, in each of these locations, the report needs to be filtered to meet the unique needs of each team working with the report. By using links that include my changes, you can customize the report, so it opens on the most relevant content for the collaboration context you use.
We’re excited to share these updates and to learn how you use them. Head over to https://ideas.powerbi.com to share your thoughts on how we can improve these experiences.
Paginated Reports
Drill through in paginated reports:
Today, we are happy to announce drillthrough reports have now been added to paginated reports in Power BI Service! That means we now support on-premises drillthrough capabilities in the Service.A drill through report is a report that a user opens by clicking a link within another paginated report. Drill through reports commonly contain details about an item that is contained in an original summary report. For example, in this illustration, the sales summary report lists sales orders and totals. When a user clicks an order number in the summary list, another report opens that contains details about the order.
Power_BI_May_2023_Feature_Summary
A drillthrough report can be used to validate summarized data. It can also be used to provide granularity within another report, allowing the consumer to digest the details in a separate report instead of crowding the main report with too many data details.
You can add a drillthrough link to any item that has an Action property, such as a text box, an image, or data points on a chart within the Power BI Report Builder authoring tool. By right-clicking on the desired data point, you will see the dialog box containing the Action property. Drillthrough is the radio button option “Go to report”. You will need to specify the target or drillthrough report name and the parameters associated with the detailed report.
Drill through has been a favorite feature for on-premises customers for many years. We are now providing a means for our customers to utilize drill through for their paginated report needs. To learn more about drill through reports, please review this article. Please don’t forget to update your version of Power BI Report Builder to take advantage of drill action. If you want to keep the conversation going, please leave a comment below. To learn more about new capabilities and features join our user panel. As always, we look forward to hearing from you!
Changes to Power BI paginated reports consumption of Power BI Premium capacity
In response to your feedback with respect to ease of understanding and managing the Power BI Premium capacity resource consumption of paginated reports, we have made changes to how the paginated report workload uses Power BI capacity and how it is reported. We provided advance notice of this change:See Paginated reports capacity planning for Power BI Premium - Power BI | Microsoft Learn for guidance.
We’re also introducing a new diagnostic view available to all users with edit permissions for the report that provides diagnostic performance metrics to help you understand how the report execution relates to Premium capacity consumption.
Power_BI_May_2023_Feature_Summary
Developers
Enhance your custom visuals with Keyboard Navigation
As a developer, you want to create custom visuals that are not only visually stunning but also accessible to everyone, regardless of their physical abilities. That's why we're excited to introduce keyboard navigation. With keyboard navigation, your custom visuals will be easier to use for people with disabilities and will provide more options for interacting with reports.The keyboard navigation feature in Power BI includes the following:
To learn more about how to support keyboard navigation in your custom visuals, please read our documentation on this topic.
Detect filtered report state with custom visuals!
In certain scenarios, it's important for custom visuals to be able to detect whether a report has been filtered. Up until now, custom visuals were unable to determine this state. However, with the release of version 5.4 API, custom visuals can now find out if there are any filters applied to the report.This new feature is made possible through the addition of a Boolean called "isDataFilterApplied" in the DataViewMetadata object. By accessing this property, custom visuals can now easily detect if a filter has been applied to the report and adjust their behavior accordingly.
To learn more about this new feature and how to use it in your custom visuals, please check out our documentation.
Visualizations
Editor's pick of the quarter
Calendar Pro by OKVIZSelection Slicer by Walnut Innovation
Deneb: Declarative Visualization in Power BI
New visuals in AppSource
Multiple Stacked Charts
Hierarchy Chart by MAQ Software
Traqplan Timeline Test Release
Dual Y-Axis Column Chart (Pro)
Clustered Stacked Column Chart (Pro)
Zebra BI Cards 1.6
Zebra BI Cards 1.6 brings several new features that will make your KPI reporting even clearer. Highlight specific cards to attract attention and show multiple Big Annoying Numbers (BANs) for clearer reports. Provide a detailed description of KPIs for faster understanding. Change to the basis points format to track your performance better, plus more!SORT BY DIFFERENT CRITERIA - To help you prioritize KPIs you can now explore the new sorting option for the cards. To improve data visibility, you can organize the cards by variance (relative or absolute), title, or value and sort by plan, previous year, or forecast. Easily see KPIs from different angles, gain clarity on what needs your attention, and act accordingly.
Power_BI_May_2023_Feature_Summary
HIGHLIGHT SPECIFIC KPIs - You can now emphasize specific KPIs that need special attention from your report viewers by highlighting their respective cards. This way the visual message of your dashboard is even stronger and helps you get crucial insights faster.
SHOW MULTIPLE BANs - You can now display multiple BANs on each card. This way you can easily compare them on the spot and get additional insights into the most critical KPIs immediately.
Visit our product update page for more information.
Power_BI_May_2023_Feature_Summary
Create Stunning Pie Charts with Drill Down Pie PRO
Drill Down Pie PRO lets users create visually appealing pie charts for easy data exploration. All interactions take place on the chart using just the mouse, letting users enjoy intuitive interactions that guide the eye. Fully customize the look of your chart with advanced formatting options.
Power_BI_May_2023_Feature_Summary
Main features include:
To get started with Drill Down Pie PRO, get it now from AppSource or learn more in our product page!
Acterys Gantt
Acterys Gantt enables comprehensive project management functionality in Power BI. In addition to extensive Gantt visualization options, the visual also supports planning and write-back for example adding and editing tasks.Features:
Power_BI_May_2023_Feature_Summary
To learn more, watch our YouTube video: Acterys Gantt: Project Planning in Power BI.
Strip Plot by Nova Silva
Most charts will force you to summarize or categorize data before it is displayed. This can hide important details and may be misleading. The Strip Plot shows all your data observations in one go without hiding important details. It shows each data point on a single continuous scale.Your excellent feedback allows us to continuously improve our visuals. Based on your feedback, we just released version 2.3 with several exciting enhancements.
The color formatting of all visible objects can be managed now. This allows you to use the Strip Plot in dark mode or any other preferred color scheme.
Power_BI_May_2023_Feature_Summary
We also applied several changes to significantly improve the loading performance of the Strip Plot. You can now show up to 30,000 markers in a single visual.
And all our visuals continue to support the standard Power BI interface. We incorporate the same user experience as Microsoft in the default visuals. You can use the Strip Plot (and all our other visuals) with the latest features: On-object interaction, Subtitle, Divider, etc.
Don’t hesitate and try the Strip Plot now on your own data by downloading it from AppSource.
Questions or remarks? Visit us at: https://visuals.novasilva.com/.
TMap 2.0
Newly released TMap 2.0 has added 2 types of maps: stacked bar chart map and donut chart map, and smart labeling for the linked polygon layer.Stacked bar chart map can be used to show trends of a group of data across different geographical regions.
Screenshot 1 (Stacked bar chart):
Power_BI_May_2023_Feature_Summary
Labels for polygon layer will be shown or hidden as zoom level changes and adjusted their positions to reduce overlapping with charts.
Screenshot2 (Donut Chart):
Power_BI_May_2023_Feature_Summary
You can go to Microsoft AppSource to download and try it.
To learn more on how to use it, please read tutorials.
Calendar by MAQ Software—updated!
View key events on your Power BI report in a calendar view.We are excited to announce that one of our top visuals, Calendar by MAQ Software, has just been updated with even more features to better serve our users. Easily track events in Power BI and experience the most effective way to visualize and manage events with our enhanced Calendar visual.
Power_BI_May_2023_Feature_Summary
Figure 1: Sample visual showing color-coded events with a tooltip being showcased as well.
Key business uses:
To learn more about our Power BI custom visuals, visit our website.
And that's all for this month! Please continue sending us your feedback, and don't forget to vote for other features you would like to see in Power BI! We hope that you enjoy the update!
A few quick reminders:
If you installed Power BI Desktop from the Microsoft Store, please leave us a review.
Also, don't forget to vote on your favorite feature this month over on our community website.
And as always, keep voting on Ideas to help us determine what to build next.
We look forward to hearing from you soon!
You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.