February 2018 update for Get & Transform in Excel 2016 and the Power Query add-in

This post has been republished via RSS; it originally appeared at: Excel Blog articles.

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.

 

AADA.png

 

Guy Hunkin

— Excel Team

REMEMBER: these articles are REPUBLISHED. Your best bet to get a reply is to follow the link at the top of the post to the ORIGINAL post! BUT you're more than welcome to start discussions here:

This site uses Akismet to reduce spam. Learn how your comment data is processed.