Forum Discussion
Dataflow with multiple sources - single source failure
Hi, I have a dataflow that has many seperate datasources sometimes 1 of the 12 data sources fails to load into the dataflow which causes the whole dataflow to fail. Is there a way i can catch tha...
I face a similar problem.
One data source is Azure sql database and the other Azure synapse sql database. The first has basic authentication the second is with gateway.
When I import to dataflow the tables from each after saving an reopening the dataflow the Azure sql data base fails to respond getting back "A network-related or instance-specific error occurred while establishing a connection to SQL Server"
I will combine two different dataflows to resolve this, but I need to check if there is another workaround.