smozgur

MoreQuery for Mac 2.1

No permission to download

smozgur

BatCoder
Joined
Feb 28, 2002
Messages
2,680
smozgur submitted a new Excel article:

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


Read more about this Excel article...
 

Excel Facts

When they said...
When they said you are going to "Excel at life", they meant you "will be doing Excel your whole life".
smozgur updated MoreQuery for Mac with a new update entry:

Import files from subfolders


Read the rest of this update entry...
 
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
1687160091614.png
1687160108175.png
1687160122093.png
1687160193250.png
 
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?
 
I tried as an example, from a folder, just to see how it works
I'll try with web data and update you
 
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.
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.
 
will do thanks
 

Forum statistics

Threads
1,226,269
Messages
6,189,953
Members
453,584
Latest member
daihoctuxaeptit

We've detected that you are using an adblocker.

We have a great community of people providing Excel help here, but the hosting costs are enormous. You can help keep this site running by allowing ads on MrExcel.com.
Allow Ads at MrExcel

Which adblocker are you using?

Disable AdBlock

Follow these easy steps to disable AdBlock

1)Click on the icon in the browser’s toolbar.
2)Click on the icon in the browser’s toolbar.
2)Click on the "Pause on this site" option.
Go back

Disable AdBlock Plus

Follow these easy steps to disable AdBlock Plus

1)Click on the icon in the browser’s toolbar.
2)Click on the toggle to disable it for "mrexcel.com".
Go back

Disable uBlock Origin

Follow these easy steps to disable uBlock Origin

1)Click on the icon in the browser’s toolbar.
2)Click on the "Power" button.
3)Click on the "Refresh" button.
Go back

Disable uBlock

Follow these easy steps to disable uBlock

1)Click on the icon in the browser’s toolbar.
2)Click on the "Power" button.
3)Click on the "Refresh" button.
Go back
Back
Top