Microsoft Power Query For Excel Gets Big Update

Microsoft Power Query for Excel is an Excel add-in that enhances the self-service Business Intelligence experience in Excel by simplifying data discovery, access and collaboration. The Power Query team has added a number of new features to Power Query. You can download the update from this page.

• New Data Sources
  • Updated “Preview” functionality of the SAP BusinessObjects BI Universe connectivity
  • Access tables and named ranges in a workbook
• Improvements to Query Load Settings
  • Customizable Defaults for Load Settings in the Options dialog
  • Automatic suggestion to load a query to the Data Model when it goes beyond the worksheet limit
  • Preserve data in the Data Model when you modify the Load to Worksheet setting of a query that is loaded to the Data Model
• Improvements to Query Refresh behaviors in Excel
  • Preserve Custom Columns, Conditional Formatting and other customizations of worksheet tables
  • Preserve results from a previous query refresh when a new refresh attempt fails
• New Transformations available in the Query Editor
  • Remove bottom rows
  • Fill up
  • New statistic operations in the Insert tab
• Other Usability Improvements
  • Ability to reorder queries in the Workbook Queries pane
  • More discoverable way to cancel a preview refresh in the Query Editor
  • Keyboard support for navigation and rename in the Steps pane
  • Ability to view and copy errors in the Filter Column dropdown menu
  • Remove items directly from the Selection Well in the Navigator
  • Send a Frown for Service errors
• Connect to SAP BusinessObjects BI Universe (Preview)
• Customizable Defaults for Load Settings in the Options dialog
• Preserve Custom Columns, Conditional Formatting and other customizations of worksheet tables
• Preserve results from a previous query refresh when a new refresh attempt fails
• Automatic suggestion to load a query to the Data Model when it goes beyond the worksheet limits
• Preserve data in the Data Model when modifying the Load to Worksheet setting of a query that is loaded to the Data Model
• Remove Bottom Rows
• Fill Up
• New Statistics operations in the Insert tab
• Ability to reorder queries in the Workbook Queries pane
• More discoverable way of cancelling refresh of a preview in the Query Editor
• Keyboard support for navigation and rename in the Steps pane
• Ability to view and copy errors in the Filter Column dropdown menu
• Remove items directly from the Selection Well in the Navigator
• Send a Frown for Service errors