Power Query Updates

Posted on Updated on

from MS:

***************

This month’s Power Query update includes four new or improved features including:

  • Enhanced Privacy levels dialog
  • New Text column filters: “Does Not Begin With…” and “Does Not End With…”
  • Improved Salesforce connectors
  • Improved “Excel Workbook” connector

*****************

Nevertheless the second is most interesting:

*****************

New Text column filters: “Does Not Begin With…” and “Does Not End With…”

We added a couple of new filters for Text columns so you can filter by “Does Not Begin With…” or “Does Not End With…” In previous versions of Power Query, these filters required custom formula editing, but are now much easier to apply by simply selecting them from the Text Filters menu.

Power Query June update 2************

original: http://blogs.office.com/2015/06/04/4-updates-to-power-query/

Advertisements

Leave a Reply

Fill in your details below or click an icon to log in:

WordPress.com Logo

You are commenting using your WordPress.com account. Log Out / Change )

Twitter picture

You are commenting using your Twitter account. Log Out / Change )

Facebook photo

You are commenting using your Facebook account. Log Out / Change )

Google+ photo

You are commenting using your Google+ account. Log Out / Change )

Connecting to %s