Hello,
i’m trying to connect to a SQL Endpoint on a Lakehouse from Microsoft Fabric but i’m struggling to connect there.
Is there any documentation or guide for that available. I was unable to find any solution viable to reach the Warehouse.
I’m trying to use Microsoft SQL Server Connector that have 3 options of Drivers in there
I ve tryed a lot of strings trying there 3 drivers but not sucessufuly.
anybody can help me?
Hi
you first need to authenticate to MSFT and then also ensure the correct column type mapping to read the data
br
Hi, I have been successfully connecting to a PBI datamart using an SQL connection string.
I was using the second driver in your list (v.9.4.0)
Today I noticed a workflow had failed and upon investigation see that the string itself has changed from
xxxxxx.datamart.pbidedicated.windows.net
to
xxxxxx.datamart.fabric.microsoft.com
However, I don’t know if that is the root of the failure as the error message is
Login failed due to invalid authentication methods. ClientConnectionId:xxxxx
The Client Connection is a service account that has not changed.
Has anyone else had a similar issue?
I tried use the driver v.9.4.0 and receive the error login
“Execute failed: Login failed due to invalid authentication methods”
when using the 7.2.0
“Execute failed: Falha na conexão TCP/IP com o host pbipbras4-brazilsouth.”
Both using microsoft authenticator as a preview node.
Same problem here. Is there anyone that could help us?
We’re wondering the same, I do read elsewhere in the forum that people connected but were struggling with other issues, would have been great to have an example flow that works.
Beyond just the SQL endpoint, I’d also be curious in example of how to connect to the lakehouse (files) as well as tables (parquet format)
