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
 Read the full blog post on Power BI

Some links in the article may not be viewable as you are using an AdBlocker. Please add us to your whitelist to enable the website to function properly.

Related
Comments