- Subscribe to RSS Feed
- Mark Topic as New
- Mark Topic as Read
- Float this Topic for Current User
- Bookmark
- Subscribe
- Printer Friendly Page
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Report Inappropriate Content

Building a data pipeline/data warehouse in microsoft fabric
I want to use Microsoft Fabric for my data storage.
1. What is the recommended way to use Microsoft Fabric, should I bring my tables in without doing any transformations and then do the transformations in the warehouse?
Also, the original table I would use just as a base table, I would create new tables based on this base table,
2. Would I create these new tables in the same or a new warehouse?
3. Would I have these multiple warehouses in one workspace?
I have noted that one warehouse is like a data model so I am wary about cluttering up one warehouse with too many tables, views, stored procedures, and functions
Solved! Go to Solution.
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Report Inappropriate Content

Assuming you have SQL knowlwdge. Create one Datawarehouse, Load your base tabes as staging tables. Run SQLs to transform your data in Prodcution tables then create Views you need for reporting in Power BI. In my experience you can do data transfomrations in Dataflows and Data Pipelines and still need transofmrations in the DW so why not do it all in one place, easier for audinting purposes.
Did I answer your question? Mark my post as a solution!
Proud to be a Super User!
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Report Inappropriate Content

Assuming you have SQL knowlwdge. Create one Datawarehouse, Load your base tabes as staging tables. Run SQLs to transform your data in Prodcution tables then create Views you need for reporting in Power BI. In my experience you can do data transfomrations in Dataflows and Data Pipelines and still need transofmrations in the DW so why not do it all in one place, easier for audinting purposes.
Did I answer your question? Mark my post as a solution!
Proud to be a Super User!

Helpful resources
Subject | Author | Posted | |
---|---|---|---|
07-22-2024 09:13 AM | |||
06-10-2024 12:31 AM | |||
07-12-2024 10:08 AM | |||
12-12-2023 08:04 AM | |||
04-04-2024 12:17 PM |
User | Count |
---|---|
141 | |
115 | |
84 | |
63 | |
48 |