Dataflow with multiple sources - single source failure

[SolutionsWith]

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 that error and still allow the data to refresh in the data flow when just 1 source fails?

A little more context is that the failure is caused when a sql database doesnt respond. The issue is the DB capacity at the exact time this refresh query hits it

[Kostas_pbix]

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.

[lbendlin]

read about try...otherwise...  features in Power Query.

You can also consider breaking your dataflow into smaller pieces.  There is no harm in having multiple dataflows feeding your dataset.