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.
Memorable MemberActually could you please describe the steps you took to get to this error msg? Because I was able to connect to my lakehouse SQL endpoint by using a SQL Server connection.
jvangrunderbeecI go to Power BI Desktop
Click on One lake data hub
Choose lakehouses
Select the Lakehouse I want to connect with
Click on the dropdown and choose connect to SQL endpoint
I'm doing this on another tenant as well, and there it works... Very strange... Maybe it could have to do with some security settings?
- Element115
If I had a dollar for every time I also used the word 'strange' 😁
The user you are using to sign in to Power BI Desktop, does this user have the same permissions in the tenant/workspace where this LH is that PBI Desktop can't connect to?
I am assuming that it is not the firewall config since you are PBI Desktop to connect successfully to LHs in other tenants/workspaces.- jvangrunderbeec
Yes, my user has access and is able to see the lakehouses and select them. But the connection just doesn't work...