Register now to learn Fabric in free live sessions led by the best Microsoft experts. From Apr 16 to May 9, in English and Spanish.
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?
Solved! Go to 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
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
Covering the world! 9:00-10:30 AM Sydney, 4:00-5:30 PM CET (Paris/Berlin), 7:00-8:30 PM Mexico City
Check out the April 2024 Power BI update to learn about new features.
User | Count |
---|---|
113 | |
97 | |
85 | |
70 | |
61 |
User | Count |
---|---|
151 | |
121 | |
104 | |
87 | |
67 |