Warehouse (Beta)
Summary
| Item | Description |
|---|---|
| Release State | Beta |
| Products | Power BI (Semantic models) Fabric (Dataflow Gen2) |
| Authentication types | Organizational account |
Note
Some capabilities may be present in one product but not others due to deployment schedules and host-specific capabilities.
Prerequisites
You must already have an existing Warehouse - Create a Warehouse in Microsoft Fabric.
Capabilities supported
- Import
Connect to a Warehouse in Power Query Desktop
To get data from a Warehouse in Power Query Desktop:
Select Microsoft Fabric > Warehouses in the connector selection, and then select Connect. More information: Where to get data
In the OneLake data hub, select the Warehouse you want to connect to. Optionally, you can use the All, My data, or Endorsed in your org buttons to filter the Warehouses displayed in the dialog. Then select Connect.
Note
You can also select Choose SQL endpoint to select the SQL endpoint of the Warehouse.
Select the data you want to build visuals with from the Data pane in Power BI Desktop.
Connect to a Warehouse from Power Query Online
To get data from a Warehouse in Power Query Online:
From the New source page, select Microsoft Fabric > Warehouse. More information: Where to get data
In Connect to data source, select Sign in to sign in to your organizational account.
Once you've signed in, select Next.
In Choose data, select the data items that you want to transform, and then select Create.
