MoreQuery for Mac 2.1

[smozgur]

smozgur submitted a new Excel article:

MoreQuery for Mac - More Power Query "Get Data" Options on Mac

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.

Read more about this Excel article...

 

[smozgur]

smozgur updated MoreQuery for Mac with a new update entry:

v2.0 - More "missing" features and user interface update

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

Read the rest of this update entry...

 

[smozgur]

smozgur updated MoreQuery for Mac with a new update entry:

Import files from subfolders

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

Read the rest of this update entry...

 

[michelf]

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

 

[smozgur]

Welcome to the MrExcel Message Board!

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

Yes, it should work on Mac but it is not a built-in dialog that you see. So, bugs are possible for different scenarios.
Is it possible to learn more about your source data? Is it a table range or web data or?

 

[michelf]

I tried as an example, from a folder, just to see how it works
I'll try with web data and update you

 

[michelf]

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

 

[smozgur]

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

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.

 

[smozgur]

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.

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.

 

[michelf]

will do thanks

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.