Quickly add new queries in Power Query BI

[Syndicate_Admin]

Hello, someone has an idea of how you could add new queries in a faster way, without having to go from one to one... I am loaded the xq sheets I plan to append them but apparently PB does not allow me to append if they are not loaded as new queries. could anyone help me?

[Syndicate_Admin]

The question is not focused on that!

What I want is to avoid loading the queries as it has green and then do the red color. my question is if I can append the queries without having to add them (Green color), I want to append them directly, I have many approximate 40 sheets with the same # of columns and I want to append them to use 1 a query.

[v-janeyg-msft · Accepted solution]

Hi, @Syndicate_Admin 

The dynamic method is shared by the link above.

You need to add a step in advanced editor:

Using formula in pq:

CombineTable= Table.Combine(Source[Data])

It involves privacy, so I can only take screenshots step by step. Here is my sample:

Did I answer your question? Please mark my reply as solution. Thank you very much.
If not, please feel free to ask me.

Best Regards,
Community Support Team _ Janey

[Syndicate_Admin]

I would say you are a crazy my friend, this is what I needed.. although I see that the names of the columns were changed to an additional one followed by DATA. Column Name. is there a way to fix this?

[v-janeyg-msft]

Hi @Syndicate_Admin 

I think that should be automatic, because you merge by custom code, It needs to distinguish different columns. If you mind, it needs to be modified manually.

If you have problem, Please take a screenshot and feel free to ask me.

Best Regards,

Community Support Team _Janey

[amitchandak]

@Syndicate_Admin , Duplicate and change table name or sheet name in advance editor, option on the right click of table

[Syndicate_Admin]

This in turn would be rework, I imagine that I now have 50 project tables and 50 of costs I should do 100 change 😞 actions

[ValtteriN]

Hi,

These queries can be added quite fast by right-clicking a "cell" and selecting add as new query or perhaps in this case the best option is to skip this and use Table.Combine(Source[Data]) as a step. This will create an appended table.

I hope this post helps to solve your issue and if it does consider accepting it as a solution and giving the post a thumbs up!

My LinkedIn: https://www.linkedin.com/in/n%C3%A4ttiahov-00001/

[Syndicate_Admin]

Can you show an example? I need each table to be appended one after another so that in the dax model and applications I can use a single data query.

[ValtteriN]

I found a post describing what I meant with table.combine: https://community.powerbi.com/t5/Desktop/Power-Query-Dynamically-Append-from-Table-of-Tables/m-p/960...

[Syndicate_Admin]

I couldn't do it you can show a video doing the procedure?

[v-janeyg-msft]

Hi, @Syndicate_Admin 

You can try this in PQ:

Did I answer your question? Please mark my reply as solution. Thank you very much.
If not, please feel free to ask me.

Best Regards,
Community Support Team _ Janey