SharePoint Productivity - Dock 365 Blog

New Feature Alert: Power BI Desktop September 2018

9/18/18 10:00 AM / by Sneha Gopal

Microsoft comes with a new bunch of exciting Power BI Data connectivity and Data preparation updates in the month of September. Without further ado, let’s dive right in.

Data connectivity

PDF file connector (preview)

Catering to the huge demand from the community, Microsoft Power BI releases preview of the PDF Connector.

Steps

  • Enable under Preview features list in the Options dialog
  • Once you enable the feature, restart Power BI Desktop
  • The PDF File connector will appear in the Get Data dialog under File category 

464906b4-fbbb-4753-b5ed-0059760d9315

  • Select the connector and you will be prompted to specify a path to a PDF file
  • After specifying the file, tables will be extracted automatically by Power Query and presented in the Navigator dialog
  • You can easily preview and select the desired table or multiple tables

aca69e1f-3c75-4e4d-a5da-313f475dd78d

 SAP BW connector

This is a new capability added to the SAP BW Connector. It enables you to select additional measure properties when using the SAP BW connector in Import mode. You can now select one or multiple measure properties in the Navigator dialog as shown below.

3861f2ba-a7c0-4d05-8bb0-1ea3cf199994

Dataflows connector (beta)

This feature is released for a limited preview period and available in private preview. Now connect to multiple data sources and use their data in Power BI. The dataflows desktop connector is now a part of Power BI Desktop.

0819ed6c-a7c5-4072-b2bb-8adae4cadbcb

Data preparation

M intellisense (preview)

The new Preview of Intellisense support for the M language is made available in the Advanced Query Editor. Microsoft plans to add the support to the Formula Bar and the Custom Column dialog in the future.

 

Steps

  • Enable the feature under the Preview features tab in the Options dialog and restart Power BI desktop
  • Access Intellisense within the Advanced Editor in the Power Query Editor dialog
  • It includes
  1. syntax coloring
  2. line numbers
  3. function completions
  4.  parameter metadata

d2918aab-6982-4fa5-aae5-e5bff80e2882

Add Column from Examples

With the new update, the Add Column from Examples is improved by adding support for Text Padding transformations. The update will ensure that the right set of transformations are generated based on user-provided samples to go from input columns to desired output.

You can provide fixed width to values within a text column by adding characters at the beginning or the end of the original value

8b324ff6-e38c-4f8c-b27c-c4fd41a27a24

 For more information about Power BI and how our SharePoint Intranet Portal Software can help your business grow, get in touch with us today!

Schedule Demo

 

 

Topics: Power BI

Sneha Gopal

Written by Sneha Gopal

She comes with 4 years of experience in content management and have worked with brands from the US and UK.  An enthusiastic content crafter, she loves travelling and  learning about new Microsoft Technologies.

Follow Us:

Sign Up for SharePoint Tips:

    • Dock 365 Intranet Portal
    • Collaborations_yammer
    • Mobile-Power-BI
    • Dock Modern Home
    Microsoft_Partner_Logo.png
    SharePoint Youtube Channels