Sunday, December 15, 2013

What is the difference between MS Query and Power Query?

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:

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:

Here is the ribbon tab for Power Query:

No comments: