Earn a 50% discount on the DP-600 certification exam by completing the Fabric 30 Days to Learn It challenge.
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
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.
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.