Forum Discussion

suidino2's avatar
suidino2
Frequent Visitor
3 years ago
Solved

SQL endpoint connection

I encounter a problem.   The scenario is as following: 1. Create a Lakehouse 2. Saved several Excel files in File of the created Lakehouse 3. Use Dataflow Gen 2 to load data in those Excel ...
Dataflows
  • miguel's avatar
    miguel
    3 years ago

    Hey!

    What connector are you using when doing this connection test against the Lakehouse?

jwelch's avatar
jwelch
Microsoft Employee
3 years ago

This is likely a firewall restriction on your computer or network. The connection is being made directly from your machine running PBI Desktop to the SQL endpoint in Microsoft Fabric, and may be blocked by your network admins.

 

You can check this by using SSMS or Azure Data Studio to attempt to connect to the LH endpoint - if it fails, then you would need to talk to your network admins about opening up the firewall for the endpoint. You can get the connection string by selecting "More options" on the SQL endpoint listing in the workspace, and then "Copy SQL connection string".