Forum Discussion

Anonymous's avatar
Anonymous
Not applicable
7 years ago
Solved

Missing Options For Append Query

Hi there,

 

I'm SUPER new to power BI, and I've been going through some tutorials. One thing I have noticed is that my interface seems to be missing some pieces that I am seeing in the tutorials. The one that I am currently looking for is The dropdown options in the query editor for "Append Queries". The tutorial I am working on calls for me to use "Append Query As New", but I don't have this option available in my interface. There is no dropdown beside "Append Queries" as is shown in the tutorial. Is there something I need to do to enable these features? 

 

Thank you!

 

 

Need Help
  • Anonymous's avatar
    Anonymous
    7 years ago

    That is interesting. Thought maybe if you dont have any tables the dropdown wouldnt be there, but it is... Maybe try updating PBI, the lateste version is:

    Version: 2.66.5376.2521

     

    Also, do you have the same problem when looking at the query editor in excel?

5 Replies

  • Anonymous's avatar
    Anonymous
    Not applicable
    7 years ago

    Should just be there.. can you take a screenshot and list out what you are using ( excel, pbi, etc) ?

  • Anonymous's avatar
    Anonymous
    Not applicable
    7 years ago

    Hi Nick,

    Sure, here is my ribbon in the query editor:

     

    I'm working in powerBI Desktop version  2.29.4217.341

     

    the data I'm using is from excel. Currently I am just referencing 2 different excel files, with pretty simple data, just to get a feel for things:

     

    Thanks!

    • Anonymous's avatar
      Anonymous
      Not applicable
      7 years ago

      That is interesting. Thought maybe if you dont have any tables the dropdown wouldnt be there, but it is... Maybe try updating PBI, the lateste version is:

      Version: 2.66.5376.2521

       

      Also, do you have the same problem when looking at the query editor in excel?

      • Anonymous's avatar
        Anonymous
        Not applicable
        7 years ago

        I'll see if I can get my IT to update it for me. It seems to work in excel. I at least get the options to specify multiple talbes, which I haven't been able to get in powerBI.