Missing tables from Dataflow

[MYVFD]

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? 

[v-kelly-msft]

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,
Kelly

Did I answer your question? Mark my post as a solution!

[arvindsingh802 · Accepted solution]

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 navigation

3. 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