Forum Discussion
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 ...
Hey!
What connector are you using when doing this connection test against the Lakehouse?
Hey!
What connector are you using when doing this connection test against the Lakehouse?
Hello, I was using the Datalake connector.
I havent tried it yet, but I think jwelch has the point. The message is kind of same when I tried to connect to Databricks/ Synapse in the past when corporate firewall unmodified.
I am not sure how relevant is it sill, but considering that Lakehouse SQL end-point and Dataverse should work the same, I used the steps described as an approach for TDS endpoint in Dataverse article and it worked for me:
https://learn.microsoft.com/en-us/power-apps/developer/data-platform/dataverse-sql-query#blocked-ports
