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.

For more tips like this, check out the working remotely playlist at . Also, if you need any further assistance then you can raise a support ticket and get it addressed