Forum Discussion
Transform multiple queries at once
Yes, trick is to get a "table-view" of all your DB-tables where you can add a column. See how this works for a SQL-DB here:
The code as a function you can find here: https://gist.github.com/ImkeF/7f4fca8f7a7334d7fe7fb1ec761711da
Yes, trick is to get a "table-view" of all your DB-tables where you can add a column. See how this works for a SQL-DB here:
The code as a function you can find here: https://gist.github.com/ImkeF/7f4fca8f7a7334d7fe7fb1ec761711da
Thanks ImkeF this is great. Is there a way to output the db-tables to different tables in power query? i.e. having one pquery query per db table
Not with this additional transformation, unfortunatly.
The only way to create one query per table is through the steps via the manual UI where you click each table and one query will be created for each of them.
what if there's no transformation? i.e. is there a way to bring all the tables from the db into different pquery queries?