Power Query 2016 - Missing Options - Merge dropdown - Joins
Results 1 to 5 of 5

Thread: Power Query 2016 - Missing Options - Merge dropdown - Joins
Thanks Thanks: 0 Likes Likes: 0

  1. #1
    New Member
    Join Date
    Mar 2019
    Posts
    8
    Post Thanks / Like
    Mentioned
    0 Post(s)
    Tagged
    0 Thread(s)

    Default Power Query 2016 - Missing Options - Merge dropdown - Joins

    Hi Everyone,

    I am using Microsoft Office Professional Plus 2016 and Inoticed I am missing some features inside of Power Query. I came across some ofthe missing features while attempting to merge two tables. The merge button inthe queries button does not have the drop down feature to allow the option tomerge as new or merge to the existing query. If I click the merge button I doget the pop up window, however the join section is also missing. There is onlya match option check box to click. Inside the Query options section, underGlobal, the Power Query Editor tab is missing. It only shows Data Load,Security, Account, and Diagnostics.

    I am not sure whatother features may be missing but I could use some suggestions on what to checkand how to enable the missing option. MS help suggested to check off PowerQuery for excel in the com add-ins, however this option did not exist.

    Thank You

  2. #2
    Board Regular sandy666's Avatar
    Join Date
    Oct 2015
    Posts
    2,680
    Post Thanks / Like
    Mentioned
    27 Post(s)
    Tagged
    1 Thread(s)

    Default Re: Power Query 2016 - Missing Options - Merge dropdown - Joins

    IMHO try Repair Office before re-install
    I know you know but I forgot my Crystal Ball and don't know what you know



    In the first post, show the type of machine (PC / Mac) and the Office version you are working on
    impossible things we do on the spot. for miracles you need to wait for a while

  3. #3
    New Member
    Join Date
    Mar 2019
    Posts
    8
    Post Thanks / Like
    Mentioned
    0 Post(s)
    Tagged
    0 Thread(s)

    Default Re: Power Query 2016 - Missing Options - Merge dropdown - Joins

    Do we think this is more of a bad install issue than a disabled option issue?

  4. #4
    Board Regular sandy666's Avatar
    Join Date
    Oct 2015
    Posts
    2,680
    Post Thanks / Like
    Mentioned
    27 Post(s)
    Tagged
    1 Thread(s)

    Default Re: Power Query 2016 - Missing Options - Merge dropdown - Joins

    you cannot disable Get&Transform because it's build-in and there is no any option to disable elements of that. (like in the post#1)

    but you can try to find whatever you want it's up 2 u

    is there any problem to try to repair office???
    Last edited by sandy666; Mar 22nd, 2019 at 09:03 AM.
    I know you know but I forgot my Crystal Ball and don't know what you know



    In the first post, show the type of machine (PC / Mac) and the Office version you are working on
    impossible things we do on the spot. for miracles you need to wait for a while

  5. #5
    New Member
    Join Date
    Mar 2019
    Posts
    8
    Post Thanks / Like
    Mentioned
    0 Post(s)
    Tagged
    0 Thread(s)

    Default Re: Power Query 2016 - Missing Options - Merge dropdown - Joins

    The problem is now fixed. There was a knowledge based update for power query. Once that was updated the missing options show up.

    Thank You

Some videos you may like

User Tag List

Tags for this Thread

Like this thread? Share it with others

Like this thread? Share it with others

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts
  •