Forum Discussion
Error while refreshing a Dataset or a dataflow that use others dataflows as a source
Hi, since Friday (28-04-2023), we got similar issue with Datasets or Dataflows that use others Dataflows as a source. We try to reconnect. Still the same issue. This is an exemple for one of ...
Message on Microsoft PowerBI Support Page:
Power BI Dataflow customers connecting datasets via unified 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." As a workaround, users can do one of the following:
• Update the dataset to use an On Premises Data Gateway to refresh
• Refresh the dataset on Power BI Desktop and upload the refreshed dataset manually
• Use the legacy dataflow connector
• Set enhanced compute engine in dataflows to "OFF"
Engineers are actively working on a fix and they expect it to be deployed by end of day Monday (5/15).