Forum Discussion

TF_123's avatar
TF_123
New Member
4 years ago
Solved

Power Query Compatibility Warning and missing in Excel 2016

I have installed Microsoft Office Professional Plus 2016 (Version: 16.0.4266.1001), but it cannot open Power Query and shown below image. It just open as Query Editor but not Power Editor. Query Edit...
Need Help
  • Anonymous's avatar
    Anonymous
    4 years ago

    Hi TF_123 ,

     

    My Microsoft Excel version is Excel 2016:

     

     

    Best Regards,
    Eyelyn Qin
    If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.

BA_Pete's avatar
BA_Pete
Super User
4 years ago

Hi TF_123 ,

 

Silly question, I'm sure, but have you tried opening PQ using the Get Data button on the Data tab?

 

 

Pete

  • TF_123's avatar
    TF_123
    New Member
    4 years ago

     

     Thanks for your reply. But it did not appear on my Excel.

    • BA_Pete's avatar
      BA_Pete
      Super User
      4 years ago

       

      Hm, ok.

       

      Mine's Version 2206 Build 16.0.15330.20216 64-bit.

      Are you able to find and dowload a more advanced version? If you've downloaded your Excel from the native O365 prompt, then your current licence may not allow you the most up-to-date or advanced version.

       

      Pete

      • TF_123's avatar
        TF_123
        New Member
        4 years ago

        Hi Pete, there is no Update button here. 🙁