Append Queries do now show in the Query Pane.

[DLamarche]

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.

[TomMartens · Accepted solution]

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

[mwegener · Accepted solution]

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.

[v-xuding-msft · Accepted solution]

Hi @DLamarche ,

As TomMartens said, you need to choose "Append Queries as New". There are two related blogs that you can reference to learn more.

Append vs. Merge in Power BI and Power Query 

Combine or Append Data in Power BI / Power Query: Main Concepts 

Best Regards,

Xue Ding

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

[v-xuding-msft · Accepted solution]

Hi @DLamarche ,

As TomMartens said, you need to choose "Append Queries as New". There are two related blogs that you can reference to learn more.

Append vs. Merge in Power BI and Power Query 

Combine or Append Data in Power BI / Power Query: Main Concepts 

Best Regards,

Xue Ding

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

[mwegener · Accepted solution]

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.

[TomMartens · Accepted solution]

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]

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 · Accepted solution]

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.