Forum Discussion
Append queries dynamically in Power Query
Hi all,
A little background of this request:
- The tables in "Sales Batch" query folder are created from querying my Postgresql database
- Due to performance issues, the best way is to break the queries down in chunks like this instead of setting an open-ended condition in my query like
WHERE date >= '2017-01-01'
With this, I can foresee myself updating the queries in case Sales_Y2020 gets too large and start giving performance issues again. So, I might potentially need to break the queries down further. That said, when I append the tables together in "Sales" from "Other Queries" query folder, I need to manually configure them as per the red box below.
Is there a way for Power Query to dynamically append these tables together in "Sales" from "Other Queries"?
Thanks
17 Replies
Alex_Ooi , refer if this can help https://radacad.com/append-vs-merge-in-power-bi-and-power-query
Hi Alex_Ooi
#sections can probably work for you
Take a look at https://radacad.com/get-list-of-queries-in-power-bi
Please mark the question solved when done and consider giving kudos if posts are helpful.
Cheers
You could extract the list of queries you are interested in using #sections and then build the full expression on a string and use
Please mark the question solved when done and consider giving kudos if posts are helpful.
Cheers
