Skip to main content
cancel
Showing results for 
Search instead for 
Did you mean: 

Find everything you need to get certified on Fabric—skills challenges, live sessions, exam prep, role guidance, and more. Get started

Reply
DLamarche
Helper I
Helper I

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.My Queries Pane after the Append Query is created.

4 ACCEPTED SOLUTIONS
TomMartens
Super User
Super User

Hey @DLamarche welcome to Power BI,

 

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

image.png

Hopefully this is the missing the link.

 

Regards,

Tom



Did I answer your question? Mark my post as a solution, this will help others!

Proud to be a Super User!
I accept Kudos 😉
Hamburg, Germany

View solution in original post

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.

blank_query.png

Combine.png

 

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.

Did I answer your question?
Please mark my post as solution, this will also help others.
Please give Kudos for support.

Marcus Wegener works as Full Stack Power BI Engineer at BI or DIE.
His mission is clear: "Get the most out of data, with Power BI."
twitter - LinkedIn - YouTube - website - podcast


View solution in original post

v-xuding-msft
Community Support
Community Support

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.

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.

View solution in original post

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.

View solution in original post

5 REPLIES 5
v-xuding-msft
Community Support
Community Support

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.

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.

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.

blank_query.png

Combine.png

 

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.

Did I answer your question?
Please mark my post as solution, this will also help others.
Please give Kudos for support.

Marcus Wegener works as Full Stack Power BI Engineer at BI or DIE.
His mission is clear: "Get the most out of data, with Power BI."
twitter - LinkedIn - YouTube - website - podcast


TomMartens
Super User
Super User

Hey @DLamarche welcome to Power BI,

 

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

image.png

Hopefully this is the missing the link.

 

Regards,

Tom



Did I answer your question? Mark my post as a solution, this will help others!

Proud to be a Super User!
I accept Kudos 😉
Hamburg, Germany

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.

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.

Helpful resources

Announcements
Europe Fabric Conference

Europe’s largest Microsoft Fabric Community Conference

Join the community in Stockholm for expert Microsoft Fabric learning including a very exciting keynote from Arun Ulag, Corporate Vice President, Azure Data.

Power BI Carousel June 2024

Power BI Monthly Update - June 2024

Check out the June 2024 Power BI update to learn about new features.

RTI Forums Carousel3

New forum boards available in Real-Time Intelligence.

Ask questions in Eventhouse and KQL, Eventstream, and Reflex.