Forum Discussion

Kundan1275's avatar
Kundan1275
Copper Contributor
Apr 30, 2022

Power query for Mac

In my MS excel, the GET DATA power query button missing, how can I get it please help
  • Adin_Calkic's avatar
    Adin_Calkic
    Apr 30, 2022

    Hi Kundan1275 ,

     

    Make sure your Excel is up to date. Data Query should be in Data tab. see below.

     

     

Jaitaps's avatar
Jaitaps
Copper Contributor
Hi. Even though i have installed the latest version available for excel i.e. 16.62 but still i can't find the power query in the data tab. There is a tab of Get external data but i can't import data from a URL as the option of the same is not there. pls help
JimGMac's avatar
JimGMac
MVP
Jun 30, 2022

Jaitaps The latest beta channel version is 16.64.  Here is a screen shot of the connectors available to SOME beta channel testers. Keep in mind that not all beta channel testers are provided with every new feature as it is being tested. There is usually a control group that does not get the new features.

 

 

  • Jaitaps's avatar
    Jaitaps
    Copper Contributor
    Jul 01, 2022
    JimGMac Thanks for your prompt reply. Unfortunately, for me only 3 options i.e. From text, from HTML and from database is available which is not resolving my purpose. Basically i wanted to link a database from a website into excel and all the tutorials on youtube show either power query or from table as the option to do the same. is there any way i can do this in my excel?
  • Chris_BWC's avatar
    Chris_BWC
    Copper Contributor
    Jul 02, 2022

    JimGMac 

     

    I am having a similar issue. Can see Power query and can connect .csv however, can not access 'launch power query editor'

    I am on 16.64

  • JimGMac's avatar
    JimGMac
    MVP
    Jul 05, 2022

    Chris_BWC Here are the steps to take:

     

    1. On the Data tab of the Ribbon, click the Get Data (Power Query) button
    2. In the file browser, select the csv file you wish to use and then click the Get Data button
    3. In the resulting dialog click the Next button
    4. In the Preview file data dialog click the Transform Data button in the lower right corner

     

    The PowerQuery editor will then display.

  • Morkus2Office's avatar
    Morkus2Office
    Copper Contributor
    Jul 07, 2022

    There is no "Transform Data" button shown in lower right corner. The only buttons displayed are: "LOAD" and "CANCEL"

     

    The Transform data button is totally missing.

    I've also tried using the preview channel.

    My version of Excel 365 is 16.64 (latest version as of 2022-07-06).

    ---

    Would appreciate any ideas how to get this feature to work without having to start Windows...

  • JimGMac's avatar
    JimGMac
    MVP
    Jul 07, 2022
    Hi again

    Is your Mac OS system set to US English? I don't think localizations of the editor have rolled out yet.
  • Morkus2Office's avatar
    Morkus2Office
    Copper Contributor
    Jul 08, 2022
    Yes.
    Any idea when Transform Data will be available on Mac?
    Thanks
  • JimGMac's avatar
    JimGMac
    MVP
    Jul 08, 2022

    Morkus2Office 

     

    Transform Data is now available to Office 365 subscribers who have current updates installed. It may require a specific license type and US English as the system language. 

  • Morkus2Office's avatar
    Morkus2Office
    Copper Contributor
    Jul 10, 2022
    Yes, I have US English, and the latest version of Excel 365 (16.64). But as I've said above, there is NO Transform data shown. It's just CANCEL LOAD. That's all.
    It's weird you have different functionality. I guess I need to open a trouble ticket with MS.
  • Morkus2Office's avatar
    Morkus2Office
    Copper Contributor
    Jul 10, 2022
    I also have a business 365 license.
    Let me know how your license, version, installed language, or whatever could be (or is) different.
    Thanks,

Resources