Results 1 to 6 of 6

Thread: Installing Power Query

  1. #1
    Administrator Ken Puls's Avatar
    Join Date
    Mar 2011
    Location
    Nanaimo, BC, Canada
    Posts
    2,298
    Articles
    57
    Blog Entries
    14
    Excel Version
    Excel Office 365 Insider

    Post Installing Power Query



    Register for a FREE account, and/
    or Log in to avoid these ads!

    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/down....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.

    Enjoy!
    Ken Puls, FCPA, FCMA, MS MVP

    Learn to Master Your Data at the Power Query Academy (the world's most comprehensive online Power Query training), with my book M is for Data Monkey, or our new Power Query Recipe cards!

    Main Site: http://www.excelguru.ca -||- Blog: http://www.excelguru.ca/blog -||- Forums: http://www.excelguru.ca/forums
    Check out the Excelguru Facebook Fan Page -||- Follow Me on Twitter

    If you've been given VBA code (a macro) for your solution, but don't know where to put it, CLICK HERE.

  2. #2
    Administrator Ken Puls's Avatar
    Join Date
    Mar 2011
    Location
    Nanaimo, BC, Canada
    Posts
    2,298
    Articles
    57
    Blog Entries
    14
    Excel Version
    Excel Office 365 Insider
    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 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.

    FYI, I've also got copies of Power BI Desktop in here as well now, going back to Jun 2016.
    Ken Puls, FCPA, FCMA, MS MVP

    Learn to Master Your Data at the Power Query Academy (the world's most comprehensive online Power Query training), with my book M is for Data Monkey, or our new Power Query Recipe cards!

    Main Site: http://www.excelguru.ca -||- Blog: http://www.excelguru.ca/blog -||- Forums: http://www.excelguru.ca/forums
    Check out the Excelguru Facebook Fan Page -||- Follow Me on Twitter

    If you've been given VBA code (a macro) for your solution, but don't know where to put it, CLICK HERE.

  3. #3

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

    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

  4. #4
    Administrator Ken Puls's Avatar
    Join Date
    Mar 2011
    Location
    Nanaimo, BC, Canada
    Posts
    2,298
    Articles
    57
    Blog Entries
    14
    Excel Version
    Excel Office 365 Insider
    Awesome. Added the most recent packages to the OneDrive table/folder.
    Ken Puls, FCPA, FCMA, MS MVP

    Learn to Master Your Data at the Power Query Academy (the world's most comprehensive online Power Query training), with my book M is for Data Monkey, or our new Power Query Recipe cards!

    Main Site: http://www.excelguru.ca -||- Blog: http://www.excelguru.ca/blog -||- Forums: http://www.excelguru.ca/forums
    Check out the Excelguru Facebook Fan Page -||- Follow Me on Twitter

    If you've been given VBA code (a macro) for your solution, but don't know where to put it, CLICK HERE.

  5. #5
    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.

  6. #6
    Administrator Ken Puls's Avatar
    Join Date
    Mar 2011
    Location
    Nanaimo, BC, Canada
    Posts
    2,298
    Articles
    57
    Blog Entries
    14
    Excel Version
    Excel Office 365 Insider
    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.
    Ken Puls, FCPA, FCMA, MS MVP

    Learn to Master Your Data at the Power Query Academy (the world's most comprehensive online Power Query training), with my book M is for Data Monkey, or our new Power Query Recipe cards!

    Main Site: http://www.excelguru.ca -||- Blog: http://www.excelguru.ca/blog -||- Forums: http://www.excelguru.ca/forums
    Check out the Excelguru Facebook Fan Page -||- Follow Me on Twitter

    If you've been given VBA code (a macro) for your solution, but don't know where to put it, CLICK HERE.

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts
  •