October 2016 updates for the Power Query add-in includes Query Parameters support

Home » Office » Office 365

Reading time icon 1 min. read

Calendar icon Published on

by Pradeep Viswav 

published on

Share this article

Readers help support MSpoweruser. We may get a commission if you buy through our links. Tooltip Icon

Read our disclosure page to find out how can you help MSPoweruser sustain the editorial team Read more

october-2016-updates-for-get-transform

Microsoft yesterday announce three new data transformation and connectivity features in the Power Query for Excel add-in. Following are the new features added.

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

With the Query Parameters support, you can now create and manage parameters for their queries within the Excel workbook. With the improved Web Connector, they are 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. Starting with this update, users can decide whether to apply Merge/Append operation 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).

Read more about it here.

Pradeep Viswav

Pradeep Viswav Shield

Software and Services Expert

Pradeep is a Computer Science and Engineering Graduate. He was also a Microsoft Student Partner. He is currently working in a leading IT company.

User forum

0 messages