MoreQuery for Mac 2.1

What is 'MoreQuery for Mac' add-in?​

Starting in early 2023, we finally have a more powerful Power Query on Mac. However, there are some missing Get Data options which are essential for almost everyday use. I personally don’t understand why the development team didn’t include these essential options initially, but I decided to complete these options by creating an add-in until they implement them.

The add-in has been developed and tested on MacOS Ventura.

Click to expand...

Click to expand...

Updates:

• The list object's connection property is now being created by using an actual workbook connection object. This also allows creating connection-only queries properly.
• Minor bug fixes.

New Features:

• The Import Data dialog
  View attachment 91896
• From Existing Connection
  View attachment 91897
• Connection-only query

Click to expand...

New Feature:

• It is now possible to import files from the subfolders.

The Folder.Files function doesn't work correctly on Mac and fails to return the correct path information for nested folders. As a result, in previous versions, importing files from subfolders of the selected folder was not an option. However, in this new version, the Folder.Content function is being used instead. With the help of a custom function, files in the...

Click to expand...

michelf said:

Hey Suat, thanks for the amazing add in
does the function of adding only as pivot table should work on a Mac?
for me only the add as table is working, when I chose the PivotTable Report I get this error below
thanks

Click to expand...

michelf said:

it's working both with JSON and from Table/Range

Click to expand...

smozgur said:

Yes, I just saw From Folder result with the Pivot Table option and it fails as you said. I'll check it out.
Thanks for reporting this.

Click to expand...

smozgur said:

It looks like another bug on Mac. I'll try to find a workaround to solve it in the add-in, however, in the meantime, just remove the binary column in the Power Query interface before you load it to a PivotTable. The table is not supposed to have any Binary column after transforming data already, however, it is something that could be expected and handled on Windows but Mac. On Mac, if there is a binary column and you want to load it to a pivot table, then it tries to load the binary field into the pivot cache and naturally it fails.

Click to expand...