Forum Discussion
Add missing tables from data source to existing dataset
when you first connect and select multiple tables each table is actually created separately, the easy way to edit it is to go to Query editor
the easiest way to add new table is to add new data source (no need to go to Query Editor at all). I think you will see all the tables there, so you could possibly load the same table twice, but that's easy to fix
I think so, I didn't use the data gateways much
you can see the dependencies in the query editor, inthe View TabI expect you to see your DW at the top with arrows pointing to multiple tables (regardless whether they were created in the begining or added later)
You can review the M code that got generated for different tables in Advanced Editor in the Home tab, so you can compare it for the original and added tables - top 2 rows should be identical (if it's all same database)
you just create a new query as a connection to SQL Server and you will have the same interface again
StachuHi. How do you create a new one? Presumably it is in Edit Queries, but I can only see how to modify an existing one.
Is there no easy way to see which tables I haven't imported?
Chris
when you first connect and select multiple tables each table is actually created separately, the easy way to edit it is to go to Query editor
the easiest way to add new table is to add new data source (no need to go to Query Editor at all). I think you will see all the tables there, so you could possibly load the same table twice, but that's easy to fix
Thanks for replying. Does this mean I would have two datasets, as forum posts suggest this can increase refresh issues?
Thinking about it, it just sounds easier to duplicate an existing query, and then modify it to import from a different table. It does seem like a bit of a long winded way though. I might make a suggestion on Power BI ideas.
Chris
