The most important changes made for the May 2017 Power BI Desktop update
Part four of a seven-part series of blogs

The May 2017 Power BI Update brings in a couple of nice new query transforms and some new chart features, but the big changes are still in preview mode.

  1. Updates in the May 2017 Edition of Power BI Desktop
  2. Support for Different Types of URLs in Tables and Textboxes
  3. New Table and Matrix Visualisations in the Offing
  4. Extracting Text Between Delimiters (this blog)
  5. New Binning Options
  6. Data labels in combination charts
  7. Combining Files - Option to Choose First File

For a cumulative list of all of the updates to Power BI Desktop in the last few months, see this blog.

Posted by Andy Brown on 17 May 2017

You need a minimum screen resolution of about 700 pixels width to see our blogs. This is because they contain diagrams and tables which would not be viewable easily on a mobile phone or small laptop. Please use a larger tablet, notebook or desktop computer, or change your screen resolution settings.

Extracting Text Between Delimiters

This is my favourite feature in the May update, even though it's fairly small.  Suppose you want to import the message encoded in the following file:

The hidden message

You want to extract the text between the # and @ characters.

You import this text file into Power BI Desktop, then go to the Transform menu:

The Transform menu

Choose the Transform tab on the ribbon.

You can now choose to extract the data between delimiters:

Text between delimiters

Choose to extract the text between two delimiters.

 

Choose the delimiters to use:

Start and end delimiters

The delimiters to use for this example.

 
Hidden message revealed

The words between the delimiter spell out a Macronian message.

 

Whether I'll ever use this I don't know, but it's still a nice idea!

This blog has 0 threads Add post