Forum Discussion

DLamarche's avatar
DLamarche
Icon for Helper I rankHelper I
6 years ago
Solved

Append Queries do now show in the Query Pane.

Hello all. I am a bit new to BI but I love it.

I am following a great book from Packts. At some point we are creating an Append query with three other queries (January, February and March). The queries are perfectly correct to be appended. Only the Month differs.

In the Append dialog box, in the Table to append list I have:

January (Current)

February

March

 

Once completed the book says that the result should be a new query called Append1. There are other steps I am suppose do with the query. It adds: This new query should consist of a single step, Source. The Formula Bar should display:

= Table.Combine ({January, February, March})

Problem is that the query Append1 never appears. There is nothing new in the Queries Pane. Tried it 3 times. So I am having trouble continuing the tutorial. I thought of entering the M code above in a New Query and it works but the name was different. Still that allowed me to continue with the book.

I looked at YouTube videos on Append Queries in Power BI that did show Append1 but other video did not.

Please someone enlighten me regarding this. If I didn't have that M code I would not be able to finish the Tut.

I am currently using: Version: 2.75.5649.861 64-bit (November 2019)

I am appreciative of the time one can take to comment on my question.

 

Daniel Lamarche

Below is my Queries pane after the Append query is created. There is no Append1 query.

My Queries Pane after the Append Query is created.

  • Hey DLamarche welcome to Power BI,

     

    I'm wondering if you are using "Append as new"

    Hopefully this is the missing the link.

     

    Regards,

    Tom

  • DLamarche's avatar
    DLamarche
    6 years ago

    Well gentleman, I'll give all of you a 10 out of 10 for your clever reply.

    I spent over 1 hours repeating the tutorial in the book with various dummy datasets from Excel and never got an Append1 query.

    Thanks you alot for helping me. My faith in this blog went up by a quite some notches. 😎

     

    Very grateful for your time.

5 Replies

  • Hey DLamarche welcome to Power BI,

     

    I'm wondering if you are using "Append as new"

    Hopefully this is the missing the link.

     

    Regards,

    Tom

    • DLamarche's avatar
      DLamarche
      Icon for Helper I rankHelper I

      Well gentleman, I'll give all of you a 10 out of 10 for your clever reply.

      I spent over 1 hours repeating the tutorial in the book with various dummy datasets from Excel and never got an Append1 query.

      Thanks you alot for helping me. My faith in this blog went up by a quite some notches. 😎

       

      Very grateful for your time.

    • DLamarche's avatar
      DLamarche
      Icon for Helper I rankHelper I

      Well gentleman, I'll give all of you a 10 out of 10 for your clever reply.

      I spent over 1 hours repeating the tutorial in the book with various dummy datasets from Excel and never got an Append1 query.

      Thanks you alot for helping me. My faith in this blog went up by a quite some notches.

       

      Very grateful for your time.

  • mwegener's avatar
    mwegener
    Icon for Most Valuable Professional rankMost Valuable Professional

    Hi DLamarche ,

     

    i think TomMartens is right.

    In case of emergency you can start with a "Blank Query" and enter your M code in the formula bar.

     

    An interesting alternative is described here as point 5.

    https://www.youtube.com/watch?v=Fih7966UJY8&feature=youtu.be

     

    If I answered your question, please mark my post as solution, this will also help others.

    Please give Kudos for support.