Microsoft Power Query For Excel Gets Big Update
2 min. read
Published on
Share this article
Improve this guide
Readers help support MSpoweruser. We may get a commission if you buy through our links.
Read our disclosure page to find out how can you help MSPoweruser sustain the editorial team Read more
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
