The ultimate Fabric, Power BI, SQL, and AI community-led learning event. Save €200 with code FABCOMM.
Get registeredEnhance your career with this limited time 50% discount on Fabric and Power BI exams. Ends September 15. Request your voucher.
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.
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.
Proud to be a Super User!
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.
Proud to be a Super User!
User | Count |
---|---|
63 | |
56 | |
54 | |
51 | |
31 |
User | Count |
---|---|
180 | |
88 | |
70 | |
46 | |
43 |