Microsoft Power BI | November 2017 Updates

Categories: Data & AI Product Updates
Tags: Microsoft Microsoft Power BI
CLO17_casualOffice_002-min

We report below on the November 2017 updates for Microsoft Power BI Desktop, with the most recent version of Power BI now available for businesses to download or to purchase from the Windows Store.

Table and Matrix visuals

With rule-based conditional formatting, rules can be defined to determine colour backgrounds and column font colours. The addition of a cell alignment control to row and column headers and specific fields in Field formatting, enables elements to be aligned to the left, to the right or to the centre.

Selection pane visual

The selection pane, launched last month, was introduced to simplify the process for selecting objects on the report page, and November has seen a visual ordering feature added. This feature enables users to designate the overlapping objects to display at the top, with arrows appearing in the pane or a drag and drop function used to order priorities.

Locking objects

To prevent unintentional layout editing during report analysis, Microsoft has introduced the facility to temporarily disable Resize and Move and lock objects within the report.

Cell-level formatting

Multi-dimensional Analysis Services (AS) cell-level formatting will now flow and activate automatically, with analytics support enhanced to include multi-row cards.

Impala and Windows Authentication

Support for Windows Authentication to the Impala connector has been added during November, with the result that users can use Windows as authentication in Credentials. Comparable support for the on-premises data gateway and Kerberos-based Single Sign-On support for Impala is expected next month. 

Add Column from Example

With the Add Columns From Examples feature in query editing, users can now define ‘conditional columns’, with the ability to create a basic conditional column (determined by examples), conditional column ranges, and – more specialised – with cases such as ‘null fallback’ or ‘bucketing’.

Other updates

Enhancements have been announced to the Power BI filtering process, and the custom visual store has been updated with a number of new custom visuals. Following the introduction of Esri's ArcGIS Maps for Power BI in June, a further subscription has been introduced by Esri – Plus – to give users better mapping capabilities. And finally, we report that new options have been created, to reduce queries when dealing with uncommonly large or slow data sources in DirectQuery.

Related Articles

The reseller ‘Not For Profit’ opportunity - webinar with Vuzion and Microsof...

To help resellers explore the not-for-profit opportunity open to them with Microsoft products, we’re hosting a webinar on 28 April, ...

The benefits of using Vuzion’s billing services

It's more important now than ever for partners to integrate and automate as much of their business and its processes as possible.

Vuzion Cloud Awards 2021 - what a great awards night!

Thank you to all our award sponsors, presenters and everyone who attended and helped make the evening such a great success.

Vuzion Awards 2021 - shortlist announced!

The judges have all reported on the high standard of the award entries, and what an honour it has been to read through so many inspi...