Tomaz Kastrun continues a series on Microsoft Fabric. Day 15 covers building a warehouse:
I have named my as “Advent2023_DWH”.
You can create a warehouse using T-SQL scripts, from data flow gen2, from data pipelines and from the sample data. Let’s select the sample data and grab a coffee.
With the Fabric warehouse created and explored, let’s see, how we can use pipelines to get the data into Fabric warehouse.
In the existing data warehouse, we will introduce new data. By clicking “new data”, two options will be available; pipelines and dataflows. Select the pipelines and give it a name.
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: