• 03 2201 4622
  • 03 5162 8254
  • 03 21784448

How to Install Power Query

Power Query enhances self-service business intelligence (BI) for Excel with an intuitive and consistent experience for discovering, combining, and refining data across a wide variety of sources including relational, structured and semi-structured, OData, Web, Hadoop, and more.

Windows 7

Requirement for Microsoft Office 2010
Internet Explorer 9 or Later
Only Microsoft Office 2010 Professsional Plus with update

Windows 8/10

Requirement for Microsoft Office 2010
Only Microsoft Office 2010 Professsional Plus with update

Windows 7

Requirement for Microsoft Office 2013
Internet Explorer 9 or Later
All version of Microsoft Office 2013 can support

Windows 8/10

Requirement for Microsoft Office 2013
All version of Microsoft Office 2013 can support

Windows 7

Requirement for Microsoft Office 2016
All version of Microsoft Office 2016 comes with Power Query
* No Need to Install *

Windows 8/10

Requirement for Microsoft Office 2016
All version of Microsoft Office 2016 comes with Power Query
* No Need to Install *

What Version of Excel Do I Need?

The download page for Power Query lists which version of Excel are compatible with Power Query.
The following Office versions for Windows are supported:

  1. Microsoft Office 2016 – All Versions
  2. Microsoft Office 2013 – All Versions
  3. Microsoft Office 2010 Professional Plus with Software Assurance

Both 32-bit and 64-bit are supported. Power Query is not compatible with any Mac versions of Excel yet.
Unfortunately,in case if you don’t have these versions you will need to upgrade to use Power Query.

Where Do I find the Power Query download link?

  1. Click Here Power Query x32 bit

  2. Click Here Power Query x64 bit

  3. Click Here Internet Explorer 11(for Windows 7 Only)

How Do I Check My Version of Excel?

Excel 2010

Here’s how to determine your version and 32 or 64 bit in Excel 2010:

  1. Click the File button.
  2. Click the Help option on the left side menu.
  3. The Excel version will be listed under the Product Activated section.
  4. The bit version (32-bit or 64-bit) will be listed under the About Microsoft Excel section.
mobile repairing

Excel 2013

Here’s how to determine your version and 32 or 64 bit in Excel 2013:

  1. Click the File button.
  2. Click the Account option on the left side menu.
  3. The Excel version will be listed under the Subscription Product section.
  4. Click the About Excel button. The bit version (32-bit or 64-bit) will be listed in the first row of the pop-up window.
mobile repairing

Excel 2016

Here’s how to determine your version and 32 or 64 bit in Excel 2016:

  1. Click the File button.
  2. Click the Account option on the left side menu.
  3. Click the About Excel button. The bit version (32-bit or 64-bit) will be listed in the first row of the pop-up window.
mobile repairing

How to know Power Query Successfully Installed or Not?

Once the installation is complete, open Excel. You should now see the Power Query tab in the Ribbon.

mobile repairing mobile repairing