The server was not found or was not accessible.

[ramiro_gonzalez]

Suddenly, when refreshing the dataflow that loads data into a warehouse, I get the following error. It won’t let me load tables into the warehouse and says it can’t connect to the SQL Server instance of the warehouse.

Does this happen to anyone else? Do you know this error? Thanks so much for your help!

 ERROR:

Estudio_WriteToDataDestination: There was a problem refreshing the dataflow: 'Couldn't refresh the entity because of an issue with the mashup document MashupException.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) Details: Reason = DataSource.Error;ErrorCode = 10478;DataSourceKind = Warehouse;DataSourcePath = Warehouse;DataSourceKind.2 = SQL;DataSourcePath.2 = *********.fabric.microsoft.com;Data Warehouse;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;State = 0;Microsoft.Data.Mashup.Error.Context = User'. Error code: Mashup Exception Data Source Error. (Request ID: f0868393-3015-46b0-bcf0-95083000d7ca).

[Timbaaaal]

Looks like its fix now.

[belkov78]

Yes, it looks like everything is back to normal indeed. 

[mesallam]

same issue!

[CSF]

I have the same errors today on my dataflows to Data Warehouse in Fabric. I can't find the cause. I had this same problem on October 20th I believe. All day, I could find no cause and everything worked as usual the next day.

This could be related... Microsoft 365 down? Current problems and outages | Downdetector

[belkov78]

Same for me; in 4 different workspaces in our company, dataflows with more than a couple of queries will fail miserably and on seperate steps with the same error.

Very frustrating.

[coverturfLSH]

Having the same issue trying to refresh a desktop powerBI file pulling from a Fabric warehouse. 

[ecaldwell]

Same issue!!

[robertostaino]

Same issue, lemme know if you find a solution.

[Timbaaaal · Accepted solution]

Microsoft just updated their status page
https://support.fabric.microsoft.com/en/support//

Service Outage/Degradation

Fabric customers may experience issues with Dataflow Gen2 refreshes. Engineers are investigating the issue, and an update will be provided soon.

[AdeV-Oly]

Temporary solution: click on 'Refresh now'. Might take an attempt or two.

[JFTxJ]

Same for us.  We opened a Ticket with MS.  I suggest you do the same.  The more support tickets we open the faster we will get support from MS.

[AdeV-Oly]

Same issues as of today. Dataflows worked fine before the weekend.

[Timbaaaal]

Same issue, all my dataflow gen 2 pulling data from and to Lakehouse/Warehouse are failing.. everything was working fine before today.

3rd time in approx 4 month that I have dataflow gen 2 getting major outage for 24h+ in production workspace, without even clear communication from Microsoft. This really make me secound thought my move from PPU to Fabric.. clearly cannot have critical solution depending on this.