Mastering Composite Models: Power BI for the Self-Service Developer
Proposed session for SQLBits 2026TL; DR
Unlock the power of Composite Models in Power BI to bridge the gap between self-service and enterprise reporting.
In this session, we’ll explore how to enrich local data with enterprise Power BI semantic models, giving self-service Power BI developers the best of both worlds—a hybrid solution that combines flexibility with governance.
Session Details
Unlock the power of Composite Models in Power BI to bridge the gap between self-service and enterprise reporting.
In this session, we’ll explore how to enrich local data with enterprise Power BI semantic models, giving self-service Power BI developers the best of both worlds—a hybrid solution that combines flexibility with governance.
The session will provide a guided tour on how to simplify the user experience and considerations when working with Composite Models against a Power BI Semantic Model in Direct Query for example using perspectives, the considerations on Calculation Groups and Security.
And if you are a Power BI Admin or Enterprise Semantic Model Developer and want full control and governance, I will show you how to disable it for the self-service developers.
In this session, we’ll explore how to enrich local data with enterprise Power BI semantic models, giving self-service Power BI developers the best of both worlds—a hybrid solution that combines flexibility with governance.
The session will provide a guided tour on how to simplify the user experience and considerations when working with Composite Models against a Power BI Semantic Model in Direct Query for example using perspectives, the considerations on Calculation Groups and Security.
And if you are a Power BI Admin or Enterprise Semantic Model Developer and want full control and governance, I will show you how to disable it for the self-service developers.
3 things you'll get out of this session
Flexibility vs. Control
Performance and security
Composite models - more than one type