Wednesday, November 22, 2017
Home Office 365 Power BI Power BI Desktop April Update announced by Microsoft

Power BI Desktop April Update announced by Microsoft

545
0

Power BI Desktop April Update announced by Microsoft. They have added preview support for Spanish language for Q&A. They are previewing a major update to the Quick Calcs experience with the new Quick measures. You can also find updates for both data connectivity and query editing, including allowing you to connect to datasets on the Power BI service, so you can create your model just once and use it in multiple reports.

 The complete list of April updates:

Report view

  • Rename axis titles
  • New matrix visual enhancements: column sorting, column resizing, and word wrapping (preview)

Analytics

  • Quick measures and show value as (preview)
  • Q&A in Spanish (preview)

Data connectivity

  • Connect to datasets in the Power BI service (preview)
  • Redshift Connector: beta support & publish to Power BI service
  • SAP HANA & BW Connectors: enhancements to parameter input experience

Query editing

  • Add column by example
  • Split column (by delimiter/number of characters) into rows
  • Group by – basic mode
  • Go to column

For a summary of the major updates, you can watch the following video:

Report view

Rename axis titles

If your field names aren’t the most business user friendly, or your chart layout needs more explanation, you can now rename your axis titles to anything you want. This option is with the other title options under the axis card in the formatting pane.

clip_image004Find more information about axis title renaming in the following video:

New matrix visual enhancements: column sorting, column resizing, and word wrapping (preview)

You can sort the matrix now by the grand total and row headers ascending or descending, just as you could with the original matrix.

clip_image005We’ve also added the resize functionality we had in the original matrix to the preview. Just hover over the area between the two columns and your cursor will change to indicate you can click and drag to resize.

clip_image006Finally, you can now word wrap column headers, row headers and values in the matrix preview. Each one can be turned on in the formatting pane under the corresponding card: column headers, row headers, and values.

clip_image008


We’ve heard lots of great feedback from the survey we launched last month and have plans to bring many of the features you requested to the matrix in the near future. For example, we are working on:

  • Updating the table visual to support cross highlighting
  • Adding control over visibility of individual subtotals
  • Supporting URL icons

Find more details the updates to the matrix preview in the following video:

Analytics

Quick measures and show value as preview

Once you turn the preview on by selecting Quick measures under File > Options and settings > Preview features, you’ll see two new options for numerical columns and measures: Show value as and Quick measures. These options will replace the previous Quick Calcs option in the field menu.

Show value as is a quick way to change the way your values appear in a chart or table. These correspond to what was previously in the Quick Calcs dialog. Since you no longer need to open a dialog, it is now very quick to update how your values show in any given chart.

clip_image010Using quick measures is a very fast way to create new measures based on measures and numerical columns in your table. This means you can now deliver expert level calculations with no DAX knowledge. These new measures are now part of your model and can be used in any of your charts. This means you can use them as a great learning tool or as a starting place for more advanced calculations since the auto-generated DAX is available to you.

You can create measures based on 19 different calculations across 5 different categories:

Aggregate within category

These calculations let you apply different aggregates at different levels in your data. For example, you could sum revenue up to the month level and then take an average of that total to display at the year level.

Filters and baselines

These calculations allow you to calculate values for a specific category in a column, or compare values to a specific baseline. For example, you could calculate your sales for just a specific category of your products.

Time intelligence

If you need a measure that shows period-to-date or period-over-period values, the time intelligence calculations let you do this. DAX has many built-in functions that these quick measures make simple to use.

Running total

This calculation is similar to the YTD calculation, but lets you apply a running total over any field, not just dates.

Mathematical operations

These calculations run simple mathematical functions, which can become powerful when chained together.

You can create a quick measure by selecting Quick measures from the field menu, either in the field well of a chart or from the field list.

clip_image012In the dialog, you can pick any of the 19 different calculations to perform on the selected measure. Depending on the calculation, you’ll have different required parameters you’ll need to fill in. You can also change the fields being used in the calculation using the field list on the right half of the dialog.

clip_image014After you fill in all the required parameters and click OK, the quick measure is now part of your model and available to use in your other visuals. It’ll also be added to your existing visual if you launched it from the Field Well of a visual.

Find more details about quick measures in the following video:

Q&A in Spanish (preview)

The first step to using Q&A in Spanish is to mark the language of your model as Spanish. To do this, you first must turn on the preview feature by checking Spanish language support for Power BI Q&A under File > Options and settings > Preview features.




Once the feature is on, you’ll find a Language option in the Modeling tab of the Relationship view.

clip_image015Once your model language is set to Spanish, you can now publish this report to the Power BI service and be able to ask any question you want in Spanish!

clip_image017For example, I can now ask Q&A for the countries and number of medals they won in the Rome ’60 Olympics in Spanish and get the result back!

clip_image019Learn more about the Spanish Q&A preview in the following video:

Data connectivity

Connect to datasets in the Power BI service

This feature is great when you are part of a team and you all want to work off the exact same model. You can craft your model only once, publish it to the Power BI service to create a dataset, and then everyone can create other Power BI Desktop reports off of it.

You’ll find this new connector under Get Data > Online Services > Power BI service.

clip_image021You will see a list of all the workgroups you are a part of. Expand one and you’ll see all the datasets that you have edit access to. This includes any datasets in your workspace and datasets in shared workspaces.

clip_image023Select a dataset and you will be live connected to that model in the cloud. You can now create a new report and publish it up to the service to share out. Of course, you can always download the file again if you ever need to.

Since this is a live connection, you won’t have permission to do any modeling and cannot join the data with any other sources. To do these type of changes, you will need to make them in the source file and republish to the service for other reports to consume.

This is a preview feature, so you will need to turn it on in by selecting Power BI Service Live Connection under File > Options and settings > Preview features.

Learn more about connecting to datasets in the Power BI service in the following video:

Redshift Connector: beta support & publish to Power BI service

The Redshift connector can be found under the Database category within the “Get Data” dialog.




clip_image025Redshift-based reports have been supported in the Power BI service since March. Now, we’re also enabling the Publish button in Power BI Desktop, so you can publish your Redshift-based reports directly from Power BI Desktop. Learn more about the Redshift connector in our dedicated blog.

Learn more about the Redshift connector in the following video:

SAP HANA & BW Connectors: enhancements to parameter input experience

We’re improving the Parameter Input UX for SAP HANA & BW connectors in a couple of ways.

Ability to filter down the list of parameters to “only required parameters”

clip_image026

Improvements to the single/multi-selection input controls

We’re moved away from dropdown menus and started using a popup dialog for both single selection and multi selection controls. This new dialog allows you to see both the ID and Caption for each parameter value, as well as search within the list of values by any of these two fields. This should make it easier to provide input values compared to the previous experience that only allowed to input IDs.

clip_image028clip_image030Learn more about the updates to the SAP HANA and BW connectors in the following video:

Query editing

Add column by example

This is an innovative approach to defining query steps within the Query Editor that simplifies the process for beginners as they no longer need to come up with “a strategy” for how to transform or extract data from other columns, or how to define those transformations in the Query Editor.

clip_image032Watch this feature in action in the following video:

Split column (by delimiter/number of characters) into rows

Within the “Split Column By Delimiter” and “Split Column by Number of Characters” transformation dialogs that allows you to specify whether to split into new columns (default behavior) or split into new rows.

This new option can be found under the “Advanced Options” section in these two dialogs.

clip_image034clip_image036Learn more about the update to the Split Column feature in the following video:

Group by – basic mode

You can switch between Basic and Advanced modes within the Group By dialog by selecting the desired option at the top of the dialog.

clip_image038Learn more about the basic mode of the Group by feature in the following video:

Go to column

When working with tables that have a large number of columns, it can be hard to scroll in the Query Editor Preview in order to find the column that you want to apply transformations to.

In this month’s release, we’re adding a new “Go To Column” option within the Home tab in the Query Editor ribbon that allows you to search within the list of columns and select the column that you would like to scroll to and select.

clip_image039Learn more about Go to column in the following video:

 

Pin It on Pinterest

Share This