Looking for feedback on our Microsoft Fabric self-service BI strategy

Hi everyone, We're redesigning our Microsoft Fabric architecture and would love feedback from teams that have implemented self-service BI at scale. Current state Today, almost every Power BI report has its own semantic model. While this works, it has led to duplicated business logic, duplicated security, and increased maintenance. I've attached two simple diagrams showing our current architecture and the two approaches we're evaluating. We're moving to a domain-based Fabric architecture (Dev/Test/Prod per domain) and are evaluating two approaches. Option 1 – Centralized Semantic Model Pros Sin