Forum Discussion

XCT's avatar
XCT
Resolver I
1 year ago
Solved

Error trying to retrieve table from a dataflow Gen2

Hi,   I've this message when I'm trying to retrieve data from a dataflow Gen2 in Premium capacity with Power BI desktop.   Details: "Microsoft SQL: A network-related or instance-specific error oc...
Need Help
  • XCT's avatar
    XCT
    1 year ago

    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

XCT's avatar
XCT
Resolver I
1 year ago

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