Today, we released yet another update for Get & Transform — a powerful set of Excel 2016 features based on the Power Query technology, which provides fast, easy data gathering and shaping capabilities.
This update is available as part of an Office 365 subscription. If you are an Office 365 subscriber, find out how to get the latest updates. If you have Excel 2010 or Excel 2013, you can also take advantage of this update by downloading the latest Power Query for Excel add-in.
One of the most frequent requests from customers using the Azure SQL Database and Azure SQL Data Warehouse connectors in Excel has been to leverage Azure Active Directory Authentication in order to connect to Azure services.
With this update, we introduced a new "Microsoft Account" option within the Credentials dialog for the Azure SQL Database and Azure SQL Data Warehouse connectors, allowing users to authenticate using their Azure Active Directory account credentials.
Guy Hunkin
— Excel Team