Transform multiple queries at once

[Matjo]

Hi, 

I have 60 queries for different tables. I want to apply the function Table.FirstN to all of them. 
I tried selecting all and using the function Keep Rows but it only affected one query. 

Is there an easy way to add an additional step to all of the queries that keeps the first 100 rows.

Best regards,
Mattias

[ImkeF · Accepted solution]

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

[Anonymous]

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

[ImkeF]

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.

[Anonymous]

what if there's no transformation? i.e. is there a way to bring all the tables from the db into different pquery queries?

[ImkeF]

Yes, if you import from SQL-Server for example, you will be presented a UI like this:

for every table or view you check here, a seperate query will be created.

[Anonymous]

thanks @ImkeF. what if i don't wanna select them manually? is there a way to write a script that'll do that for me?