Use Dataflow Gen2 to copy SQL Tables , every time need add new Data Source

[MichelleTW729]

I Use Dataflow gen2 meet 2 problems from Data connection. 

1. I already set gateway to connect on-prem SQL server , but when i use dataflow gen2 , get data

the connection options only show  "create new connection"

don't know why it can not find the exis connection (MichelleSQL) . for example below , 

2. from Dataflow Gen2 , if i need add other tables in the future I can't find which way can import from same data source ?

[Anonymous · Accepted solution]

Hi @MichelleTW729 ,

To your second question, to add other tables from the same data source in Dataflow Gen2 within Fabric Data Factory, you can follow these steps:

Open your existing Dataflow Gen2 in Fabric Data Factory.

In the Power Query editor, you can add new tables from the same data source by selecting the data source again and choosing the additional tables you need.

If you have any other questions please feel free to contact me.

Best Regards,
Yang
Community Support Team

If there is any post helps, then please consider Accept it as the solution  to help the other members find it more quickly.
If I misunderstand your needs or you still have problems on it, please feel free to let us know. Thanks a lot!

[Anonymous]

Hi @MichelleTW729 ,

I can't reproduce your problem, I performed a test of your same requirement and I can select the connection I already have in gateway.

This is my connection, please check that the server name and the database name entered when connecting to the data source in Dataflow is the same as configured in the connection.

If you have any other questions please feel free to contact me.

Best Regards,
Yang
Community Support Team

If there is any post helps, then please consider Accept it as the solution  to help the other members find it more quickly.
If I misunderstand your needs or you still have problems on it, please feel free to let us know. Thanks a lot!