1. Join Date : Oct 2013
    Posts : 16,469
    64-bit Windows 10 Pro build 14971
       27 Oct 2016 #1

    October 2016 updates for Get & Transform in Excel 2016 & Power Query


    Excel 2016 includes a powerful new set of features based on the 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 three new data transformation and connectivity features that have been requested by many customers.

    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 and transformation features:

    • Query Parameters support.
    • Improved Web connector—web page previews.
    • Query Editor improvements—option to Merge/Append as new query.

    Query Parameters support

    With this update, users can now create and manage parameters for their queries within the Excel workbook. The new “Manage Parameters” dialog is available on the ribbon under the Home tab within the Query Editor.



    The new dialog allows the users to create new parameters, give them a meaningful Name and Description, specify the information about the expected parameter type and values, default value and current value.



    Once one or more parameters are available in the current workbook, users can reference those parameters in their queries via Query Editor. Referencing parameters is supported via the Data Source dialogs, Filter Rows, Keep Rows (top/bottom, etc.), Remove Rows (top/bottom, etc.), Replace Values, Add Conditional Columns dialog and more.

    In addition, parameters can be loaded to the grid or to the Data Model just like any other query, allowing references from Excel formulas or DAX measures.



    The in-depth tutorial on query parameters will be coming on the Excel blogs portal soon. Stay tuned.

    Improved Web connector—web page previews

    One of the most unique Get & Transform connectors is the Web connector. With the Web connector, users can easily import data from websites that has been formatted as an HTML table or even pull data from Web APIs.

    When using the Web connector for “scrapping” data from HTML pages, a very common challenge is that the Navigator view, which is based on a list of tables, is not very helpful in identifying the desired tables. This is particularly hard when dealing with web pages that contain lots of tables, and in many cases, with not very representative table names.



    With this update, we’re introducing a new mode in the Navigator dialog that allows users to preview tables on the web pages “in context” and select the desired tables by just clicking on them within the Web View preview. This results in a much more intuitive and seamless user experience for selecting tables from a web page.



    To access this mode, click the Web View button at the top of the Navigator dialog. Users can also switch back to the classic data-centric view by selecting the Table View option.

    Query Editor improvement—option to Merge/Append as new query

    Within the Query Editor, users can easily merge (join) or append (union) multiple tables, allowing them to mash up data from multiple sources into a single table. The Merge/Append operations are on the ribbon under the Home tab inside Query Editor.



    In previous versions of the Query Editor, Merge/Append operations were always applied as new steps within the current query. Starting with this update, users can decide whether to apply these operations as a new step in the current query (old behavior) or whether the output of the Merge/Append operation should be created as a new query (new behavior).



    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


    Source: October 2016 updates for Get Transform in Excel 2016 and the Power Query add-in - Office Blogs


    Last edited by Brink; 27 Oct 2016 at 14:21.
      My System SpecsSystem Spec


  2. Join Date : Jun 2015
    Posts : 402
    Windows 10 Pro 64bit; Windows 10 TP
       27 Oct 2016 #2

    Hey Brink, I am using the "standalone" version of Office 2016 Professional Plus and I do not have this feature in my Excel. Am I not supposed to get it? Or should I activate some Add-on in the Options?

    Thanks!
      My System SpecsSystem Spec


  3. Join Date : Oct 2013
    Posts : 16,469
    64-bit Windows 10 Pro build 14971
       27 Oct 2016 #3

    Hello Joanne,

    These updates are available as part of an Office 365 subscription.
      My System SpecsSystem Spec


  4. Join Date : Jun 2015
    Posts : 402
    Windows 10 Pro 64bit; Windows 10 TP
       27 Oct 2016 #4

    Ah, okay, I see, thank you Brink

    It's just that I've read that people with Office 2013 and even 2010 can get this, and I thought it would be available for us, as well.

    Thanks anyway
      My System SpecsSystem Spec


  5. Join Date : Oct 2013
    Posts : 16,469
    64-bit Windows 10 Pro build 14971
       27 Oct 2016 #5

    Maybe one day hopefully soon.
      My System SpecsSystem Spec


  6. Join Date : Jul 2015
    Posts : 1,051
    Windows 10 Pro (64 bit)
       27 Oct 2016 #6

    I checked for updates on my 365 and it says already upto date. Nothing new coming through, is the latest public build still 16.0.7369.2038
      My System SpecsSystem Spec


 


Similar Threads
Thread Forum
Microsoft Security Bulletin(s) for October 11 2016
Microsoft Security Bulletin(s) for October 11 2016 Note: There may be latency issues due to replication, if the page does not display keep refreshing Today Microsoft released the following Security Bulletin(s). Note:...
Windows Updates and Activation
Office September 2016 updates: Get & Transform in Excel 2016 and Power Query
Source: September 2016 updates for Get Transform in Excel 2016 and the Power Query add-in - Office Blogs
Windows 10 News
Xbox Xbox Live Games With Gold For October 2016
Source: Xbox Live Games With Gold For October 2016 | Major Nelson
Windows 10 News
New feature updates for Power Pivot in Excel 2016
Source: New feature updates for Power Pivot in Excel 2016 - Office Blogs
Windows 10 News
Jump Lists Not working for Word 2016 or Excel 2016
so jump lists via my taskbar and windows 10, I'm not having much joy :-( I've just got a new desktop (Jan 2016) with windows 10 pre-loaded and I installed office 2010 - jump lists didn't work - so I thought I'll uninstall and install office 2016...
Software and Apps
Our Sites
Site Links
About Us
Windows 10 Forums is an independent web site and has not been authorized, sponsored, or otherwise approved by Microsoft Corporation. "Windows 10" and related materials are trademarks of Microsoft Corp.

© Designer Media Ltd

All times are GMT -5. The time now is 15:42.
Find Us
Twitter Facebook Google+



Windows 10 Forums