Advent of 2023, Day 17 – Exploring Power BI in Microsoft Fabric

In this Microsoft Fabric series:

1. Dec 01: What is Microsoft Fabric?
2. Dec 02: Getting started with Microsoft Fabric
3. Dec 03: What is lakehouse in Fabric?
4. Dec 04: Delta lake and delta tables in Microsoft Fabric
5. Dec 05: Getting data into lakehouse
6. Dec 06: SQL Analytics endpoint
7. Dec 07: SQL commands in SQL Analytics endpoint
8. Dec 08: Using Lakehouse REST API
9. Dec 09: Building custom environments
10. Dec 10: Creating Job Spark definition
11. Dec 11: Starting data science with Microsoft Fabric
12. Dec 12: Creating data science experiments with Microsoft Fabric
13. Dec 13: Creating ML Model with Microsoft Fabric
14. Dec 14: Data warehouse with Microsoft Fabric
15. Dec 15: Building warehouse with Microsoft Fabric
16. Dec 16: Creating data pipelines for Fabric data warehouse

Within the Power BI in Fabric, you will find many of the components, that can be used to create a final report. And here are the components:

Let’s create a report online within the workspace. You will get your two options to start (and “Paste or manually enter data” is kinda contradictory in the world of data lakes 🙂 ) But select “Pick a published semantic model” coz my money doesn’t jiggle, it folds 🙂

And you will be presented with the complete OneLake data layer, picking the data from anywhere, you desire (DataLake, Datewarehouse, datasets, …). I am selecting the Advent2023_DWH dataset.

And you can have a report created automatically or manually. Let’s go with manually creating it. You will be presented with regular Power BI outlook and the data are the exact same tables from the warehouse, we have created in previous days. Also the table “SampleIngressDWH” from yesterday’s data copy using notebooks, is here.

Make sure to have all the relations between the tables created! Once you are finished with creation, save it and you are good to go.

Tomorrow we will looking into the Paginated reports, scorecards and dashboards.

Complete set of code, documents, notebooks, and all of the materials will be available at the Github repository: https://github.com/tomaztk/Microsoft-Fabric

Happy Advent of 2023! 🙂

‹ Advent of 2023, Day 16 – Creating data pipelines for Fabric data warehouse

Advent of 2023, Day 18 – Exploring Power BI in Microsoft Fabric ›

Tagged with: Azure, data science, data warehouse, Fabric, Microsoft Fabric, Power BI, T-SQL
Posted in Fabric, Power BI, Uncategorized