Register now to learn Fabric in free live sessions led by the best Microsoft experts. From Apr 16 to May 9, in English and Spanish.
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