Hello,
Is this still the case? Microsoft has recently updated to allow a full refresh in Excel for Mac, workbooks with Power Query queries can now be refreshed. I still can't refresh my workbook though, a popup appears asking me to rebuild the data combination.
This only happens on Mac, is there something I'm missing?