Forum Discussion

Brass Contributor

Nov 08, 2016

What's The Different Between "Get & Transform" and Power Query"?

are they only different in terminology and basically since o2016 its changed name as "Get & Transform"?

Microsoft

Nov 21, 2016

And you can read more about Get & Transform in Excel 2016 here: https://support.office.com/en-us/article/Get-Transform-in-Excel-2016-881c63c6-37c5-4ca2-b616-59e18d75b4de?ui=en-US&rs=en-US&ad=US What we did in Excel 2016 is that we integrated the Power Query technology natively into Excel. The new powerful data import, mashup and transform capabilities are now fully available under Get & Transform section on the Data tab of the ribbon.