Edit

Share via


Lakehouse (Beta)

Summary

Item Description
Release State Beta
Products Power BI (Semantic models)
Fabric (Dataflow Gen2)
Authentication types Organizational account

Prerequisites

You must already have an existing Lakehouse - Create a Lakehouse in Microsoft Fabric.

Capabilities supported

  • Import

Connect to a Lakehouse in Power BI Desktop

To get data from a Lakehouse in Power BI Desktop:

  1. Select the Lakehouses connector in the connector selection, and then select Connect. More information: Where to get data

    Screenshot of the Get data dialog with the Lakehouse connector emphasized.

  2. In the OneLake data hub, select the lakehouse you want to connect to. Optionally, you can use the All, My data, or Endorsed in your org buttons to filter the Lakehouses displayed in the dialog. Then select Connect.

    Screenshot of the OneLake data hub dialog with the all button selected, and a list of all the available Lakehouses.

    Note

    You can also select Choose SQL endpoint to select the SQL endpoint of the Lakehouse.

  3. Select the data you want to build visuals with from the Data pane in Power BI Desktop.

    Screenshot of Power BI Desktop with the Data pane emphasized.

Connect to a Lakehouse from Power Query Online

To get data from a Lakehouse in Power Query Online:

  1. Select the Lakehouse option in the get data experience. Different apps have different ways of getting to the Power Query Online get data experience. For more information about how to get to the Power Query Online get data experience from your app, go to Where to get data.

    Screenshot of the new source page, with the Microsoft Fabric category selected, and the Lakehouse connector emphasized.

  2. In Connect to data source, select Sign in to sign in to your organizational account.

    Screenshot of the connect to data source screen.

  3. Once you've signed in, select Next.

  4. In Choose data, select the data items that you want to transform, and then select Create.

    Screenshot of the choose data screen with the test examples item selected and the corresponding data on the right side.