Unable to connect to Gen2 Dataflows from Power BI Desktop

Hi CrazyHorse66 ,

Thanks for sharing the details and the screenshot . Based on the error message you're seeing in Power BI Desktop when connecting to a Gen2 Dataflow (Named Pipes Provider, error: 40 - Could not open a connection to SQL Server), this is likely a network-level or security-layer issue, not a problem with the dataflow itself. We ran into something similar and found a few key things that helped: first, make sure you’re using the latest version of Power BI Desktop, as older versions don’t support Gen2 connections properly. Also, ensure you're signed in with the same organizational account that has access to the Fabric workspace where the Gen2 Dataflow is located. Permissions matter your account needs at least Viewer access to the workspace and access to the underlying Lakehouse or Warehouse if that’s where the dataflow is writing. In our case, the connection started working after confirming that our firewall allowed traffic to key Microsoft services, including *.powerbi.com, *.fabric.microsoft.com, login.microsoftonline.com, and *.azure.com. Also worth noting in some setups, it’s more reliable to connect directly to the Lakehouse or Warehouse via its dedicated connector in Power BI Desktop rather than the Dataflow  connector.

I have included the learning documents and previously solved threads here   they may help you resolve the issue.

Add Power BI URLs to allowlist - Microsoft Fabric | Microsoft Learn

DATAFLOW and ON-PREM DB connectivity solution - Microsoft Fabric Community

Solved: PBI Desktop - Unable to connect to Dataflow Gen2, ... - Microsoft Fabric Community

Solved: Power bi connect to dataflow gen2 - Microsoft Fabric Community

Solved: Dataflow Gen 2 : Lakehouse connector doesn't work - Microsoft Fabric Community

DATAFLOW and ON-PREM DB connectivity solution - Microsoft Fabric Community

If this post helped resolve your issue, please consider the Accepted Solution. This not only acknowledges the support provided but also helps other community members find relevant solutions more easily.

We appreciate your engagement and thank you for being an active part of the community.

Best regards,
LakshmiNarayana.