Ernest
My feedback
-
2 votes
Ernest shared this idea ·
-
3,540 votes
We are pleased to announce that the first set of Power Query features are now available in version 16.29 and greater. At this stage you can refresh from text, CSV, XLSX, JSON and XML files.
Refer to the following blog post for more details:
https://techcommunity.microsoft.com/t5/Excel-Blog/Get-amp-Transform-Power-Query-in-Excel-for-Mac-Phase-1/ba-p/876840I encourage you to try the new functionality and share your feedback with us via Send a Smile/Frown at the top right corner in your Excel for Mac.
I'm trying to get external data from the web in office 2019 office on a mac. I have saved a plain test web query but when I run it I don’t nt get the data I want upload but instead d the hyperlink address in A1.