Edit

Share via


Create reports in the Power BI service in Microsoft Fabric and Power BI Desktop

Applies to:SQL analytics endpoint, Warehouse, and Mirrored Database in Microsoft Fabric

This article describes different scenarios you can follow to create reports in Power BI on your Fabric warehouse.

Use the OneLake catalog

In the workspace list, select the semantic model's name to get to the Semantic model details page, where you can find details about the semantic model and see related reports. You can also create a report directly from this page. To learn more about creating a report in this fashion, see Dataset details.

In the OneLake catalog, you see warehouse and their associated semantic models. Starting August 8, 2025, Power BI default semantic models are no longer created automatically when a warehouse, lakehouse, or mirrored item is created. If your item doesn't have a semantic model already, you can create a Power BI semantic model. Existing default semantic models will be converted to regular semantic models. For more information, see Sunsetting Default Semantic Models.

Select the warehouse to navigate to the warehouse details page. You can see the warehouse metadata, supported actions, lineage and impact analysis, along with related reports created from that warehouse.

To find the warehouse, you begin with the OneLake catalog. The following image shows the OneLake catalog in the Power BI service:

  1. Select a warehouse to view its warehouse details page.

  2. Select the More menu (...) to display the options menu.

  3. Select Open to open the warehouse.

Create reports in the Power BI Desktop

The OneLake catalog integration in Power BI Desktop lets you connect to the Warehouse or SQL analytics endpoint of Lakehouse in easy steps.

  1. Use Data hub menu in the ribbon to get list of all items.

  2. Select the warehouse that you would like to connect

  3. On the Connect button, select the dropdown list, and select Connect to SQL endpoint.

    Screenshot of the Data hub in Power BI Desktop.