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
Community SupportHi, 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
AdministratorI 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