Does this work on a Mac?

In short no. Unlike on Windows, PowerQuery in Excel for Macs does not currently support APIs as a data source for PowerQuery. For over two years Microsoft has been saying this is coming, but they have set no roadmap or time expectations.