• Home
  • About Us
  • Contact Us
  • Privacy Policy
  • Special Offers
Business Intelligence Info
  • Business Intelligence
    • BI News and Info
    • Big Data
    • Mobile and Cloud
    • Self-Service BI
  • CRM
    • CRM News and Info
    • InfusionSoft
    • Microsoft Dynamics CRM
    • NetSuite
    • OnContact
    • Salesforce
    • Workbooks
  • Data Mining
    • Pentaho
    • Sisense
    • Tableau
    • TIBCO Spotfire
  • Data Warehousing
    • DWH News and Info
    • IBM DB2
    • Microsoft SQL Server
    • Oracle
    • Teradata
  • Predictive Analytics
    • FICO
    • KNIME
    • Mathematica
    • Matlab
    • Minitab
    • RapidMiner
    • Revolution
    • SAP
    • SAS/SPSS
  • Humor

Power BI Desktop June Feature Summary

June 12, 2018   Self-Service BI

This month our reporting features focus on accessibility and more flexibility when formatting your charts. With filtering and sorting options, our data view is now more powerful. Several connectors also get major updates this month, including a new driver for our SAP Business Warehouse connector that comes with numerous significant improvements.

5d7f8edd 60a2 45e6 8cd8 5a7fa35e97b5 Power BI Desktop June Feature Summary

Here’s the complete list of June updates:

Reporting

Custom visuals

Modeling

Data connectivity

Other

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

Before jumping into the details, don’t forget to register for the Microsoft Business Applications Summit! Don’t miss the event to connect, collaborate, and pack in as much Power BI learning as possible, July 22-24 in Seattle.

REGISTER NOW

88735efc 4c16 4585 9ddb dc8d38b189d4 Power BI Desktop June Feature Summary

There are going to be many great Power BI sessions and tons of chances to interact directly with the Power BI team.

If you're using the high contrast mode Windows settings, your Power BI reports will now respect the color palette you're using. When using Power BI Desktop, we'll automatically detect which high contrast theme you're using and apply those colors across your report, similar to the experience you're used to with other Microsoft products, such as Excel.

fef38944 029c 43c1 a761 f830c29743d2 Power BI Desktop June Feature Summary

In the Power BI service, we'll also try to detect which theme you're using and automatically apply it to your report, but depending on what browser you are using, we may not be able to. If you want to change the theme manually, you can select a high contrast theme under the View dropdown.

60831d05 2646 43ff a916 9e3decf1512b Power BI Desktop June Feature Summary

Note that if you're using high contrast themes on Power BI Desktop, you’ll still see some areas of the product that aren't using your theme’s colors. We’ll be adding more support for high contrast, along with other accessibility improvements, throughout the rest of this year.

Watch the following video to learn more about high contrast reports:

Our first formatting update for the month is the ability to control the inner radius of your donut chart. This lets you make the donut slimmer or thicker to get the style you want. You’ll find this option under the Shapes card in the formatting pane.

d3d7778c d873 4531 aa9d 1208421ba07a Power BI Desktop June Feature Summary

This month we're also updating our pie and donut charts to support moving your detail labels inside. You can pick between forcing the labels to always be outside or inside or to prefer one position over the other.

c174d27f 039a 4e8e 9db8 e35680721ae6 Power BI Desktop June Feature Summary

If you choose to move your labels inside the pie or donut chart, you can also choose whether the text can overflow past the edge of the shape and if the labels have a background or not.

f655c131 7386 4717 ad3f 2d075d34311a Power BI Desktop June Feature Summary

Watch the following video to learn more about the pie and donut improvements:

Our last formatting improvement this month is an update to data labels in combo charts. Now you can customize individual series. In the Data labels card of the formatting pane, you can turn the Customize series option on to format an individual measure’s formatting options, such as color, display units, and the number of decimal points.

ec789a29 5e4a 454a b3d9 376d4db7d873 Power BI Desktop June Feature Summary

Watch the following video to learn more about the combo chart label update:

We've also extended the total length of phone reports this month. If you create custom layouts for your reports to be used in our mobile apps, you'll see that the grid is twice as long as before, jumping from 20 rows to 40.

Watch the following video to learn more about phone reports:

The Organization Chart custom visual lets you create a tree view of your data. You can give each node a name, an image, and optionally a link to go to when clicked. The tree is created by giving each node an id and its parent’s id, and the visual will use this to create the tree layout. There are several formatting options as well, such as node colors, orientation, and label formatting.

c09eefe8 9c5c 46cc b079 84723fa544a5 Power BI Desktop June Feature Summary

Download this custom visual on AppSource.

Watch the following video to see the Organization Chart custom visual in action:

Last month, we had the China Color Map custom visual, and this month we have the China Heat Map visual as a follow up. If you are using geographical data for China, you might want to try out the Chinese Heat map custom visual. This map has several features:

  • Offline maps
  • One-click switching between a national China map and provincial maps
  • Rich visual formatting
  • Arbitrarily set the latitude and longitude of the area you want to display
  • Custom gradient range fill

2253dfa6 d5ee 4651 9ff1 a9f17af37679 Power BI Desktop June Feature Summary

Check out this custom visual on AppSource.

Watch the following video to see the China Heat Map custom visual in action:

We are very excited to announce the addition of filtering and sorting in the data view. For every column in your model, you can now see the sort direction if it is applied on that column and either filter individual values out or using advanced filtering options for that column type.

fcaf3a07 999a 4dd2 963f 8816db287c7e Power BI Desktop June Feature Summary

Watch the following video to see data view filtering and sorting in action:

We are vastly increasing the number of specific locales we support for formatting when viewing your reports in the Power BI service. With this update we are adding support for a total of 670 locales. For example, you’ll now see support for Mexico’s variant of Spanish along with many other Spanish variants. In Desktop, we detect and use the "date, time, and number formatting" format set for the operating system. IE and Edge will pass this same OS locale through, but other browsers often have their own, separate, language and region settings.

28f19702 afbd 4470 a238 ff8735ab2f84 Power BI Desktop June Feature Summary

Make sure to use the default data format for your field if you want the the system locale settings to flow through. You can tell you are using system locale formatting by the * next to the format.

New driver and improved performance

Starting with this month’s release, the SAP BW connector supports a new implementation option labeled 2.0. Selecting implementation “2.0” in the SAP BW connector dialog while creating a new connection will switch from using the SapClient driver to a new SAP BW driver developed by Microsoft.

These are significant connector improvements that come with the new implementation:

  • Improved performance
  • Ability to retrieve several million rows of data, and fine tuning through the batch size parameter
  • Ability to switch execution modes
  • Support for compressed mode, which is especially beneficial for high-latency connections or large datasets
  • Improved detection of Date variables
  • [Experimental] Expose Date (ABAP type DATS) and Time (ABAP type TIMS) dimensions as dates and times respectively, instead of text values.
  • Better exception handling, so errors that occur in SAP BAPI calls are now surfaced.
  • Column folding in BasXml and BasXmlGzip modes. For example, if the generated MDX query retrieves 40 columns but the current selection only needs 10, this request will be passed onto the server to retrieve a smaller dataset.

Implementation 2.0 has a new pre-requisite, the SAP .NET Connector 3.0. Download of the connector is available from SAP’s website. Access to this download requires a valid SAP S-user. You are encouraged to contact your SAP Basis team to get this component.

The connector comes in 32-bit and 64-bit versions, and you must choose the version that matches your Power BI installation. At the time of this writing, the website lists two versions (for .NET 4.0 framework):

  • SAP Connector for Microsoft .NET 3.0.20.0 for Windows 32bit (x86) as zip file (6.896 KB), January 16, 2018
  • SAP Connector for Microsoft .NET 3.0.20.0 for Windows 64bit (x64) as zip file (7.180 KB), January 16, 2018

While installing, in the “Optional setup steps” window, make sure to select the “Install assemblies to GAC” option:

d9fd21ec b078 48ba 9de4 dfc928a5ee41 Power BI Desktop June Feature Summary

After installing the required component, you must create a new connection to use the new implementation.

  1. From the Get Data dialog, select either SAP Business Warehouse Application Server or SAP Business Warehouse Message Server.
  2. You will be presented with the new connection dialog, that allows selection of the Implementation. Selecting Implementation 2.0 will enable the Execution mode, Batch size and Enable characteristic structures options.
    sapbw Power BI Desktop June Feature Summary
  3. Upon clicking OK, you will be taken to the Navigator dialog, from which the experience is the same as before.

You can learn more about this new implementation of the SAP BW connector by reading the following article: https://docs.microsoft.com/en-us/power-bi/desktop-sap-bw-connector

Improved support for hierarchy variables

We have made improvements to the hierarchy variables input UX in the Navigator dialog and Edit Variables screen, so that when modifying selection for a hierarchy node variable (i.e. US State), dependent variable values fields (i.e. City) are updated to only contain values defined within the selected hierarchy node.

We’re enhancing the Spark connector this month by adding support for Windows authentication. Upon specifying a server to connect to, you can now provide Windows authentication credentials in addition to the previous Basic (username/password) option.

Windows authentication support allows you to specify “current” or “alternate” user credentials. Additionally, you can specify the Realm, Host Fully-Qualified Domain Name and Service Name parameters, which are required in order to establish the connection to Spark clusters.

dbfa6f52 dca5 4b98 a078 14ebc49f65c4 Power BI Desktop June Feature Summary

This month we’ve made significant improvements to our OData connector in order to provide richer support for OData V4.

  • Improved support for complex types: The new experience for complex-typed properties is now much like that for navigation properties. Complex singleton properties can now themselves contain navigation properties, and complex collections are now imported as nested tables.

  • Open type navigation columns: While the existing OData connector has long supported importing extra data properties from an OData feed as open type columns, the enhanced connector extends this to also importing extra navigation properties, whether dynamic or from a derived type. In many cases we will still be able to fold even after following these navigation properties.

  • Improved support for custom URLs: Users who prefer to specify OData query options manually will find that the enhanced connector adjusts the type of the imported table according to the response.

  • Significant performance improvements: Loading feeds with many navigation properties has been massively sped up.

  • Greater resiliency: If for any reason a folded query fails, the enhanced connector will retry with less folding. This allows more queries to succeed without completely giving up on the improved performance from folding.

The ODBC connector has been improved this month in a couple of ways:

Folding support for Top Rows

With this month’s release, “keep top rows” operations will be pushed down to the ODBC driver, which may improve performance of the connector if the driver and underlying data source support the “top” operator.

Ability to filter navigation by DSN catalog

If the DSN or connection string specified in the ODBC connector dialog includes a DSN catalog, Power Query will narrow down the list of tables exposed in the Navigator dialog accordingly.

Power BI is currently available in three separate national clouds, which offer the same levels of security, privacy, compliance and transparency as the global version of Power BI, combined with a unique model for local regulations on service delivery, data residency, access, and control. If your account happens to be provisioned in more than one cloud, you can now choose the cloud you want to use when signing into Power BI Desktop.

That’s all for this month! We hope that you enjoy these updates and continue sending us your feedback. Please don’t forget to vote for other features that you’d like to see in the Power BI Desktop. You can also download the .pbix file I used, and if you’re looking for a similar design for your reports, I was using the Sunset layout from PowerBI.Tips.

5d7f8edd 60a2 45e6 8cd8 5a7fa35e97b5 Power BI Desktop June Feature Summary

Finally, remember to register for the Microsoft Business Applications Summit! Don’t miss the event to connect, collaborate, and pack in as much Power BI learning as possible, July 22-24 in Seattle.

REGISTER NOW

48513568 e5e5 495a 86b1 c5a6145d64f7 Power BI Desktop June Feature Summary

I’m excited to meet many of you there!

Let’s block ads! (Why?)

Microsoft Power BI Blog | Microsoft Power BI

Desktop, feature, June, Power, summary
  • Recent Posts

    • NOW, THIS IS WHAT I CALL AVANTE-GARDE!
    • Why the open banking movement is gaining momentum (VB Live)
    • OUR MAGNIFICENT UNIVERSE
    • What to Avoid When Creating an Intranet
    • Is Your Business Ready for the New Generation of Analytics?
  • Categories

  • Archives

    • January 2021
    • December 2020
    • November 2020
    • October 2020
    • September 2020
    • August 2020
    • July 2020
    • June 2020
    • May 2020
    • April 2020
    • March 2020
    • February 2020
    • January 2020
    • December 2019
    • November 2019
    • October 2019
    • September 2019
    • August 2019
    • July 2019
    • June 2019
    • May 2019
    • April 2019
    • March 2019
    • February 2019
    • January 2019
    • December 2018
    • November 2018
    • October 2018
    • September 2018
    • August 2018
    • July 2018
    • June 2018
    • May 2018
    • April 2018
    • March 2018
    • February 2018
    • January 2018
    • December 2017
    • November 2017
    • October 2017
    • September 2017
    • August 2017
    • July 2017
    • June 2017
    • May 2017
    • April 2017
    • March 2017
    • February 2017
    • January 2017
    • December 2016
    • November 2016
    • October 2016
    • September 2016
    • August 2016
    • July 2016
    • June 2016
    • May 2016
    • April 2016
    • March 2016
    • February 2016
    • January 2016
    • December 2015
    • November 2015
    • October 2015
    • September 2015
    • August 2015
    • July 2015
    • June 2015
    • May 2015
    • April 2015
    • March 2015
    • February 2015
    • January 2015
    • December 2014
    • November 2014
© 2021 Business Intelligence Info
Power BI Training | G Com Solutions Limited