Forum Discussion
Error trying to retrieve table from a dataflow Gen2
Hi everyone!
It’s definitely a firewall configuration issue on my company’s network. For your information, it works perfectly from home.
PBI Desktop directly queries the SQLAnalytics endpoint (Azure SQL Server TDS endpoint), by default through port 1433. Our corporate network policies block this traffic. Therefore, we need to consider a workaround if we want to roll out Fabric to other users, as the same applies to SQL connections to both Fabric Warehouse and Lakehouse.
We found this documentation here => https://learn.microsoft.com/en-us/fabric/database/sql/connect
Regards,
XCT
Use TCP/IP, not Named Pipes — add tcp: before the SQL endpoint.
Check network access — firewall, VPN, or proxy might be blocking it.
Verify endpoint URL — make sure it's correct and reachable.
Use the right connector — Dataflow Gen2 needs the Dataflow connector, not SQL Server.
Ensure staging is enabled and run — data must be staged before querying.