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 q...
Hi Alex_Ooi ,
instead of creating single queries for each of them, create a table with one row for each of them.
Then expand out the result column. No need to append anything.
Start from a table with parameters and add a column that grabs the data with a function.
Hi ImkeF thanks for your advice. I am stuck in two parts tho;
- What should I do once I have created a parameter? I left all default settings, and wrote "Sales_" as my current value in the parameters.
- What function(s) should I use to create a table with one row for each of the table, since #sections can't do the trick for me?
Looking forward to hearing from you. Thanks.