Bug - Power BI Dataflow with connection to other Power BI data flow fails in refreshing

[Kemei]

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".

[kevingauv]

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-oth...

[v-xiaoyan-msft]

Hi @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]

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-oth... 

[Joshrodgers123]

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. @v-xiaoyan-msft - can you please provide an update?

[kevingauv]

Hi, we still experiencing the same issue today (from a dataflow), with same error code.

@v-xiaoyan-msft - 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étails

DataSourceKind = PowerPlatformDataflows

DataSourcePath = PowerPlatformDataflows

Message = 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 = -2146232060

Number = 53

Class = 20

[v-xiaoyan-msft]

Hi all,

The issue has been fixed，now this thread will be closed.

Best Regards,
Community Support Team _ Caitlyn