Forum Discussion
Missing tables from Dataflow
Hi,
I have recently created a dataflow, I did not want to bring every table across from my SQL source as there was hundreds.
What is the easiest way to be able to add another table in from the same datasource already generating the other tables?
I was worried adding the same SQL datasource again would duplicate the datasources? i ideally want to be able to go back to the navigator and select another couple of tables on top of the ones I have, is anything like that possible?
You wanted to add another table in same Dataflow, below are 3 easy steps
1. Copy paste existing table
2. Delete all the steps after navigation3. change the table name in navigation step
Adding new table will not duplicate your data source.
If this post helps, then please consider Accept it as the solution and give it a thumbs up
2 Replies
You wanted to add another table in same Dataflow, below are 3 easy steps
1. Copy paste existing table
2. Delete all the steps after navigation3. change the table name in navigation step
Adding new table will not duplicate your data source.
If this post helps, then please consider Accept it as the solution and give it a thumbs up
Hi MYVFD ,
Reconnect the sql source and select the table you need:
Below is a reference if needed.
https://docs.microsoft.com/en-us/power-bi/connect-data/service-gateway-sql-tutorial
Best Regards,
KellyDid I answer your question? Mark my post as a solution!
