Summary of Power BI Update - May 2023

00:00:00 - 00:25:00

The May 2023 Power BI update introduces the OneLake data hub, which replaces the Power BI data hub, adds the Microsoft Fabric free user license, a new Fabric category for data sources, and new Fabric connectors. Additionally, the Azure Maps visual is now available with customizable options. Users can define query limits in desktop to match the limits found in the service, improving consistency across platforms. Power BI also introduces data loss prevention policies, including Social Security numbers auto-detection, user notifications, and custom policy tips. Users can now edit the data model directly within the browser, and there are new features for developers, such as enhanced custom visuals with keyboard navigation and the ability to detect filtered report state.

• 00:00:00 In this section, Ryan Majidimehr introduces the OneLake data hub, which replaces the Power BI data hub and supports all Fabric data items. The OneLake data hub allows users to easily locate data items across multiple workspaces using the Explorer tool and is accessible on the Power BI service, Power BI Desktop, and in all Fabric workloads. Additionally, the lineage view now supports all Fabric items, showing how data flows from source to destination across all items. Other updates include the Microsoft Fabric free user license, a new Fabric category for data sources, and new Fabric connectors. Finally, the Azure Maps visual is now generally available with customizable options and a pop-up encouraging users to upgrade.
• 00:05:00 In this section, Ryan discusses the updates to map visuals in Power BI, including the new Azure Maps visual that will replace the Bing Map and use the same base map style. The rollout will happen over time and will affect all reports, including existing ones. Users are encouraged to give feedback if any issues arise. The upcoming improvements will include fully deprecating old maps and replacing them with Azure Maps, among other features. Other updates in the May release include measured driven data labels, New, Open, Save, and Share options for OneDrive and SharePoint document libraries, matrix accessibility improvements, and updates to the on-object interaction feature. Lastly, a new feature allows authors to define query limits in desktop to match the limits found in the service, improving consistency across different platforms.
• 00:10:00 In this section, Ryan from Power BI addresses an issue that users have encountered which involves visuals working on Power BI Desktop but then encountering errors when published and shared. To minimize the confusion, the company has introduced query limits to desktop, allowing users to choose a capacity whose limits they want to simulate in desktop. Additionally, there are updates to the Power BI tabs in Microsoft Teams, new DAX function called MATCHBY, and they have released four new connectors such as the MongoDB Atlas connector and the SolarWinds Service Desk connector. For connector updates, Anaplan has included backend changes for compatibility with ongoing infrastructure updates.
• 00:15:00 In this section, we learn about various updates and enhancements made to Power BI, including AssembleViews, Autodesk Construction Cloud, Azure Databricks, BitSight Security Rating, BQE Core, Eduframe Reporting, and funnel connectors. One significant update is the introduction of data loss prevention policies, allowing users to automatically detect sensitive information upon upload to Power BI. Microsoft Purview compliance provides different options to set customized advanced DLP rules, including Social Security numbers auto-detection, user notifications, and custom policy tips. In addition, the update includes data model editing in the Power BI service as an opt-in preview feature.
• 00:20:00 In this section, Emily, a sales analyst, demonstrates the new modeling on the web capabilities, which allows users to edit the data model directly within the browser. This feature saves time for model authors and is especially helpful for Mac users who can now avoid the hassle of running parallels or partitioning their hard drive. Emily creates a new measure, tests it, and then creates a new role level security role to ensure the confidentiality of the sales data. The paginated reports also have accessibility enhancements, such as headings in report textbox properties and column row headers in tablet properties. Drill-through reports have also been added to paginator reports in the Power BI service.
• 00:25:00 In this section, we learn about the latest Power BI updates, including on-premises drill-through capabilities, changes to Power BI paginated reports consumption, and new features for developers, such as enhanced custom visuals with keyboard navigation and the ability to detect filtered report state. The video also highlights new editor's picks and updated visuals available on AppSource. The audience is encouraged to share their feedback and favorite features in the comments section.