Add more tables from same datasource

[Anonymous]

I initially added 3 tables from a database from a datasource X, this database has more tables and i want to add some more without adding another data source, How can i do this?

[Stachu · Accepted solution]

you can do the following:

1) duplicate one of existing tables (right click on the query, press Duplicate)

2) in the View ribbon enable Query Settings

3) it will open a pane on the left - you can then go through the steps displayed there and navigate to a different table

In general with databases I would recommend to have a single connection query (basically just the Source step), that's not loaded to the model (1), and all the other queries reference that connection query and navigate to specific tables (2)

this way when you have to e.g. switch from Prod to QA you just need to change the 1 connection query, rather than all of them