3 new reasons to love Power Query!


Here they are:

  • Performance improvements
  • Microsoft Dynamics CRM Online connector
  • New transformations

Get the deets:

http://blogs.office.com/2015/03/05/3-updates-excel-power-query/

 

Performance improvements

We’ve made significant Performance improvements to Power Query in a couple of areas:

  • Query load—Performance of loading queries has improved by about 2x-3x in this release, according to our benchmarks. Queries that used to take ~10 minutes before this update, now only take between 3-4 minutes. We encourage you to try your own scenarios and let us know if you’re hitting these Performance levels.
  • Excel workbook import—We’ve improved latency when connecting to Excel workbooks from Power Query. You should see lower times to load previews, which translates into a more responsive experience in the Query Editor.

 

New transformations

These transformations were already possible via custom formulas, but now have been made much more usable.

  • Age and Subtract operations for Date/Time columns—When working with Date/Time columns, it’s often useful to calculate difference between two Date/Time columns (for example, order date add ship date) or to calculate the Age or Date/Time difference between a given date and “now.” These options are now available in the Date and Time menus, under the Transform and Add Column ribbon tabs.

 

  • Aggregate Columns: Option to disable column name prefix—The option to disable column name prefix has been expanded to the Aggregate Columns menu. (This option was added a few months ago to Expand Columns.)  With this option, users can decide upfront whether to include a name prefix based on the original column name to the Aggregate Columns output.

 

 

 

Enjoy!

   - Ninja Ed

Comments (1)

  1. Computers Today (part 1 of 6)

    blogs.msdn.com/…/computers-today.aspx

    …..

    CS SPOTLIGHT: Girls in computer programming… why it matters!!!

    blogs.msdn.com/…/cs-spotlight-girls-in-computer-programming-why-it-matters.aspx

    Computational Thinking – Videos & Papers by Jeannette Wing

    blogs.msdn.com/…/computational-thinking-videos-amp-papers-by-jeannette-wing.aspx

Skip to main content