Data Model Solution Advice

Hi! To give teams self-serve capability you will just have to make sure your model is set up with any data they need and measures (they can dd measures themselves, but if you want a single source of truth, it is best that the measures be in your model - also, they are re-useable for everyone then). Then, make sure anyone who will need self-service has a pro license. Finally, grant them build access on the necessary semantic model. When they go into Power BI desktop, they will click Get data then select Power BI semantic models. The pop up screen will display any semantic model they have bild access on and they can connect to that.