Tutorial: Create a Direct Lake semantic model and Power BI report

Applies to: ✅ SQL analytics endpoint and Warehouse in Microsoft Fabric

In this tutorial, you will create a Direct Lake semantic model and a Power BI report.

Note

This tutorial forms part of an end-to-end scenario. In order to complete this tutorial, you must first complete these tutorials:

1. Create a workspace
2. Create a Warehouse
3. Ingest data into a Warehouse

Create a semantic model

In this task, learn how to create a Direct Lake semantic model based the Wide World Importers warehouse.

1. Ensure that the workspace you created in the first tutorial is open.

2. Open the Wide World Importers warehouse.

3. Select the Reporting tab.

   

4. On the Reporting ribbon, select New semantic model.

   

5. In the New semantic model window, in the Direct Lake semantic model name box, enter Sales Model.

6. Expand the dbo schema, expand the Tables folder, and then check the dimension_city and fact_sale tables.

   

7. Select Confirm.

8. To open the semantic model, return to the workspace landing page, and then select the Sales Model semantic model.

9. To open the model designer, on the menu, select Open data model.

   

10. To create a relationship, in the model designer, on the Home ribbon, select Manage relationships.

    

11. In the Manage relationship window, select + New relationship.

    

12. In the New relationship window, complete the following steps to create the relationship:

    1. In the From table dropdown, select the dimension_city table.

    2. In the To table dropdown, select the fact_sale table.

    3. In the Cardinality dropdown, select One to many (1:*).

    4. In the Cross-filter direction dropdown, select Single.

    5. Check the Assume referential integrity box.

       

    6. Select Save.

13. In the Manage relationship window, select Close.

Create a Power BI report

In this task, learn how to create a Power BI report based on the semantic model you created in the first task.

1. On the Home ribbon, select New report.

   

2. In the report designer, complete the following steps to create a column chart visual:

   1. In the Data pane, expand the fact_sale table, and then check the Profit field.

   2. In the Data pane, expand the dimension_city table, and then check the SalesTerritory field.

      

   3. If necessary, resize the column chart visual by dragging the corner of the visual.

   

3. Select anywhere on the blank canvas to ensure that the column chart visual is no longer selected.

4. Complete the following steps to create a map visual:

   1. In the Visualizations pane, select the Azure Map visual.

      

   2. In the Data pane, from inside the dimension_city table, drag the StateProvince fields to the Location well in the Visualizations pane.

      

   3. In the Data pane, from inside the fact_sale table, check the Profit field to add it to the map visual Size well.

   

5. If necessary, reposition and resize the map visual to place it beneath the column chart visual at the bottom-left region of the report page.

   

6. Select anywhere on the blank canvas to ensure that the map visual is no longer selected.

7. Complete the following steps to create a table visual:

   1. In the Visualizations pane, select the Table visual.

      

   2. In the Data pane, check the following fields:

      1. SalesTerritory from the dimension_city table
      2. StateProvince from the dimension_city table
      3. Profit from the fact_sale table
      4. TotalExcludingTax from the fact_sale table

   

8. If necessary, reposition and resize the table visual to place it in an empty region of the report page.

   

9. Verify that the completed design of the report page resembles the following image.

   

10. To save the report, on the Home ribbon, select File > Save.

11. In the Save your report window, in the Enter a name for your report box, enter Sales Analysis.

12. Select Save.

Next step

Tutorial: Build a report from the OneLake