Frithjof Aarrestad Vassbø on 04 Aug 2024 13:35:31
Today the Lakehouse connector in Power BI Desktop has two options: Create a Live Connection to the Default Semantic Model, or Connect to the SQL Analytics Endpoint.
I think there should be a third option in the connector, which uses Lakehouse.Contents().
Or split the different functionalities into separate connectors.
I think it's a bit strange that the Lakehouse connector in Power BI Desktop points to the Default Semantic Model and the SQL Analytics Endpoint, but not to the Lakehouse (OneLake storage) itself.
Also, please provide documentation which explains the difference between the different methods of accessing Lakehouse from Power BI Desktop. Current methods I can think of: Connect to the Default Semantic Model, Connect to the SQL Analytics Endpoint, Lakehouse.Contents(), AzureStorage.DataLake().