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 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
2 Replies
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.
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.
