Forum Discussion
TonyMcA
9 years agoFrequent Visitor
Adding in new tables from same datasource
Hi, I've had an existing Powerr BI dataset/reports/dashboard working fine. Then I've wanted to add in some tables from an existing datasource that I didn't include first time around, So I've ...
- 9 years ago
You should be able to use the Advanced Editor in Power Query to add in your tables to your original query if you are doing some joins and such between tables. However, generally when you connect to a data source and add multiple tables, each table becomes its own query, so connecting to it again and selecting different tables would end up the same as if you had selected those tables when you originally connected. I guess it depends on your use case. But, if you edit your queries and each table is its own query, then it shouldn't matter at all.
Yasir
8 years agoNew Member
An easy way
Let's assume:
The name of your current Appended Query is AQ1. New Table to be appended is NT1
Make a new query-"connection only" for NT1
Append the NT1's query with AQ1.