Database Reference
In-Depth Information
How to do it...
The tasks discussed in this recipe are as follows:
• Installing the Power Query add-in
• Installing the Power Maps add-in
• Enabling PowerPivot and Power View in Microsoft Excel
Installing the Power Query add-in
The Power Query add-in must be installed using an MSI installer package that is available
at
Microsoft Download Center
. The installer deploys the bits and enables the add-in in
your Excel installation.
The functionality in this add-in is regularly improved by Microsoft. Search for Microsoft
Power Query for Excel in Download Center for the latest version. The add-in can be down-
loaded for 32-bit and 64-bit Microsoft Excel versions.
Follow these steps to install the Power Query add-in:
1. Review the system requirements on the download page and update your system if
required. Note that when you initiate the setup, you may be prompted to install ad-
ditional components if you do not have all the requirements installed.
2. Right-click on the MSI installer and click on
Install
.
3. Click on
Next
on the
Welcome
page.
4. Accept the
License Agreement
and click on
Next
.
5. Accept the default or click on
Change
to select the destination installation folder.
6. Click on
Next
. On the
Ready to Install Microsoft Power Query for Excel
page,
click on
Install
.
7. The installation progress is displayed. Click on
Finish
on the
Installation Com-
pleted
page.
8. The
Power Query
tab is available on the Excel ribbon after this installation.
Installing the Power Map add-in
The Power Map add-in must be installed using an executable (
.exe
) installer package that
is available at Microsoft Download Center.
The functionality in this add-in also is regularly improved by Microsoft. Search for Mi-
crosoft Power Map for Excel in the Download Center for the latest version.