Forum Discussion

UY-SCUTI's avatar
UY-SCUTI
Copper Contributor
Feb 13, 2021
Solved

Excel 365 for Mac - Get & Transform/Power Query functionality

    Hi Dears,   Recently switched over from Windows to MacOS, not knowing the versions of Excel 365 for both the OSes are not the same. More or less immediately ran into issues when trying to fin...
Excel on Mac
power bi
  • Riny_van_Eekelen's avatar
    Riny_van_Eekelen
    Feb 13, 2021

    UY-SCUTI I went the opposite way. A long time Mac user, realising that Excel for Mac wasn't really living up to my needs. I had an MS365 Business subscription that allowed me to install the full Office package on up to 5 PC's and/or Macs, plus a bunch of mobile devices. I bought Parallels and W10 and happily run the full Excel version on a virtual Windows machine, on one of my Macs, a rather old MacBook Pro. Works good enough for me. If you have a newer Mac, it's going to run even better, I suspect. At the same time, running Excel on two more Macs and a Huwawei laptop (all under the same subscription), though with the limited functionality (as you recently discovered) on both Macs.

Inbar_Privman's avatar
Inbar_Privman
Icon for Microsoft rankMicrosoft
May 26, 2021

UY-SCUTI 

Just wanted to let you know that we released another phase, and you can now import data from local files with Power Query in Excel for Mac! For more information please see this announcement.

  • AlainL123's avatar
    AlainL123
    Copper Contributor
    Apr 02, 2022

    Inbar_Privman 

    It's now been nearly a year since the last update on this topic. The import from web feature still requires us to go through the Word document voodoo, saved as txt, renamed to .iqy, only to get the Basic import features from Windows.

     

    We can still not transform the data, select the columns to import into a table, set the data type, etc.

     

    We cannot use the advanced functions to log in using an API.

     

    I know that MacOS is a competitor to Windows, but when I buy Office, I expect to get Office. Not a milked down version of it. It's the same with OneNote and PowerPoint..

Resources