PDA

View Full Version : Installing Power Query



Ken Puls
2016-03-31, 07:55 PM
Looking to get Power Query? Here's what you need to know:

Getting Power Query
Office 2016: Power Query is installed by default and can be found on the Get & Transform group of the Data tab

Office 2013: Power Query must be downloaded (link below)

Office 2010: Power Query must be downloaded (link below) and is only officially supported if you have software assurance. (Try it anyway.)

For office 2010/2013, you can download the most recent version from Microsoft's site here: https://www.microsoft.com/en-ca/download/details.aspx?id=39379

There are three things you should know about this download package:
- It takes admin rights to install
- You need to get the correct version: 32bit (x86) or 64bit (x64). This MUST match the version of Office (not Windows) that is installed on your system. To figure this out Go to File --> Account --> About Excel. The "bitness" should be listed at the end

- Power Query gets updated about monthly (which is awesome), so watch for those updates as new functionality is added all the time!

Do I get all the features?

Maybe... for Office 2010 the answer is yes. For Office 2013 and higher, it depends what SKU of Office you are running. There are two different levels:

Power Query Premium: All Power Query features available for: Professional Plus, Office 365 ProPlus or Excel Standalone
Power Query Public: Available for all other Office Desktop SKUs. Includes all Power Query features, except the following ones: Corporate Power BI Data Catalog, Azure-based data sources, Active Directory, HDFS, SharePoint Lists, Oracle, DB2, MySQL, PostgreSQL, Sybase, Teradata, Exchange, Dynamics CRM, SAP BusinessObjects, Salesforce


Keeping Abreast of Updates

Power Query is updated approximately monthly, constantly shipping with new features. To keep up to date with which features have shipped, watch the Microsoft Excel blog, and specifically for Power Query (Get & Transform) posts (http://blogs.office.com/?s=power+query).

Enjoy!

Ken Puls
2016-05-31, 10:44 PM
I have started capturing legacy versions of the installers, just in case a newer update has a bug and you need to roll back.

Please be aware that these are not necessarily the final release version, but rather the last version I captured before I updated. They were officially published by Microsoft, but you still install at your own risk and all that. :)

You can find a link in my OneDrive (http://bit.ly/2KAWc73) to the following versions as well as all newer versions:



Version
Release Date
32 bit
64 bit


2.43.4647.201
2017-04-06
Yes
Yes


2.42.4611.421
2017-03-09
Yes
Yes


2.41.4581.1182
2017-02-09
Yes
Yes


2.40.4554.161
2017-01-05
Yes
Yes


2.39.4526.123
2016-11-29
Yes
Yes


2.38.4491.181
2016-10-24
Yes
Yes


2.37.4464.644
2016-10-06
Yes
Yes


2.36.4434.1001
2016-08-25
Yes
Yes


2.35.4399.761
2016-07-25
Yes
Yes


2.34.4372.163
2016-06-21
Yes
Yes


2.33.4337.481
2016-05-19
Yes
Yes


2.32.4307.502
2016-04-27
Yes
Yes


2.31.x
?




2.30.4246.1721
2016-04-08

Yes


2.29.4217.1861
2016-02-25

Yes


2.28.x
?




2.27.x
?




2.26.4128.242
2015-11-08
Yes
Yes



Click here to go to the link on my OneDrive (http://bit.ly/2KAWc73).

FYI, I've also got copies of Power BI Desktop in here as well now, going back to Jun 2016.

dburke
2016-12-02, 06:21 PM
Friends,

November 2016 updates for Get & Transform in Excel 2016 and the Power Query add-in

Name: PowerQuery_2.39.4526.123
Date Published: 11/29/2016
Features: https://goo.gl/Hf8wr1
Download: https://goo.gl/QWnKYV

Updates include the following new or improved data connectivity and transformation features:


Web Connector—UX support for specifying HTTP Request Headers
OData Connector—support for “Select Related Tables” option
Oracle Connector—improved Navigator preview performance
SAP HANA Connector—enhancements to parameter input UX
Query Dependencies view from Query Editor
Query Editor ribbon support for scalar values
Add custom column based on function invocation
Expand & Aggregate columns provide support for “Load More” values
Convert table column to a list—new transformation
Select as you type in drop-down menusNovember 2016 updates for Get & Transform in Excel 2016 and the Power Query add-in

Ken Puls
2016-12-02, 09:39 PM
Awesome. Added the most recent packages to the OneDrive table/folder.

BBMB
2017-03-22, 07:22 PM
I have Office 2016, but when I try to install the latest PQ updates, it says failed because I already have it. Perhaps Office automatically installs these updates? Or am I doing something wrong.

Ken Puls
2017-06-08, 09:32 PM
Sorry, missed this post! I know it's old, but a great question that does need answering. :)

In Excel 2016, Power Query is built in to every version. You'll find it on the Data tab on the Get & Transform group. It will even update automatically if you're on subscription.