Back
Excel

April 2016 updates for Get & Transform in Excel 2016 and the Power Query add-in

Share on Facebook Share on Twitter Share on Linkedin Share via OneNote Share via Email Print

Excel 2016 includes a powerful new set of features based on Power Query technology, which provides fast, easy data gathering and shaping capabilities and can be accessed through the Get & Transform section on the Data ribbon.

Today, we are pleased to announce two updates to this powerful feature set. These updates are available as part of an Office 365 subscription. If you are an Office 365 subscriber, find out how to get these latest updates. If you have Excel 2010 or Excel 2013, you can also take advantage of these updates by downloading the latest Power Query for Excel add-in.

These updates include the following new or improved Data Connectivity features:

  • ODBC Connector—Support for selecting User/System DSNs
  • CSV Connector—Ability to specify Column Delimiter in the Source dialog

ODBC Connector—Support for selecting User/System DSNs

A common request from customers using the ODBC Connector was being able to select from a list of available DSNs on their machine when specifying the connection details in the Import from ODBC wizard in Power Query in Excel.

With this update, we added a new drop-down menu so users can select an existing DSN from the list of available User/System DSNs on their machine. In addition to selecting an existing DSN, users can specify additional Connection String details or select “None” in the DSN drop-down to specify a full Connection String independently from any existing DSNs (equivalent to the behavior prior to this update).

Get and Transform April 1

CSV Connector—Ability to specify Column Delimiter in the Source dialog

We improved the Source dialog for the CSV Connector so that users can customize the Column Delimiter option. Before this update, the Column Delimiter option could only be modified via editing the underlying M formula for the Source step.

Get and Transform April 2

How do I get started?

Excel 2016 provides a powerful set of capabilities for fast, easy data gathering and shaping, which is available under the Get & Transform section on the Data ribbon. Updates outlined in this blog are available as part of an Office 365 subscription. If you are an Office 365 subscriber, find out how to get these latest updates. If you have Excel 2010 or Excel 2013, you can also take advantage of these updates by downloading the latest Power Query for Excel add-in.

—The Excel team

Top
9 comments
  1. Is my assumption correct that the only way to get the latest version of PQ for Excel 2016 is to have an O365 account? I have Office Pro Plus and I’ve tried updating, but can’t get the latest version

  2. Hi,

    Just to clarify: do you mean that you are running perpetual Office Professional Plus edition?

    Guy
    Excel Team

  3. Hi Guy

    Is this really happening people who are paying $400 a year for Office Professional Plus 2016 does not get any new features? But some kid with a free version of 365 School or somebody with 365 Home paying $5 a month gets the latest features?

    Having been with the MS Office for 20 years and buying a Pro version every time one comes out i feel like I am being shafted.

    I fully understand the web version is easier to update but you guys could still roll out the new features a few months later. I just do not understand why Microsoft is treating its customers this way.

    For me to get the same functionality with 365 Office i have to have the
    Office 365 ProPlus $18 a month.

    You should treat customers who buy the Office Professional Plus 2016 better than somebody who has a basic 365 plan but you do not, it is so wrong and alienates your long-time local customer base.

    Unhappy Customer
    Dale

    • Hi Dale,

      We are delivering the Get & Transform updates both to Office 365 subscribers and to perpetual customers. So you will get these updates for sure. Can you tell me what kind of Office 2016 Professional Plus deployment you have? Is it a click-to-run or MSI deployment? Based on your answer I will be able to tell you when you are supposed to get these updates.

      Regards,
      Guy.
      Excel Team

  4. Can you tell me what version of Office 2016 I have to buy to have Excel 2016 with all updates for Power Pivot and Power Query?

Comments are closed.