Forum Discussion
AdministratorQuickly add new queries in Power Query BI
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
AdministratorThe 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?
- v-janeyg-msft
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