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...

The rest of the story...
Microsoft News