Starting December 3, join live sessions with database experts and the Microsoft product team to learn just how easy it is to get started
Learn moreGet certified in Microsoft Fabric—for free! For a limited time, get a free DP-600 exam voucher to use by the end of 2024. Register 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