Establishing end to end Setup? · Learn Microsoft Fabric

Establishing end to end Setup?

Hi everyone, I’ve started to make efforts of moving from SSMS to Fabric. I built out one workspace in which I ingest all the data via dataflow in the bronze lakehouse for each department and have the notebooks writing over to the silver Lakehouse + SQL endpoint. Each department is separated by a folder in the workspace. I then grab the semantic model from the silver LH to go in a production workspace for each individual department. I’ve made all calculations for each report in the one specific semantic model so that I can control one refresh and avoid a lot of data being duplicated in the semantic model for some reports (efforts to reduce the capacity size of the workspace). From the department workspace (essentially gold layer) I push the reports to an app for customer subscriptions. I’m not sure this is the best way to go about this, please share any suggestions/best practices/ tips with me. I’d love your feedback on this!

0 comments