• Skip to main content
  • Skip to header right navigation
  • Skip to site footer

My Online Training Hub

Learn Dashboards, Excel, Power BI, Power Query, Power Pivot

  • Courses
  • Pricing
    • Free Courses
    • Power BI Course
    • Excel Power Query Course
    • Power Pivot and DAX Course
    • Excel Dashboard Course
    • Excel PivotTable Course – Quick Start
    • Advanced Excel Formulas Course
    • Excel Expert Advanced Excel Training
    • Excel Tables Course
    • Excel, Word, Outlook
    • Financial Modelling Course
    • Excel PivotTable Course
    • Excel for Customer Service Professionals
    • Excel for Operations Management Course
    • Excel for Decision Making Under Uncertainty Course
    • Excel for Finance Course
    • Excel Analysis ToolPak Course
    • Multi-User Pricing
  • Resources
    • Free Downloads
    • Excel Functions Explained
    • Excel Formulas
    • Excel Add-ins
    • IF Function
      • Excel IF Statement Explained
      • Excel IF AND OR Functions
      • IF Formula Builder
    • Time & Dates in Excel
      • Excel Date & Time
      • Calculating Time in Excel
      • Excel Time Calculation Tricks
      • Excel Date and Time Formatting
    • Excel Keyboard Shortcuts
    • Excel Custom Number Format Guide
    • Pivot Tables Guide
    • VLOOKUP Guide
    • ALT Codes
    • Excel VBA & Macros
    • Excel User Forms
    • VBA String Functions
  • Members
    • Login
    • Password Reset
  • Blog
  • Excel Webinars
  • Excel Forum
    • Register as Forum Member

Power Query Version Compatibility and Installation

You are here: Home / Power Query / Power Query Version Compatibility and Installation
Excel Power Query
February 1, 2016 by Mynda Treacy

When you know what Power Query is capable of you’ll want to get your hands on it immediately. It’s available in 32-bit and 64-bit, but unfortunately it’s not available in all versions of Excel.

I’ve put together a comparison table to help you identify Power Query version compatibility.

Power Query Version Compatibility Table

Power Query version compatibility comparison table

How to check what version of Excel you have

Discovering which version of Excel you have is slightly different depending on the version.

Excel 2010

Go to the File tab > Help. On the right you’ll see the version and bitness:

Find version in Excel 2010

Excel 2013 and 2016

Go to the File tab > Account and then click on the About Excel button. This will display the About Microsoft Excel window where you can see the version, build and the bitness:

Find version in Excel 2013

Click here for a complete guide on finding which version of Office you’re using.

How to Install Power Query

Now you know which version of Excel you have and whether you can get Power Query you’re either annoyed you don’t have the correct version (I’ll tell you the cheapest way to solve that in a moment*), or you’re ready to go and install it.

Installing Power Query for Excel 2010 and 2013

In Excel 2010 and Excel 2013 Power Query is available as a free add-in. You can find out more about the system requirements and download it here.

Note: make sure you choose the correct version to match the bitness (32-bit or 64-bit) for your installation of Excel.

Once you’ve downloaded it simply run the MSI installer and follow the steps.

When the install is complete you’ll find a new tab for Power Query:

Power Query ribbon Excel 2013

Note: if you’ve installed Power Query and it’s gone missing you can usually re-enable it by going to the COM add-ins.

File tab > Options > Add-ins > COM Add-ins:

Power Query add-in Excel 2013

Excel 2016 Onward and Office 365

In Excel 2016 onward and Office 365 Power Query is integrated and is included in the Data tab, which means you don’t need to download or install it. You’ll also find that in Excel 2016 Power Query took on a new name: Get and Transform (personally I preferred Power Query, but anyway):

Power Query ribbon Excel 2016

*Power Query not available in your version of Excel

If you find you don’t have a version of Excel that has Power Query then the cheapest and easiest solution is to purchase the Standalone version of Excel 2013, or 2016 for around US$100 (price varies based on your local currency).

Go to www.MicrosoftStore.com and in the Search field type ‘Standalone Excel’. If you only need it for home use then you can choose the ‘non-commercial’ licence, which is cheaper.

The great thing about this version of Excel is that it comes with EVERYTHING. That means full Power Query functionality AND full Power Pivot functionality, as well as all the other standard Excel features.

Power Query in Action

So, now that you’ve installed Power Query here are some examples of ways you can use it:

Combine Excel Worksheets with Power Query

Split text with Power Query

Transpose Data with Power Query

Power Query Training

If you want to get up and running with Power Query fast then check out my Power Query course. I’ll have you up to speed in just 3.5 hours.

Excel Power Query

More Power Query Posts

Power Query if Statements incl. Nested ifs, if or, if and

How to write Power Query if statements, including nested if, ‘if or’ and ‘if and’, which are easier to write than their Excel counterparts.
power query variables

Power Query Variables 3 Ways

Power Query Variables enable you to create parameters that can be used repeatedly and they’re easily updated as they’re stored in one place.
delete empty rows and columns using power query

Remove Blank Rows and Columns from Tables in Power Query

Delete blank rows and columns from tables using Power Query. Even rows/columns with spaces, empty strings or non-printing whitespace
extracting data from lists and records in power query

Extracting Data from Nested Lists and Records in Power Query

Learn how to extract data from lists and records in Power Query, including examples where these data structures are nested inside each other.
combine files with different column names in power query

Combine Files With Different Column Names in Power Query

Learn how to load data into Power Query when the column names in your data don't match up. Sampe files to download.
power query keyboard shortcuts

Power Query Keyboard Shortcuts to Save Time

Time saving keyboard shortcuts for Power Query that work in both Excel and Power BI. Download the free Shortcuts eBook
remove text between delimiters power query

Remove Text Between Delimiters – Power Query

Remove all occurrences of text between delimiters. There's no in-built Power Query function to do this, but this code does.
power query advanced editor tips

Tips for Using The Power Query Advanced Editor

Tips for using the Power Query Advanced Editor in Excel and Power BI. Watch the video to see these tips in action
pivot unknown variable number of rows to columns

Pivot an Unknown Number of Rows into Columns

How do you pivot rows to columns when you don't know how many rows you're dealing with? It's not as easy as you may think.
try otherwise power query iferror

IFERROR in Power Query Using TRY OTHERWISE

Using TRY..OTHERWISE in Power Query Replicates Excel's IFERROR So You Can Trap and Manage Errors In Your Queries.


Category: Power Query
Previous Post:Transpose data in ExcelTranspose Data in Excel
Next Post:Power Query Reformats Ugliest Report EverUgly Excel Report

Reader Interactions

Comments

  1. Mark Jackman

    March 11, 2022 at 3:39 am

    Hi Mynda
    I Really want to use Power Query but I am on Excel 2010.
    I have just gone to the MS Download site where is states:-
    “Microsoft Power Query for Excel is an Excel add-in that enhances the self-service Business Intelligence experience in Excel by simplifying data discovery, access and collaboration. (Note: The Microsoft Power Query add-in for Excel 2010/2013 is no longer being updated by Microsoft. Please upgrade to a newer Excel version.)”

    My query is when did MS stop up updating Power Query for Excel 2010/2013, AND will the current version of Power Query (PowerQuery_2.62.5222.761 (64-bit) [en-us].msi) still install and run OK on Excel 2010?

    Kind Regards,….Mark

    Reply
    • Mynda Treacy

      March 11, 2022 at 9:22 am

      Hi Mark,

      I would expect it will work for you as it states that version on the install page specifically for Excel 2010. I don’t know when they stopped updating it, but I’d say it was many years ago! It’ll still be worth using though.

      Mynda

      Reply
  2. Carl Fernandes

    April 22, 2021 at 10:27 pm

    Greetings , hope you are doing well during this pandemic , my queries are

    Q.1 How do I activate Power Query in Excel , I am using Microsoft Office Home and Student Version 2019 ?

    Q.2 How do I copy and paste data in Excel , multiple times using Power Query ?

    Sincere and grateful thanks

    Carl Fernandes

    Reply
    • Mynda Treacy

      April 23, 2021 at 9:07 am

      Hi Carl,

      You don’t need to activate Power Query in Excel 2019. It’s already available on the Data tab of the ribbon in the Get & Transform group of buttons on the left hand side.

      Power Query isn’t about copying and pasting, it’s about getting and cleaning data. If after you’ve got and cleaned the data once, you then load the data to the worksheet where you can copy and paste multiple times. Alternatively, you can duplicate the query and close and load to separate sheets if you want the same data multiple times, but I doubt this is what you really want.

      If that doesn’t answer your question, please post on our Excel forum where you can also upload a sample file and we can help you further.

      Mynda

      Reply
  3. Huyen

    October 22, 2020 at 4:43 pm

    Hi, I would like to check is there any differences between the Power Query in Excel 2016 and Excel 365 (besides the name?).
    BRs.

    Reply
    • Mynda Treacy

      October 22, 2020 at 8:12 pm

      Hi Huyen, you can see the version comparisons here. Mynda

      Reply
  4. Van

    October 18, 2019 at 9:53 am

    Hi,

    I using Excel 2016, My excel have Query already but I saw it different with Video training.
    Example: My Excel: in Query option, in Data Load have 2 item: Default Query load setting, Data Cache Management Option.
    But in video training in Query option, in Data load have 3 item: Type Detection, Relationships, Background data.
    So when I try combine from Multi Excel to one workbook, I can not do.

    Reply
    • Mynda Treacy

      October 18, 2019 at 11:29 am

      Hi Van,

      These settings shouldn’t affect the ability to combine multiple files. Perhaps you can post your question on our Excel forumExcel forumExcel forum where you can include your files and screenshots of the errors you’re getting so we can help you further.

      Mynda

      Reply
  5. Joe

    August 20, 2019 at 2:43 am

    Hi Mynda,
    Just had my laptop upgraded to WIN10 from Win7. Also went from office 2013 to office 2016. When I open and try to refresh an excel model I get a message “The power query queries in this workbook might be incompatible with your current version of excel. These queries were authored with a newer version of PQ and might not work in your current version”.
    Also, when I refresh data I am now receiving a error “we couldn’t refresh connection [expression.Error] 2 arguments were passed to a function which expects 1.

    Any thoughts on how to correct this?

    Thanks,
    Joe

    Reply
    • Catalin Bombea

      August 20, 2019 at 3:37 am

      Hi Joe,
      Did you installed all updates after installing office? Check and install updates, then try again that file, you might be missing updates.

      Reply
      • Joe

        August 20, 2019 at 4:40 am

        The option to update is not available…I believe IT has disabled it so they can do enterprise wide updates. This is a real problem as most if not all my models are rendered useless.

        Reply
        • Catalin Bombea

          August 20, 2019 at 12:49 pm

          Then you need to ask them to update, there is no other way.

          Reply
        • Beth Lewis

          October 5, 2019 at 7:16 am

          Hi Joe – did you determine if there IS an update? I am not in the EXACT same position, and I am trying to determine if there is an update available from MS. In this blog from Mynda back in 2017 (and the last comment from her below – https://www.myonlinetraininghub.com/power-query-version-compatibility-and-installation#comment-48495), it doesn’t appear to be:
          https://www.myonlinetraininghub.com/power-query-updates

          I am on Microsoft Office Professional Plus 2016 – an enterprise install.

          On one of my tools, when I got the message, it did take me to the Promote Headers step, so I deleted that and added it back in and the error went away. I am in the process of testing the rest of the functionality, but I can get the query results by deleting the Promote Headers step and inserting a new one!

          I was hoping someone found out they were providing updates!

          Reply
          • Mynda Treacy

            October 5, 2019 at 7:42 pm

            Hi Beth,

            Enterprise installs get updates. You’ll just need to speak to your IT people.

            Mynda

  6. Fran Reed

    January 29, 2019 at 3:55 am

    Thanks Mynda for preparing this schedule. Its hard to find this kind of information. Is the information on the chart still relevant ? I find it very discouraging when working with clients that are “hosted” and think they are set, cause hosting company is providing versions of Excel 2016 yet they do not have full PQ in them..and they can not refresh the templates I send them. It is soooo frustrating.

    Reply
    • Mynda Treacy

      January 29, 2019 at 8:49 am

      Hi Fran,

      Yes the table is still relevant for Excel 2016.

      All versions of Excel 2016 can get data from the following sources: CSV & Text, Table/Range, Excel workbook, XML, JSON, Folder, Access, SQL Server, Web, OData feed, Analysis Services, Facebook, ODBC, OLEDB, and Microsoft Query.

      If your templates get data from databases or other cloud services then only Office 2016 Professional, Office 2016 Professional Plus, and Excel 2016 standalone licences have access to these, as explained here.

      Mynda

      Reply
  7. ScotsSailor

    April 11, 2018 at 2:31 am

    Stand-alone versions of Excel that are not married to an existing 365 installation feature an old version of Power Query. I first noticed this in September 2017, when I was creating workbooks for my office using Excel updated via 365, which could not be run by others, without various changes. Even the development environment for the queries has less features, such as not being able to choose a join type while constructing the merge. One has to add the code in Advanced Editor, if the one default join type does not work for you.

    Given I first noticed this in September 2017 and nothing appears to have changed as of April 2018, the advice here is solid. In short, don’t use Excel updated via 365 to provide stand-alone Excel users with Power Query based workbooks.

    Reply
    • Mynda Treacy

      April 11, 2018 at 10:09 am

      You might want to update the standalone version of Excel. It will get some updates to Power Query, but not all new chart functionality etc. As it’s a standalone version you will have to manually do the update. Try File tab > Account. Usually there’s an ‘Updates’ button on that tab.

      Reply
  8. Vicky

    March 9, 2016 at 7:18 am

    Can dashboards created with Power Query and Power Pivot be shared with users that do not have these add-ins installed on their computers without losing connection to the analysis server?

    Reply
    • Mynda Treacy

      March 9, 2016 at 8:59 am

      Hi Vicky,

      Users without Power Query and Power Pivot can only look at the dashboards in a read only experience. i.e. they can’t click on Slicers to filter views etc.

      They are also likely to get error messages about connections being unavailable etc., which is fine to simply ignore, but some users might find this disconcerting.

      Kind regards,

      Mynda

      Reply
  9. Ken Witchel

    February 26, 2016 at 1:50 am

    Thank you Mynda for the summary. I have Excel 2013 and I downloaded Power Query last year. I was wondering: does Microsoft update the features of Power Query (I am not referring to the integration in Excel 2016)? If so, are the updates only available with a 365 subscription or does one have to re-install a newer version of Power Query?

    Ken

    Reply
    • Mynda Treacy

      February 26, 2016 at 8:39 am

      Hi Ken,

      Yes, Power Query gets updated regularly. If you have Excel 2010 or 2013 then you just need to download the add-in and reinstall it to get the updated version.

      Kind regards,

      Mynda

      Reply
      • Jeff Weir

        August 2, 2017 at 1:19 pm

        Mynda…that’s because those versions had the separate Add-in, right? What if you’re on Excel 2016 standalone? I’m presuming that no update is available in that case.

        Reply
        • Mynda Treacy

          August 2, 2017 at 5:42 pm

          Well so they (Microsoft) say, but I had a user this week with Standalone Excel installed in Dec 2016 and they got a May 2017 update which included Column from Examples, so I’d say it’s worth checking for updates to see if you get any.

          The official line is only Excel 2016 users with Office 365 licences get updates with new features. Standalone and other non-Office 365 licences get bug fixes only.

          Mynda

          Reply

Leave a Reply Cancel reply

Your email address will not be published. Required fields are marked *

Current ye@r *

Leave this field empty

Sidebar

More results...

Featured Content

  • 10 Common Excel Mistakes to Avoid
  • Top Excel Functions for Data Analysts
  • Secrets to Building Excel Dashboards in Less Than 15 Minutes
  • Pro Excel Formula Writing Tips
  • Hidden Excel Double-Click Shortcuts
  • Top 10 Intermediate Excel Functions
  • 5 Pro Excel Dashboard Design Tips
  • 5 Excel SUM Function Tricks
  • 239 Excel Keyboard Shortcuts

100 Excel Tips and Tricks eBook

Download Free Tips & Tricks

Subscribe to Our Newsletter

Receive weekly tutorials on Excel, Power Query, Power Pivot, Power BI and More.

We respect your email privacy

Guides and Resources

  • Excel Keyboard Shortcuts
  • Excel Functions
  • Excel Formulas
  • Excel Custom Number Formatting
  • ALT Codes
  • Pivot Tables
  • VLOOKUP
  • VBA
  • Excel Userforms
  • Free Downloads

239 Excel Keyboard Shortcuts

Download Free PDF

Free Webinars

Excel Dashboards Webinar

Watch our free webinars and learn to create Interactive Dashboard Reports in Excel or Power BI

Click Here to Watch Now

mynda treacy microsoft mvpHi, I'm Mynda Treacy and I run MOTH with my husband, Phil. Through our blog, webinars, YouTube channel and courses we hope we can help you learn Excel, Power Pivot and DAX, Power Query, Power BI, and Excel Dashboards.

Blog Categories

  • Excel
  • Excel Charts
  • Excel Dashboard
  • Excel Formulas
  • Excel PivotTables
  • Excel Shortcuts
  • Excel VBA
  • General Tips
  • Online Training
  • Outlook
  • Power Apps
  • Power Automate
  • Power BI
  • Power Pivot
  • Power Query
microsoft mvp logo
trustpilot excellent rating
Secured by Sucuri Badge
MyOnlineTrainingHub on YouTube Mynda Treacy on Linked In Mynda Treacy on Instagram Mynda Treacy on Twitter Mynda Treacy on Pinterest MyOnlineTrainingHub on Facebook
 

Company

  • About My Online Training Hub
  • Disclosure Statement
  • Frequently Asked Questions
  • Guarantee
  • Privacy Policy
  • Terms & Conditions
  • Testimonials
  • Become an Affiliate

Support

  • Contact
  • Forum
  • Helpdesk – For Technical Issues

Copyright © 2023 · My Online Training Hub · All Rights Reserved. Microsoft and the Microsoft Office logo are trademarks or registered trademarks of Microsoft Corporation in the United States and/or other countries. Product names, logos, brands, and other trademarks featured or referred to within this website are the property of their respective trademark holders.