WiseOwl Training - Established 1992 Wise Owl Training

Established May 1992
30 years in business Wise Owl Training
30 years in business
See 529 reviews for our classroom and online training
This page has 0 threads   |  Add post
Five star reviews Outstanding course feedback
Average score 9.39/10, based on our 1,777 latest reviews
If you found this blog useful and you’d like to say thanks you can click here to make a contribution. Thanks for looking at our blogs!

BLOGS BY TOPIC▼

BLOGS BY AUTHOR▼

BLOGS BY YEAR▼

The most important changes made for the May 2017 Power BI Desktop update
Part seven 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
  5. New Binning Options
  6. Data labels in combination charts
  7. Combining Files - Option to Choose First File (this blog)

For a cumulative list of all of the updates to Power BI Desktop since November 2016 see this blog, or have a look at the Power BI courses that we run.

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.

Combining Files - Option to Choose First File

Since November of last year, you've been able to combine files having the same format.  For example, suppose that you have three files containing people in different departments:

Production department

One of the three workbooks (Production.xlsx).

 

You want to combine these together to get a single list of all of the rows in the three workbooks:

Combined data

The final query should combine 3 workbooks into one.

As a refresher, you can do this by choosing the following menu option:

Importing from folder

Choose to get data from a file, and then choose the Folder option.

You can then choose two or more files, and combine them:

Combining 3 files

Here we're combining 3 Excel workbooks.

You can now choose to use the first file as a template:

First file option

This option is new!

What this means is that you can combine the files in a folder together, without having to worry about whether the one you chose as a template has been deleted.

  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
  5. New Binning Options
  6. Data labels in combination charts
  7. Combining Files - Option to Choose First File (this blog)
This blog has 0 threads Add post