Advocate IBug - Power BI Dataflow with connection to other Power BI data flow fails in refreshing
Created a Power BI Dataflow with the connection to other existing Power BI data flow using "Dataflow" connector, worked in the editing, but failed in refreshing once saved it.
Switched the connector from "Dataflow" to "Power BI Dataflow (Legacy)" and worked.
Dataflow connector has the issue with connecting to other Power BI dataflow when refreshing data. The refresh error message was
"Error: Data Source Error : DataSource.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) DataSourceKind = <ccon>PowerPlatformDataflows</ccon> DataSourcePath = <ccon>PowerPlatformDataflows</ccon> Message = <ccon>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".
6 Comments
kevingauvAdvocate III
Hi, we got the same issue, with several other persons it seems.
I post my original thread in the wrong channel I think...
This is my original post about that:
https://community.powerbi.com/t5/Service/Error-while-refreshing-a-Dataset-or-a-dataflow-that-use-others/m-p/3228471#M195614Hi Kemei ,
Power BI Dataflow customers connecting datasets via Dataflow connector might experience refresh failures with an error message saying, "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."
We have seen on the internal platform that other engineers have reported this issue and submitted it.
The engineers on the product team are now aware and will do their best to resolve the issue. I will update here if there is any progress, so please be patient.Best regards.
Community Support Team_Caitlyn- Eliasaki92
Advocate II
Hi there,
Any news on this topic?
This is a serious issue and the workarounds are not effective/working. I have seen in another threat that the issue should be resolved yesterday? Can you please confirm?
https://community.powerbi.com/t5/Service/Error-while-refreshing-a-Dataset-or-a-dataflow-that-use-others/m-p/3218669/highlight/true 
Joshrodgers123Kudo Collector
The issue is no longer showing on the Power BI Support site and it said it was supposed to be resolved yesterday. I am still getting the error now and it is causing many issues through our organization. Anonymous - can you please provide an update?
- kevingauv
Hi, we still experiencing the same issue today (from a dataflow), with same error code.
Anonymous - can you please provide an update?
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)DétailsDataSourceKind = PowerPlatformDataflowsDataSourcePath = PowerPlatformDataflowsMessage = 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)ErrorCode = -2146232060Number = 53Class = 20
