Automatic Report Creation in MS Fabric
To build the Aut report we will continue from Lab-1 "https://saurabhsinhainblogs.blogspot.com/2024/02/azure-microsoft-fabric-lab-1-for.html". So our Data set is ready
Microsoft Fabric Labs
- Azure Microsoft Fabric - Lab -1 for Beginners:
- Azure Microsoft Fabric - Auto Power BI Reports Lab -2:
- Microsoft Fabric - Ingest data into the Lakehouse Lab - 3:
- Microsoft Fabric - Lakehouse and Data Transformation - Lab - 4:
- Microsoft Fabric and Power BI Reports Lab - 5:
- Microsoft Fabric - Resource Cleanup in Lab -6
Steps to Building the Report
Click on Fabric Lakehouse Tutorial-XX on the left-sided navigation pane.
In the Fabric Lakehouse Tutorial-XX view, select wwilakehouse of Type Semantic model(default).
This dataset is automatically created and has the same name as the lakehouse.
- From the semantic model pane, you can view all the tables. You have options to create reports either from scratch, paginated report or let Power BI automatically create a report based on your data.
- For this task, navigate to the Discover business insights section, then click on Explore this data and select Auto-create a report as shown in the below image.
Expand dimension_customer, check the box next to BuyingGroup, and check the box next to wwwCustomerID .
- Since the table is a dimension and there are no measures in it, Power BI creates a measure for the row count aggregates it across different columns, and creates different charts as shown in the following image.
- Save this report for future use by selecting Save at the top ribbon.
- You will see a notification stating Report saved.
You will see a notification stating Report saved.
Now you can use this report to share users just like another Power BI
- Microsoft Fabric - Ingest data into the Lakehouse Lab - 3:
No comments:
Post a Comment