Forum Discussion
AdministratorQuickly add new queries in Power Query BI
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?
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
11 Replies
- ValtteriN
Community Champion
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_AdminCan 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/96001
- amitchandak
Super User
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
- 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
Community Support
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?
