Join us at FabCon Atlanta from March 16 - 20, 2026, for the ultimate Fabric, Power BI, AI and SQL community-led event. Save $200 with code FABCOMM.
Register now!Calling all Data Engineers! Fabric Data Engineer (Exam DP-700) live sessions are back! Starting October 16th. Sign up.
We have a number of Dataflows which connect to a DataMart. The Dataflows have been working without too many issues so far for a number of months. This week, we needed to move a Dataflow to a different workspace (as part of a workspace consolidation) and have been unable to reconnect the Dataflow to the DataMart.
We have since tried recreating it from scratch as opposed to the JSON import, but we're also unable to connect any new Dataflows to our DataMart. We get the following error:
Microsoft SQL: A network-related or instance-specific error occurred while establishing a connection to SQL Server. The server was not found or was not accessible. Verify that the instance name is correct and that SQL Server is configured to allow remote connections. (provider: Named Pipes Provider, error: 40 - Could not open a connection to SQL Server)
Our other Dataflows that we have not gone into to either edit or move are still working without any issues so we're stumped and starting to think it's a wider infrastructure issue?
Any help would be greatly appreciated!
You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.