Tutorial: Generate a report from the OneLake catalog

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

In this tutorial, learn how to generate a report from the OneLake catalog with the data ingested into the warehouse.

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

Generate a report

In this task, learn how to generate a report from the OneLake catalog.

1. In the Fabric portal, in the navigation pane, select OneLake.

2. In the OneLake catalog landing page, to limit the list of items to your data, select the My items filter option.

   

3. From the item list, select the item named Wide World Importers that is of type Semantic model (default).

   Note

   Every warehouse has a corresponding default semantic model. It presents a star schema model of the warehouse tables, which provides you with a quick way to report on warehouse data.

4. To open the semantic model landing page, select Open.

   

5. In the semantic model landing page, in the Discover business insights section, open the dropdown, and then select Auto-create a report.

   

6. Review the report that Fabric generated for you.

7. On the ribbon, select File > Save.

8. In the Save your report window, in the Enter a name for your report box, enter Customer Quick Summary.

9. Select Save.

Next step

Tutorial: Clean up tutorial resources