Forum Discussion

Syndicate_Admin's avatar
Syndicate_Admin
Icon for Administrator rankAdministrator
4 years ago
Solved

Quickly 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 m...
  • v-janeyg-msft's avatar
    v-janeyg-msft
    4 years ago

    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's avatar
Syndicate_Admin
Icon for Administrator rankAdministrator
4 years ago

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

v-janeyg-msft's avatar
v-janeyg-msft
Icon for Community Support rankCommunity Support
4 years ago

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