Microsoft Fabric For Power BI Users Tutorial 01 – Getting Started
This is a hands-on tutorial to help Power BI people get started with Fabric in under 10 minutes. We first create a workspace and lakehouse. We then create a dataflow to clean and shape sample data sourced from a CSV file then load into a table in a Fabric lakehouse. We then run some SQL queries on the table, create a measure in the data model and visualise the data with Power BI.
Timestamps
00:00 Introduction. Let’s get started!
01:00 Introduction to the sample data
01:25 Using the Fabric Free Trial
01:45 Create a workspace and lakehouse.
02:45 Create a dataflow to load and clean the sample data
03:20 Clean the data: add columns, filter rows, merge columns, rename columns and values
05:25 Set the lakehouse as the data destination.
05:55 Publish, rename and refresh the dataflow.
06:20 View the table, and the parquet files, in the lake house.
06:45 View and explore the data with SQL endpoint.
06:50 Write a SQL query to summarise the data
07:05 View the Power BI data model and add a measure
07:35 Build a Power BI report.
08:40 Summary – This series to introduce Fabric to Power BI users. Next videos
If you want to follow along, here is the link to the sample dataset.
https://zomalextrainingstorage.blob.c...
We run a full range of data analysis and generative AI courses in London and online. See our courses at zomalex.co.uk