Seeking Best Practices for Migrating to Microsoft Fabric
Hi all, I’m still new to this community and Microsoft Fabric, and I want to thank you all for letting me be a part of it. 🙏 I am currently considering migrating from traditional Microsoft Power BI solution to the Microsoft Fabric platform. I have a few questions that I hope you can answer. I've already watched a ton of videos on the topic—they inspire a lot of great thoughts but don’t quite give me a "solution" or a possible best practice to follow. We are an organization with many different systems and companies, which means we have many different data ingestions. Our data sources are primarily on-prem SQL servers, Microsoft 365 CRM, API calls to the HR system, and a few Excel sheets on Sharepoint. I’m particularly thinking about best practices for the architecture in Fabric. What should we use for data ingestion, transformation, and storage? Dataflows, notebooks, or pipelines—or maybe a combination? And what about the medallion architecture—is that for data ingestion to files in a data lakehouse or directly as deltatables in a lakehouse or warehouse? And how do you then proceed from there to the other steps in the architecture? I hope you can get back to me on my considerations so I can create a structured roadmap from the start, avoiding the need to redo the data architecture later on. Thanks in advance.