Power Query for Mac Excel is missing From Table/Range.
Power Query for Mac Excel is missing From Folder.
Power Query for Mac Excel is missing From XML.
Power Query for Mac Excel is missing From JSON.

A new More Data add-in from Suat Ozgur at MrExcel adds all four of these functionalities to Excel for Mac! Download the add-in from this article: https://www.mrexcel.com/board/excel-articles/morequery-for-mac.68/

The FREE, open-source add-in adds From Table/Range to Power Query for Mac. It adds From Folder. It adds From XML. It adds from JSON.

Table of Contents:
(0:00) More Data Add-In fixes Power Query for Mac
(0:37) Get Data From Table/Range on Mac Power Query
(1:18) Get Data From Folder on Mac Power Query
(2:43) Get Data from JSON or XML on Mac Power Query
(3:27) Wrap-up