Power Query has been available for Excel since 2010. Here is how to add Power Query according to your Excel version.: Good news, you do not need to download Power Query for Excel 2019, 2016 or in Office 365. You can find it in the “Data” ribbon under the button “Get & Transform”. 2 days ago I have built a spreadsheet on Excel on Windows which has a number of queries created with the Power Query Editor. All of the queries fetch data from our SQL Server as a source. I have users of the spreadsheet who use Excel for Mac. When trying to refresh, we get the following error.
Power query is a great tool built by Microsoft that will help you work with data in Excel. This tool is great for connecting to various external data sources, querying and transforming data, or cleaning and parsing data.
- Web pages, Facebook
- Excel, CSV, XML, Text or Hadoop (HDFS) Files
- A Folder
- Various databases like MS Access, SQL Server, MySQL, Microsoft Azure SQL, Oracle, IBM DB2, PostgreSQL, Sybase, Teradata, OData etc…
- The new functionality is live for all Office 365 subscribers in Excel for Mac running version 16.29 (19090802) and later. If you are running an earlier version, find out how to update your Office for Mac. Refreshing Power Query queries. You can now refresh the Power Query queries in your workbook that pull data from Text, CSV, XLSX, XML or JSON.
- 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 on which your PC is running. After the add-in is installed, activate it by following these steps: Open Excel and look for the Power Query command.
This is available as an add-in for excel 2010 professional plus or 2013 and comes already built in for Excel 2016.
Power Query is not compatible with any Mac versions of Excel yet. Unfortunately, if you don't have these versions you will need to upgrade to use Power Query. To me, Power Query is worth the upgrade to Office 365 alone, and there are a lot of other cool new features too.
You can download Excel Power Query here from Microsoft.
Unfortunately, if you’re not running Excel 2010 professional plus or 2013, then you will need to upgrade to Excel 2016 in order to use this feature as it’s not available for previous versions of Excel. Mac user are also out of luck.
There are both a 32-bit and 64-bit versions and which one you choose will depend on the version of Excel which you have installed.
Excel 2010
To check what version you have:
- Go to the “File” tab.
- Go to the “Help” section.
- Here you will see the product version, if it says professional plus 2010, then you’re in luck.
- Here you will either see 32-bit or 64-bit. Take note and download the correct Power Query add-in version accordingly.
Excel 2013
To check what version you have:
- Go to the “File” tab.
- Go to the “Account” section.
- Here you will see the product version.
- Click on the “About Excel” button.
- In the screen that pops up, at the top you will either see 32-bit or 64-bit. Take note and download the correct Power Query add-in version accordingly.
Excel 2016
Power query comes pre-installed in Excel 2016 but has been renamed to “Get & Transform” and is under the Data tab in the ribbon. If you have Excel 2016, then you don’t need to do anything to use it.
Download The Add-In
Go to the Microsoft website:
Microsoft Excel Power Query For Mac
- Select your preferred language.
- Click the download button.
Excel Power Query Tutorial
Select The Correct Version
- Select either the 32-bit or 64-bit version depending on your version of Excel.
- Click the next button.
Excel Power Query For Mac
Run The Setup Wizard
Make sure Excel is closed and then click the download from the download bar from your browser.
Follow The Setup
Power Query For Excel Mac Download
Follow the steps in the Setup Wizard.
Excel Power Query For Mac Windows 10
Power Query Is Now Ready To Use
Now the next time you open up Excel, Power Query will be available to use under its own tab.