Using the Power Query Add-In - Microsoft Business Intelligence Tools for Excel Analysts - page 126

Installing and Activating
the Power Query Add-In
The Power Query Add-In does not come with Excel out of the box. Your administrator might have
installed it for you. If you see the Power Query tab on the Ribbon — look ahead to Figure 7-1 — you
already have it. If you don't see it, you need to download and install Power Query.
Downloading the Power Query Add-In
As of this writing, the Power Query Add-In is only available if you have one of the following editions
of Office or Excel:
Office 2010 Professional Plus: Available for purchase through any retailer
Office 2013 Professional Plus: Available through volume licensing only
Office 365 Pro Plus: Available with an ongoing subscription to Office365.com
Excel 2013 Stand-alone Edition: Available for purchase through any retailer
If you have one of these editions, you can install and activate the Power Query Add-In. Type Excel
Power Query Add-In into your favorite search engine to find the free installation package. Note that
Microsoft offers Power Query for both Excel 2010 and Excel 2013 in both 32- and 64-bit platforms. Be
sure to download the version that matches your version of Excel as well as the platform your PC is
running.
After it's installed, you need to activate the add-in by following these steps:
1. Choose File ➜ Options.
2. Select the Add-Ins option on the left, select COM Add-Ins from the Manage drop-down list,
and click Go.
3. Look for Power Query for Excel in the list of available COM Add-Ins. Select the check box next
to each one of these options and then click OK.
4. Close and restart Excel.
The Power Query tab is now on the Ribbon, as shown in Figure 7-1.
Figure 7-1: The Power Query Add-In is on its own tab on the Ribbon.