Add support for Get & Transform (formerly Power Query)
Make Get & Transform (formerly Power Query) available in Excel for Mac (like in Excel for Windows)
We are pleased to announce that the first set of Power Query features are now available in version 16.29 and greater. At this stage you can refresh from text, CSV, XLSX, JSON and XML files.
Refer to the following blog post for more details:
I encourage you to try the new functionality and share your feedback with us via Send a Smile/Frown at the top right corner in your Excel for Mac.
David MC commented
Nope. Sorry. Go back and try again. As I said in my previous post: "We don't simply want a way to refresh PQ connections in Excel for Mac, we NEED a way to create and edit M-Code in PQ for Mac. And, frankly, we need it yesterday. Figure it out."
When will Microsoft Excel provide an update on when Power Query will be available on Excel 365 for Mac? It is October 2019 and most MAC Office 365 users feel cheated and deceived!!
Adding Data Model to Excel for Mac!!!
It has been over a month when i lodged a request for Power Query and now Power BI to be added onto Excel 365 for MAC.
Why it has taken so long for Microsoft to add this feature on Excel for MAC?
There are other Office 365 Mac users who have upgraded their notebooks and desktops from PC to MAC. So, as a consumer we expect Office 365 for Windows to have the same functions and features in Office 365 for MAC.
At the minute, I have to deviate between my Windows 7 Notebook and MAC Pro notebook when I am using the Power Query function and writing up some Visual Basic commands (Index and Match commands for a Dashboard spreadsheet).
Can anyone from Microsoft provide an update on this issue please?
Power query / Get and Transform is a must needed feature in Excel for mac
<MidNightRead><FileHeader><TypeOfRead>1</TypeOfRead><NetworkId>2945</NetworkId><Date>310819</Date></FileHeader><MeterRecords><Record><MeterType>1P</MeterType><DateTime>2019-09-01 00:00:00</DateTime><MeterID>LWT73282881138</MeterID><PF>0.78</PF><kWh>788.66</kWh><kWh-TZ1>301.33</kWh-TZ1><kWh-TZ2>146.1</kWh-TZ2><kWh-TZ3>5.69</kWh-TZ3><kWh-TZ4>335.54</kWh-TZ4><kVAh>998.48</kVAh><kVAh-TZ1>422.4</kVAh-TZ1><kVAh-TZ2>186.1</kVAh-TZ2><kVAh-TZ3>25.69</kVAh-TZ3><kVAh-TZ4>364.29</kVAh-TZ4><PowerOn_Duration>1418</PowerOn_Duration><MD-kW>0.0</MD-kW><MD-kW-Time>2019-00-00 00:03:00</MD-kW-Time><MD-kW-TZ1/><MD-kW-TZ2/><MD-kW-TZ3/><MD-kW-TZ4/><MD-kVA>0.0</MD-kVA><MD-kVA-Time>2019-00-00 00:03:00</MD-kVA-Time><MD-kVA-TZ1/><MD-kVA-TZ2/><MD-kVA-TZ3/><MD-kVA-TZ4/><kWh-TZ5/><kWh-TZ6/><kWh-TZ7/><kWh-TZ8/><kVAh-TZ5/><kVAh-TZ6/><kVAh-TZ7/><kVAh-TZ8/><MD-kW-TZ5/><MD-kW-TZ6/><MD-kW-TZ7/><MD-kW-TZ8/><MD-kVA-TZ5/><MD-kVA-TZ6/><MD-kVA-TZ7/><MD-kVA-TZ8/></Record><Record><MeterType>1P</MeterType><DateTime>2019-09-01 00:00:00</DateTime><MeterID>LWT73282881967</MeterID><PF>0.9</PF><kWh>2018.57</kWh><kWh-TZ1>838.09</kWh-TZ1><kWh-TZ2>354.71</kWh-TZ2><kWh-TZ3>42.81</kWh-TZ3><kWh-TZ4>782.96</kWh-TZ4><kVAh>2218.32</kVAh><kVAh-TZ1>917.46</kVAh-TZ1><kVAh-TZ2>396.64</kVAh-TZ2><kVAh-TZ3>51.58</kVAh-TZ3><kVAh-TZ4>852.64</kVAh-TZ4><PowerOn_Duration>1418</PowerOn_Duration><MD-kW>0.0</MD-kW><MD-kW-Time>2019-00-00 00:03:00</MD-kW-Time><MD-kW-TZ1/><MD-kW-TZ2/><MD-kW-TZ3/><MD-kW-TZ4/><MD-
Bernhard Keim commented
Power Query is the feature I miss most on the Mac. I am looking forward to see this implemented.
David MC commented
I am still confused about this update. I am running v.16.27 and in my XLSX file, I still do not see a way to edit a PowerQuery connection made in Excel for Windows. If this isn't possible with the most recent "fast insiders" release than this isn't an answer to our request at all. We don't simply want a way to refresh PQ connections in Excel for Mac, we NEED a way to create and edit M-Code in PQ for Mac. And, frankly, we need it yesterday. Figure it out.
To Guy and Excel Team,
The Excel team have not answered the question on when the Power Query update will be available on the Microsoft Office web site to allow Excel Mac users to download the update?
As an Office 365 user I feel cheated by the fact that the Power Query tool is available on Office 365 for Windows only and the Excel team do not realise how popular the Mac computer is at this point in time.
All Office 365 Mac subscribers pay a monthly subscription to use Word, Outlook and Excel. Hence as a customer, we expect to receive the full functions of Office that are available of Office 365 for Windows.
It is time to flood social media (Twitter, Facebook an Instragram) with posts to place the pressure on Microsoft to provide the Power Query feature and other features that are available on the PC version and not on the MAC version on the MAC version from now on.
I support you will for it... this is mere antitrust !
There should literally be a class action lawsuit or antitrust action regarding this. We pay the exact same amount but don’t get the same features...unless we buy a Microsoft operating system??? Haven’t you guys already been through the antitrust exercise once? Clearly you haven’t learned your lessons. The fact that multiple features consistently lag or are slightly less convenient, is extremely unethical. Even the filter function sucks on Mac. Come on man!
I am currently using Office 365 for Mac (With Excel 365).
And I would like to know when will the Excel Power Query function be available for all Excel Mac Users this year?
Do you have a time frame on when the add in feature will be available on Excel for Mac.
I feel that it is unfair for all Mac Office 365 subscribers do not have access to the same features as Excel for Windows.
As a customer, we pay a monthly subscription. What would happen in a work environment that you have to prepare a non financial and marketing report on Excel for Mac 365 and the function on Excel is not available for the MAC???
Is that fair?
Hence, can you please provide us with a time frame on the release of the Power Query function for Excel 365 for Mac.
Please make the full functionality of power query available for Mac users!!
I'm trying to get external data from the web in office 2019 office on a mac. I have saved a plain test web query but when I run it I don’t nt get the data I want upload but instead d the hyperlink address in A1.
Chris Martens commented
this is crazy - and disgusting - that Mac excel users have no web connection options! Please provide a WEBSERVICE type functionality in the excel mac version as soon as possible.
Concur - Nee Query Builder GUI
Please put a query builder GUI in place.
What is the update here? When will Power Query be available for excel on Mac?
Ed Hansberry commented
Yes, XLSM would be supported as the spreadsheet is the same. I would be curious to know if it supports XLSB and XLS. Kinda doubt it as those are very different file formats, not XML based.
Jeff Berube commented
You say it supports XLSX at this time, does that include XLSM?