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".
on:
Unable to feed on-premises SQL-Server data into La...
v-yetao1-msft
on:
Alt Key Shortcuts Causing Problems
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