06-12-2019 02:41 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