import live data from web
transfer online data to excel just like in windows version
Mark Longstreath commented
This should be a priority. I have created files that access web based data on a PC, but when trying to update on my Mac, it wont connect. This has to be made a priority as not to have this cross platform basic data function maked power query pretty useless for both platforms.