March 31 - April 2, 2025, in Las Vegas, Nevada. Use code MSCUST for a $150 discount! Early bird discount ends December 31.
Register NowBe one of the first to start using Fabric Databases. View on-demand sessions with database experts and the Microsoft product team to learn just how easy it is to get started. Watch now
06-12-2019 00:58 AM - last edited 05-11-2021 00:49 AM
This presentation on Power BI modeling provides specific focus on relationships ? essential to delivering intuitive, accurate, and optimal models. Relationship design can be considered part science and part art. Learn what relationships do and how they can be configured for Import, DirectQuery, and Composite models. After a straightforward introduction, theory and demos progress beyond the basics to explain how to achieve sophisticated model designs that include role playing dimensions, many-to-many relationships (two techniques), ambiguous relationships, and disconnected tables. All DAX functions that leverage or modify model relationships are also covered.
Other resources: https://medius.studios.ms/video/asset/PPT/MBAS19-BRK3019
/watch?v=78d6mwR8GtA
/html/assets/mbas_power_bi.svg
BRK3019