In Excel 2016, Power Query isn’t an add-in — it’s a native feature of Excel, just like charts and pivot tables are native features. If you’re working with Excel 2016, you don’t have to install any additional components. You’ll find Power Query in Excel 2016 hidden on the Data tab, in the Get & Transform group.
If you’re working with Excel 2010 or Excel 2013, you need to explicitly download and install the Power Query add-in. As of this writing, the Power Query add-in is available to you only if you have one of these editions of Office or Excel:
As a regular user of Power BI on Apple device, I chosed to configure a Windows VM with parallels desktop on my machine to get the best of the two worlds: Power BI Online on Mac for reading, editing and sharing dashboard, and Power BI Desktop on my VM for advanced editing and ETL stuffs. Power Query is a free add-in that can be downloaded here: Download the Power Query add-in. Once enabled, Power Query functionality is available from the Power Query tab on the ribbon. Excel for Microsoft 365 for Mac. If you're a Microsoft 365 subscriber, you can refresh existing Power Query query queries and use VBA to create and edit new.
- Office 2010 Professional Plus: Available for purchase through any retailer
- Office 2013 Professional Plus: Available through volume licensing only
- Office 365 Pro Plus: Available with an ongoing subscription to Office365.com
- Excel 2013 Stand-alone Edition: Available for purchase through any retailer
If you have any of these editions, you can install and activate the Power Query add-in. Simply enter the search term Excel Power Query add-in into your favorite search engine to find the free installation package.
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.
Microsoft Power Query For Excel Mac
After the add-in is installed, activate it by following these steps:
- Open Excel and look for the Power Query command on the Insert tab. If you see it, the Power Query add-in is already activated. You can skip the remaining steps.
- From the Excel Ribbon, choose File→Options.
- Choose the Add-Ins option on the left, and then look for the Manage drop-down list at the bottom of the dialog box. Select COM Add-Ins and then click Go.
- Look for Power Query for Excel in the list of available COM add-ins. Select the check box next to each one of these options and click OK.
- Close and restart Excel.
A successful install results in a new Power Query tab on the Excel Ribbon.Over the years, knowing whether you have access to the Power Pivot feature in Excel has been challenging at times to say the least. First introduced as an add-in for Excel 2010, availability of the tool has varied, depending upon which version of Excel you utilized. Fortunately, Microsoft simplified access to Power Pivot with the release of Excel 2019 and now, more people than ever have access to the feature.
which versions of Office/Excel provide access to power Pivot?
As of January 8, 2019, you have access to Power Pivot if you are running any of the following versions of Microsoft Office/Excel.
- An Office 365 subscription that includes a Desktop license of Excel for Windows
- Office Professional 2019
- Office Home & Business 2019
- Office Home & Student 2019
- Office 2016 Professional Plus
- Office 2013 Professional Plus
- Excel 2013 and Excel 2016 when purchased as a standalone product
Additionally, if you are still running Excel 2010, you can download the add-in for that version of Excel by clicking here or navigating to https://www.microsoft.com/en-us/download/details.aspx?id=43348. Note, however, that version of the add-in will work only with Excel 2010.
which versions of office/excel do not provide access to power Pivot?
Power Pivot is not available to those running any of the following versions of Microsoft Office/Excel.
- An Office 365 subscription that does NOT provide a desktop license of Excel for Windows
- Any version of Office for Mac
- Office Professional 2013
- Office Professional 2016
- Office Home & Student 2013
- Office Home & Student 2016
- Office Home & Business 2013
- Office Home & Business 2016
- Office for Android
- Office RT 2013
- Office Standard 2013
- Office Standard 2016
- All Office versions older than 2013, unless you download the add-in for Excel 2010
Power Pivot Use Cases
Regardless of the version of Excel you might use to access Power Pivot, the principal use case of this feature remains the same – it is used to manage data models in Excel. In addition, you can use Power Pivot to create links to external data sources and use the data provided by those data sources to populate your data models, although many will find Power Query to be a better option for this application. Of course, once you create a data model, you can then summarize and analyze the data in the data model rather easily using PivotTables and, when necessary, CUBE functions in Excel.
You can learn more about this valuable Excel feature from Microsoft by clicking here.Share on facebookFacebook Share on twitterTwitter