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
Hi XCT
Looks like you would just have to go through all the setup and this doesnot seem to be an actual limitation or blocker:
Verify Endpoint Details
Ensure you are using the exact SQL endpoint URL or instance name provided for your Dataflow Gen2 or Fabric Warehouse.
Check Network Connectivity
Try to ping the endpoint or test connection from your machine. If you cannot reach it, network/firewall rules are likely blocking access.
Review SQL Server Configuration
Make sure that remote connections are enabled and that the needed protocols (TCP/IP, Named Pipes) are active.
Check Firewall Settings
On the server/network, make sure the ports used for SQL Server (typically 1433) are not blocked.
Update Power BI Desktop
Ensure you’re running the latest version of Power BI Desktop and that your connectors are up to date.
Validate Staging and Premium Capacity
Confirm that staging is properly enabled and that your Power BI workspace has the necessary Premium capacity.
Test from Another Network or Machine
Sometimes local network issues cause problems. If possible, test from another machine or network.
When Using Fabric Warehouses
Ensure you’re connecting to the SQL endpoint specified for the Fabric Warehouse and that the warehouse is online and accessible in the Power BI service.