New features coming to Power BI this November

New features are coming to Power BI this November. 

In today’s data-driven world, businesses are constantly seeking ways to gain a competitive edge and make informed decisions. This quest for actionable insights has given rise to powerful data visualization tools like Power BI.  

Power BI is a business intelligence and data visualization tool developed by Microsoft. It empowers organizations to transform their raw data into meaningful insights through intuitive and interactive reports, dashboards, and data exploration.  

The Microsoft Power Platform release plan for 2023 release wave 2 announces the latest updates to customers as features prepare for release. This article covers the new features and updates arriving in Power BI this November.

Balance user queries with query scale-out 

Support high user-concurrency workloads for large-scale deployments of semantic models (datasets) in Power BI Premium. Management of query scale-out in Power BI Premium is largely automated for customers. 

  • Query scale-out in Power BI Premium enables user queries to be load-balanced across multiple dataset read replicas in a pool of Power BI Premium nodes. This speeds up query response times for high user-concurrency workloads. 
  • Additionally, dataset refresh operations enjoy increased isolation from the read replicas to protect user queries and improve performance. 
  • Management of query scale-out in Power BI Premium is highly automated compared to other platforms such as Azure Analysis Services. Adding and removing read replicas is performed dynamically based on usage.

Diagram of query scale out architecture.

Create and run DAX queries with Query view in Power BI Desktop 

Professional BI developers can natively write and run DAX queries within Power BI. In the past, they had to rely on third-party tools or APIs. Now, they can use Power BI’s built-in capabilities, making DAX queries development easier and more efficient. These features provide a seamless and productive DAX queries experience.

The DAX query view allows BI developers to create and run DAX queries in Power BI. Using the existing DAX query syntax to quickly query their data model. 

DAX expressions are used to define any measure, calculated column, calculated table, dynamic format string, calculation item, and row level security on a user’s model. But that is not all one can do with DAX. With the DAX EVALUATE keyword, users can also use DAX to create a DAX query. This is much like a SQL query where a user can specify columns and aggregations to return in a result table.

DAX Evaluate statement

Use DAX queries to increase productivity.

This powerful way to interact with your data model will be available in the new DAX query view. Giving users several ways to be as productive as possible with these DAX queries: 

  • Quick queries are accessible in the context menu of Data pane tables, columns, or measures. They provide a head start in creating DAX queries for data preview and summary statistics. With DirectQuery, users can now view sample data without returning to Power Query.
  • Right-click in the Data pane to get the DAX expression of all measures or a specific measure in a DEFINE statement. Use an EVALUATE statement to run it as a DAX query and add any additional columns.
  • When a user modifies the DEFINE measure in the model definition, an option for saving time allows the user to update the model, overwriting the current model definition with their changes. There’s no need for manual copy-pasting.
  • When a user utilizes DEFINE to create a measure not already in the model, they have the option to save time by using “add to model” to incorporate this measure. This eliminates the need to create a new measure and manually copy and paste the DAX expression.
  • If a user’s measure references another measure, they can define the measure and all the references. This means all the measures DAX expressions are visible on one screen. User can now see the full context of how this measure is calculated from the source columns.
  • Performance Analyzer already lets users copy the visual DAX query. Users no longer need to take that DAX query and use another tool to view and run it. They can simply run the visual DAX query in Power BI.

Explore single visuals with quick create. 

Users can now explore their data in a dedicated exploration mode. 

  • In this new dedicated exploration mode, users will explore a single visual and use AI in Power BI to find hidden insights in their data. The new mode will be available in report visual focus mode. 

As we explore Power BI’s latest enhancements, it’s clear that Microsoft actively strives to offer businesses cutting-edge tools for data visualization and analysis. These updates promise to make Power BI an indispensable tool for businesses seeking to extract valuable insights from their data. We are excited to take advantage of the new features coming to Power BI this November and unlock the full potential of data-driven decision-making. 

For further information on Power BI. Don’t hesitate to get in touch with allonline365 at +27 (21) 205 3650, email us at contact@allonline365.com or visit our website www.allonline365.com     

New Filter Experience for Power BI Reports

Announcing the New Filter Experience for Power BI Reports

The wait is over!

Power BI has announced that the new filter experience is now generally available. We have updated the look and feel and added a ton of new functionality.

Let’s walk through what’s included in the new filter experience.

Pop-up Filter List

With the new filter experience, report consumers can hover over the filter icon in the visual header to see and read-only list of all the filters or slicers affecting that visual. This makes it super easy for end-users to understand what filters are applied to a visual.

Here are the types of filters this view shows:

  • Basic filters
  • Slicers
  • Cross-highlighting
  • Cross-filtering
  • Advanced filters
  • Top N filters
  • Relative Date filters
  • Sync-slicers
  • Include/Exclude filters
  • Filters passed through a URL

Format and Theme

Report creators now have control over the look and feel of the filter pane. The goal here is to make your filter pane feel cohesive with your report.

You can also modify the default formatting of the filter pane with a JSON theme file.

Lock and Hide Filters

You can now lock filters so that report consumers can see that those filters are applied but they cannot modify them.

Additionally, you can hide filters from your report consumers. Hiding filter cards is typically useful if you need to hide data cleanup filters that exclude nulls/blanks or unexpected values. Hidden filters don’t show up in the filter pane nor the filter dialog for a visual.

Sort Filters

Report creators can custom sort their filters in the new filter pane. This is helpful if you want certain filters to be pushed to the top or if you want certain filters to be next to each other.

new filter experience

You can also choose to alphabetically sort the filters.

new filter experience

Rename Filters

You can double-click on the filter car titles to change the display name so that they are more user-friendly for your report consumers.

new filter experience

When you update the display name, it also gets updated in the filter dialog.

new filter experience

Capture Filter State in Bookmarks

With the new filter pane, you can capture the visibility and expanded or collapsed state of the filter pane in your bookmarks. This is useful when you want to customize how the filter pane fits into your data story:

  • Hide the pane when you don’t need it.
  • Collapse the pane when you need more horizontal real estate for your canvas.
  • Keep the pane visible and expanded when you want users to interact with it.

new filter experience

Learn more about Power BI capabilities and get in touch with allonline365 if you are ready to transform your reporting. Contact us on  info@allonline365.com or  +27 (21) 205 3650.

www.allonline365.com 

Resource Credit | Power BI

xxx

Power BI Service Mobile feature Summary

Read on for a summary of the announcements we made both in the service and mobile.

  • Shared and certified datasets (Preview)
  • AI metrics in the Premium Capacity Metrics app
  • June update for on-premises data gateway
  • General availability of Power BI template apps
  • General availability of Paginated Reports in Power BI
  • Bring Your Own Key (BYOK)
  • Viewer role for the new Power BI workspaces experience
  • Updates to Power BI mobile apps
  • Roadmap updates

Shared and certified datasets (Preview)

We kicked off June by announcing a public preview of shared certified datasets. With this feature, you can now use a single dataset to build multiple reports across different workspaces. That’s right – dataset owners only need to maintain a single copy of their datasets in their own separate workspace and provide permissions for report authors to use those datasets to build reports. To help users to discover relevant and shared datasets, we released a new discovery experience in the Power BI service and Desktop to make it easier for you to browse and find content. Lastly, as part of this work, we also added new capabilities for dataset owners and tenant administrators to control the use of shared data. Learn more.

AI metrics in the Premium Capacity Metrics app

We released a new version of the Power BI Capacity Metrics app to include new AI metrics that provide details on the health of your AI workloads within your capacity. The latest version (1.10.1.7) of the app also has an AI summary dashboard to show you a seven-day summary of all the capacities that you are an admin for. Check it out for yourself by installing the app or learn more about the latest update here.

June update for on-premises gateway

We also updated the Power BI On-premises data gateway for the month of June. Version 3000.6.204 has a new mashup engine, performance profiling based on gateway CPU, SAP Common Crypto library support for SAP BW Application Server Kerberos based SSO, and other small tweaks to keep your datasets up to date. Learn more about the updates in our release blog.

General Availability of Power BI template apps

In February, we announced a public preview of template apps. These apps are integrated packages of pre-built Power BI dashboards and reports, configured to connect to specific data sources. With them, Microsoft partners can quickly access analytics for the apps and services they provide. Partners can also manage the template apps development lifecycle, from development to marketplace to updates. In June, we made template apps generally available by iterating on the feature based on people’s feedback.

Power BI mobile

General availability of Paginated Reports in Power BI

We also announced the general availability of paginated reports. Based on the technology used in SQL Server Reporting Services, paginated reports bring a new set of enterprise reporting capabilities to the Power BI service. It enables developers and BI professionals to create and distribute highly formatted, pixel-perfect reports right alongside their interactive Power BI content, becoming the first cloud BI solution that combines the power of self-service BI with the needs and capabilities of traditional Enterprise BI scenarios.

Power BI mobile

Bring Your Own Key (BYOK) for Power BI Premium (Preview)

Power BI encrypts data at rest for all customers. However, for organizations requiring additional control over how their data is encrypted, we announced Bring Your Own Key (BYOK). This feature allows organizations to configure Power BI to use their own keys, stored in Azure Key Vaults, for data-at-rest encryption instead of Microsoft managed keys. BYOK encryption applies to Power BI Premium capacities only, and organizations can choose to associate different capacities with different keys and/or different key vaults.

Viewer role for the new Power BI workspace experience

We super-charged the new workspaces experience in Power BI by introducing viewer role. Now you can grant read-only access to users within workspaces. The viewer’s role requires a Pro license or for the content to be in Power  BI Premium. If your workspace is in Premium, users with a viewer role who don’t have a Pro license can view the workspace in the workspaces list, navigate to the workspace, and view the content without getting a Pro Trial prompt.

Power BI mobile

Updates to the Power BI mobile apps

There were multiple updates that went out in June for mobile apps on various platforms. Heres a quick summary:

  • Barcode scanning in Android – We updated the Power BI mobile app on Android (phone and tablet) to scan barcodes printed on products or shelves at your store to display related Power BI reports filtered by the scanned value. More about filtering your data with barcodes.
  • Support for PBIX reports hosted in PBI-RS over ADFS configuration (iOS & Android) – We added support for Power BI reports (PBIX) hosted in PBI-RS over ADFS configuration in iOS and Android apps
  • Siri shortcuts support (iOS) – We updated the iOS Power BI app to allow users to create Siri shortcuts to their Power BI reports and dashboards, that can be accessed via voice later.
  • Device-level search (iOS) – We added the ability for you to search for Power BI content within iPhones and iPads that matches the search criteria.
  • Protect Power BI with device Biometric ID – We doubled down security by providing iOS app users (or admins) with the ability to configure the Power BI app to require Face ID, Touch ID, or passcode to view their data. Learn more.
  • Slideshow (Windows app) – Lastly, we added support for an auto-refresh for single-page reports in a slideshow. If the underline data source of your report is updated, we will pick it up and update the data on your slide automatically.

Roadmap updates

We use the Power BI section in the Business Application Release Notes to share details on what’s coming in the next three to six months.  These release notes are updated weekly with details on shipping dates, screenshots, and new announcements. Here’s what we disclosed recently:

  • A new experience for report consumption
  • New Microsoft Flow actions
  • Entity detection and OCR
  • Data lineage capabilities

www.allonline365.com

Resource Credit | Microsoft Power BI

Call Now Button