Download Microsoft Power Query for Excel - Quickly and effortlessly enhance the self-service Business Intelligence experience in Excel by simplifying data discovery and access. Become an Insider: be one of the first to explore new Microsoft 365 features for you and your business. Microsoft Query X for Mac uses Open Database Connectivity (ODBC) to allow you to import data from databases into Microsoft Excel X. You can use Query X to create new queries or refresh existing. Want to run Power BI on a mac? We look at what your options are to get Power BI Desktop running on your mac. You have a few choices. Ideas: Power BI Designer. Excel 2016/2019 for Mac have many of the same basic analysis features that are listed above: PivotTables, slicers, charts, and basic import capabilities. They do not yet have Get & Transform or Power Pivot, but we are continually improving Excel on the Mac. Excel for Microsoft 365 for Mac offers some support for Power Query.

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:

• 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.

After the add-in is installed, activate it by following these steps:

1. 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.
2. From the Excel Ribbon, choose File→Options.
3. 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.
4. 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.
5. Close and restart Excel.

A successful install results in a new Power Query tab on the Excel Ribbon.

Whether you’re on the go or need to create rich, interactive reports, download the tools you need to build reports and stay connected to your data from anywhere, anytime. Get a 360° view of your business data on the go—at the touch of your fingers—and quickly connect, shape, visualize, and share data insights through Power BI.

Power Query Download Failed

With the Power BI Desktop you can visually explore your data through a free-form drag-and-drop canvas, a broad range of modern data visualizations, and an easy-to-use report authoring experience.

Access your data anywhere, anytime. These native apps provide live, interactive, mobile access to your important business information.

Keep your dashboards and reports up to date by connecting to your on-premises data sources—without the need to move the data.

Deploy and distribute interactive Power BI reports—and traditional paginated reports—within the boundaries of your organization’s firewall.

Create pixel-perfect paginated reports for printing or electronic distribution with a familiar experience relied on by thousands of report authors.

×

Okay, let's get your download started!

Power Query For Mac Download Mac

Let us know where we can send you tips and tricks for getting started fast with Power BI.