Most RecentMost ViewedMost LikesGet & Transform (Power Query) in Excel for Mac - Phase 1 You can now refresh Power Query queries on Mac from Text, CSV, XLSX, XML and JSON files, and author queries with VBA. Excel and Power BI: connected features coming soon for users with Power BI free licenses Connected PivotTables and Organization data types in Premium Capacity coming soon for users with Power BI free licenses July 2018 update for Get & Transform in Excel 2016 and the Power Query add-in Announcing Column From Examples enhancements, Always Use Connection File support for queries, and additional improvements to ODBC, OLEDB, OData and SAP HANA connectors. — Read on for more details Modernized Data Import and Shaping Experience Today, we are pleased to announce the next major update to data import and shaping functionality in Excel. Now it is easier than ever to import, combine and refine your data to meet your analysis needs. ─Read on for details. February 2018 update for Get & Transform in Excel 2016 and the Power Query add-in Announcing Azure Active Directory Authentication support for Azure SQL Database and Azure SQL Data Warehouse connectors. — Read on for more details
