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 MemberSomething is rotten in the kingdom of Denmark! Look at this: I am able to connect directly to the lakehouse using the worksapceId and lakehouseId from within a M query BUT NOT using the Power Query GUI!
let
Source = Lakehouse.Contents(null){[workspaceId = "id"]}[Data]{[lakehouseId = "id"]}[Data],
Navigation = Source{[Id = "DimOCState", ItemKind = "Table"]}[Data]
in
Navigation
And also able to connect to the lakehouse via the GUI by selecting SQL Server connection, which generates this M code:
let
Source = Sql.Database("SQL_endpoint_ID.datawarehouse.fabric.microsoft.com", "LH_ECOCOUNT", [CreateNavigationProperties=false]),
dbo_DimOCState = Source{[Schema="dbo",Item="DimOCState"]}[Data]
in
dbo_DimOCState
I have no effing idea what's going on!!! Why doesn't the GUI connection ADLS Gen2 work? I give it the lakehouse URL and this is the error it spits back in my face! ðŸ˜