Happy New Year! Today is our first Desktop update of the year. With this new year, we have a new release cadence as well. Up until this point, we've released our updates at the end of the month, but going forward we'll be releasing earlier in the month. Our first release with this new release cadence has several exciting improvements for tables and matrix and several connector improvements as well. If you'd like to see the features in action instead of reading about them, go ahead and download the file I used in this blog post.

Desktop Download button

Here’s the complete list of January updates:

Report View

Data Connectivity

Query Editing Improvements

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

Report View

Table header word wrap

You can now enable word wrapping on table headers.

clip_image010

Once enabled, word wrapping will happen on any manually-sized column. You’ll be able to resize the columns with word wrapping to get the exact layout you desire.

Word wrapping splits on spaces and on long words with no hyphenation if they can't fit on a single line alone.

clip_image011

More details about table header word wrapping in the following video:

Table & matrix conditional formatting improvement – blank formatting

You can now control how blanks are conditionally formatted on tables and matrices. When you open the conditional formatting dialog, there is a new section, Format blank values, where you can pick the formatting method you want to use for your blank values. You can pick between As zero, Don’t format, and Specific color. If you select Specific color as your formatting method, you’ll be able to specify whatever color you want to use through a color picker.

clip_image001

More details about the conditional formatting format in the following video:

New aggregations for string and dateTime columns

We’ve added new aggregation types for dateTime and string columns, which makes it easier to use strings and dates in matrices and tables and in tooltips.

For dateTime columns, you can change the aggregation to Earliest or Latest in the right click menu of the field in the chart.

clip_image003

This will return the Earliest or Latest date for the given context. This is especially useful if you want to show, for example, the last time a specific product was ordered.

clip_image005

For strings, you can change the aggregation to First or Last in the same menu.

clip_image007

This will return the First or Last string alphabetically for the given context. This is especially useful when you need to show more textual information in a data point’s tooltip.

clip_image009

More details about the new aggregations for string and dateTime fields in the following video:

Phone reports

We are happy to announce the general availability of Power BI phone reports with this month’s release. Not too long ago, we announced the preview of phone reports, and thanks to all the great feedback we got during that time, have made many improvements to both the authoring and exploring experience. Now with the GA of phone reports, everyone can take advantage of this feature. 

More details about phone reports in the following video:

Data Connectivity

Visual Studio Team Services connector

This month we’re adding a new data connector, allowing you to connect and import data from your Visual Studio Team Services accounts.

The new Visual Studio Team Services connector can be found under the Online Services category within the Get data dialog.

clip_image013

The VSTS connector dialog allows you to specify an account name, project name and, optionally, one or more area paths.

clip_image015

After specifying the connection details, you will be taken into the Navigator dialog to select one or multiple tables from the list of available tables in your account.

clip_image017

More details about the Visual Studio Team Services connector in the following video:

Enhanced SQL Server connector – support for SQL Failover option

The SQL Server connector has been improved in this release, adding a new option to enable SQL Server Failover support. This new option can be found under the “Advanced Options” section in the SQL Server connector dialog.

clip_image019

More details about the Visual Studio Team Services connector in the following video:

Query Editing Improvements

New transform: extract values from a nested list

We’re making it easier to extract data values from a column containing nested lists. Before this update, you could expand nested lists within a column in a table, resulting in one new table row for each item within the nested list. Such capability is accessible via the column headers in a List column, or by using the “Expand” ribbon entry point.

In this release, we’re adding a new “Extract values” transform which allows you to extract values from a list into a new Text column, with a delimiter in between these values. This new transformation can be accessed from the column header when a column with nested lists is selected.

clip_image021

After selecting this transformation, you will get prompted to provide a delimiter to use in the new column. You will be able to pick from a list of predefined delimiters or specifying a custom one, which may also include special characters.

clip_image023

This transformation will turn the column with nested lists into a Text column as showed below:

clip_image025

More details about the extract values transformation in the following video:

 

That’s all for this month! We hope that you enjoy this new update and continue sending us valuable feedback about our product. Please don’t forget to vote for other features that you would like to see in the Power BI Desktop in the future.

Desktop Download button