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.
Become an Insider: be one of the first to explore new Microsoft 365 features for you and your business.
Microsoft Power BI Desktop
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.
Microsoft Power BI Mobile
Access your data anywhere, anytime. These native apps provide live, interactive, mobile access to your important business information.
Microsoft on-premises data gateway
Use VBA to author Power Query queries. Although authoring in the Power Query Editor is not yet available in Excel for Mac, VBA does support Power Query authoring. Here is some basic code you can adapt and use. Create a query and load its data. Here is a simple sample that adds a query that creates a list with values from 1 to 100. 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.
Keep your dashboards and reports up to date by connecting to your on-premises data sources—without the need to move the data.
On-premises reporting with Power BI Report Server
Deploy and distribute interactive Power BI reports—and traditional paginated reports—within the boundaries of your organization’s firewall.
Microsoft Power BI Report Builder
Create pixel-perfect paginated reports for printing or electronic distribution with a familiar experience relied on by thousands of report authors.
×![Download power query excel 365 Download power query excel 365](/uploads/1/2/7/2/127254255/113162495.png)
Okay, let's get your download started!
Let us know where we can send you tips and tricks for getting started fast with Power BI.
This post has been republished via RSS; it originally appeared at: Excel Blog articles.
Excel 2016 for Windows introduced a powerful set of Get & Transform Data tools. These tools, based on Power Query technology, enable you to easily connect, combine, and shape data coming from a variety of sources.
Today, we are excited to announce the first step in a journey to support Power Query in Excel for Mac. This is by far the most popular idea on Excel UserVoice under Excel for Mac category. In this release, you can refresh your Power Query queries on Mac from Text, CSV, XLSX, XML and JSON files, and you can author queries with VBA.
Getting Started
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
![Query Query](/uploads/1/2/7/2/127254255/601719598.jpg)
You can now refresh the Power Query queries in your workbook that pull data from Text, CSV, XLSX, XML or JSON files. Triggering the refresh command is done the same way that you've been doing it so far. For example:
- Click on the Data tab of the ribbon > then choose Refresh All
- Right-click on your query table > then click Refresh
- Right click on your PivotTable > then click Refresh Data
- Use a VBA script
- And more...
Please note that upon the first time you try to refresh your workbook queries, you may need to update the location of the data source so that it works on your Mac. Click the Data tab on the ribbon > Connections > select the desired connection > and click Change File Path button to update it.
Authoring Power Query Queries
With this update, you can also create and manage Power Query queries in your workbook using VBA. Any existing macros and VBA scripts that reference Workbook.Queries and WorkbookQuery entities in the Excel's object model will work in Excel for Mac as expected.
Note: You may still need to adjust your scripts to reflect the notion of a file path on Mac (e.g., /Users/USERNAME/Desktop/data.csv) that is different than a file path on Windows (e.g., C:UsersUSERNAMEDesktopdata.csv).
Sharing your feedback
Add Power Query To Excel 2013
Let us know what you think and submit your feedback using Send a Smile/Frown (Send us a Smile or Frown button at the top right)!
Stay tuned for more updates!
Power Query Update Download
Guy Hunkin
Download Power Query Excel 365
Program Manager, Excel