As the name suggests Power Query is more powerful than MS Query. MS Query handles only ODBC data sources but Power Query can handle lot more.
Some details here:
http://hodentek.blogspot.com/2013/12/what-is-microsoft-power-query.html
Both MS Query and Power Query can be accessed in Microsoft EXCEL.
You have to install the EXCEL add-in for POWER Query from here:
http://www.microsoft.com/en-us/download/details.aspx?id=39379
Here is the ribbon tab for Power Query:
Some details here:
http://hodentek.blogspot.com/2013/12/what-is-microsoft-power-query.html
Both MS Query and Power Query can be accessed in Microsoft EXCEL.
MS Query and Power Query in MS EXCEL 2010 Professional Plus and x32 bit
You have to install the EXCEL add-in for POWER Query from here:
http://www.microsoft.com/en-us/download/details.aspx?id=39379
Here is the ribbon tab for Power Query:
No comments:
Post a Comment