Forum Discussion
How to combine the rows in multiple worksheets into one master sheet?
JimGMac Which "unrestricted" version would that be. I'm on 16.64 (22073100). It certainly has a great deal of PQ but I wouldn't call it "full capabilities". Am I missing out on something?
I think all the functionality, including DAX, are supported in Mac Excel PowerQuery. Are you aware of something missing?
You "think all the functionality, including DAX, are supported in Mac Excel PowerQuery". And yes, I am aware of "something missing" and surprised that you are not.
But let me begin by saying I'm extremely happy that PQ finally came to the Mac not too long ago. Though, it is still for Insiders Beta Channel only, as far as I know.
To mention just a few differences, you can't connect to a web-site or all files in a folder. You can't directly connect to a table or range in the current workbook. You can't choose to have a connection only query and change it later. All queries load to an Excel table (by default) which you can then remove, of course. But you need to go back to the query editor, duplicate the query and close and load again, if you change your mind. Another major feature that is missing, though I trust it will be coming soon, is IntelliSense. In the PC version, PQ helps you complete M-code as you start writing a piece of code. Suggesting functions to use with instructions on how to use them. An invaluable tool, in my opinion. Without it, writing M-code from scratch is extremely challenging. Especially, for Mac users who are totally new to PQ.
And then, when it comes to DAX, that's part of PowerPivot / Data Model, which is not supported by Excel for the Mac (yet).
Hi Riny,
You're right that I have very limited PQ experience, as it has not been on the Mac until recently.
Please excuse my misinterpretation of DAX, as I thought that is what the PQ editor was writing. I really have to get my manuals on PowerQuery out and go through them now. I didn't know DAX is restricted to the Data Model, which is not supported and probably never will be.
You CAN directly query tables in the active workbook. That I have tried and it works. Use the Excel connector and choose the file you currently have open.
The Advanced editor seems to have Intellisense. I haven't used the Windows Excel PQ to offer a comparison.