Hoping I can get more details on things such as: Seeing as this was stated somewhere in 2019 it does make me curious to understand where Microsoft stands now in regards to further rolling out this functionality for MacOS. Looking at the amount of users voted for getting this feature fully supported on MacOS I am confident this is something that is continuously being worked on by Microsoft. Spending a week on researching the internet learned this functionality is not - yet - available for MacOS.įrom what I have been able to learn, the newest Excel 365 does offer the option to refresh existing queries - queries created on a Windows machine, though also learned according to Microsoft this is rather "phase 1" and we should expect more to come. More or less immediately ran into issues when trying to find the Get & Transform functionality on the MacOS - it simply was not there. That's what I do.Recently switched over from Windows to MacOS, not knowing the versions of Excel 365 for both the OSes are not the same. You really need a PC or run a virtual Windows machine on your Mac, e.g. But it's definitely not the way to learn PQ. Once, the VBA code is in place you can go modify it. Scroll down a bit and you'll see a caption on Authoring and transferring queries with VBA. When you Google for Power Query on the Mac, the first hit is probably this: You can refresh certain queries that were created on a PC, but you can't create or edit them on a Mac. You can connect to a workbook or a Text/CSV file and load it, but you can't do transformations. You want to get started with PowerQuery you need to use Excel for Windows, as PQ is not fully supported by Excel for he Mac.
0 Comments
Leave a Reply. |
AuthorWrite something about yourself. No need to be fancy, just an overview. ArchivesCategories |