Forum Discussion
Helper INot able to connect to Lakehouse SQL endpoint
Hi jvangrunderbeec ,
The chief must already have an existing lakehouse. Create a lakehouse in Microsoft Fabric. And be able to successfully open the SQL analytics endpoint file.
Then you can connect to existed lakehouse in desktop, refer to below screenshoot:
For more details, you can read below document:
Power Query Lakehouse (Beta) connector - Power Query | Microsoft Learn
Lakehouse Connector In Power BI Desktop (fabric.guru)
Best Regards,
Adamk KongIf this post helps, then please consider Accept it as the solution to help the other members find it more quickly.
Helper IHi ,
I already have a LakeHouse and a SQL analytics endpoint in the lakehouse. However I cant connect to SQL endpoint from Power Bi desktop using these methods. I keep getting the same error.
Unable to connect
We encountered an error while trying to connect.
Details: "The server name provided doesn't match the server name on the SQL Server SSL certificate. Please see https://go.microsoft.com/fwlink/?LinkId=394782 or try connecting without encryption through the Data Source Settings dialog to continue. (Source at "String SQL Endpoint")"
I can connect from SSMS with these options.
I haven't found a solution yet to connect to power bi desktop , which is mandatory for me.
Thanks in advance
Memorable MemberAre you using the SQL endpoint connection string?
- poli361
Yes friend, obviously!
- Element115
Ok then I say: BUG!! 😁
Having the same issue.
Seems as though the connection between the sql endpoint for a lakehouse and power bi desktop is faulty.
In my case, I simply waited a few hours, and then the connection was suddenly available again.