{"id":32278,"date":"2021-01-15T15:18:31","date_gmt":"2021-01-15T15:18:31","guid":{"rendered":"https:\/\/www.testpreptraining.com\/tutorial\/?page_id=32278"},"modified":"2021-01-15T15:18:33","modified_gmt":"2021-01-15T15:18:33","slug":"overview-of-model-relationships-in-power-bi-desktop","status":"publish","type":"page","link":"https:\/\/www.testpreptraining.ai\/tutorial\/overview-of-model-relationships-in-power-bi-desktop\/","title":{"rendered":"Overview of Model Relationships in Power BI Desktop"},"content":{"rendered":"\n<p>We shall discuss import data modelers working with Power BI Desktop considered as an important model design. It is considered essential to deliver intuitive, accurate, and optimal models. Primarily, model relationship paths are considered deterministic, indicating that filters are always propagated in the same manner and without random variation. Also, relationships can, be disabled, or may have filter context modified by model calculations that use particular DAX functions.\u00a0It&#8217;s very crucial for you to understand that model relationships do not enforce data integrity.\u00a0<\/p>\n\n\n\n<h4 class=\"wp-block-heading\" id=\"disconnected-tables\"><strong>Disconnected Tables<\/strong><\/h4>\n\n\n\n<p>In general, it is rare that a model table is not related to another model table. Further, such a table in a valid model design can be described as a\u00a0disconnected table. <\/p>\n\n\n\n<ul class=\"wp-block-list\"><li>Firstly, a disconnected table is not meant to propagate filters to other model tables. <\/li><li>Secondly, disconnected tables are used to accept &#8220;user input&#8221; (perhaps with a slicer visual), allowing model calculations to use the input value in a meaningful way.<\/li><\/ul>\n\n\n\n<h3 class=\"wp-block-heading\"><strong>Model Relationships Properties<\/strong><\/h3>\n\n\n\n<p>As you know model relationship relates one column in a table to one column in a different table. <\/p>\n\n\n\n<h4 class=\"wp-block-heading\" id=\"cardinality\"><strong>Cardinality<\/strong><\/h4>\n\n\n\n<p>Every model relationship must be defined with a cardinality type. In general, the following represents the cardinality type options, representing the data characteristics of the &#8220;from&#8221; and &#8220;to&#8221; related columns. The &#8220;one&#8221; side means the column contains unique values; the &#8220;two&#8221; side means the column can contain duplicate values. The four options are &#8211;<\/p>\n\n\n\n<ul class=\"wp-block-list\"><li>One-to-many (1:*)<\/li><li>Many-to-one (*:1)<\/li><li>One-to-one (1:1)<\/li><li>Many-to-many (*:*)<\/li><\/ul>\n\n\n\n<h4 class=\"wp-block-heading\" id=\"cross-filter-direction\"><strong>Cross filter direction<\/strong><\/h4>\n\n\n\n<p>Every model relationship has to be defined with a cross filter direction. Moreover, your selection determines the direction(s) that filters will propagate. The possible cross filter options are dependent on the cardinality type.<\/p>\n\n\n\n<figure class=\"wp-block-table\"><table><thead><tr><th>Cardinality type<\/th><th>Cross filter options<\/th><\/tr><\/thead><tbody><tr><td>One-to-many (or Many-to-one)<\/td><td>Single<br>Both<\/td><\/tr><tr><td>One-to-one<\/td><td>Both<\/td><\/tr><tr><td>Many-to-many<\/td><td>Single (Table1 to Table2)<br>Single (Table2 to Table1)<br>Both<\/td><\/tr><\/tbody><\/table><\/figure>\n\n\n\n<h4 class=\"wp-block-heading\" id=\"relationship-evaluation\"><strong>Relationship Evaluation<\/strong><\/h4>\n\n\n\n<p>From an evaluation perspective, Model relationships, are categorised as regular\u00a0or\u00a0limited. But, remember, it is not configurable relationship property. Further, it is essential to understand the evaluation type since there may be performance implications or consequences should data integrity be compromised. <\/p>\n\n\n\n<ul class=\"wp-block-list\"><li>A model relationship is\u00a0<em>regular<\/em>\u00a0when the query engine can determine the &#8220;one&#8221; side of relationship. It has confirmation that the &#8220;one&#8221; side column contains unique values. All One-to-many intra source group relationships are regular relationships.<\/li><li>A model relationship is\u00a0<em>limited<\/em>\u00a0when there&#8217;s no guaranteed &#8220;one&#8221; side. It can be performed in case the relationship uses a Many-to-many cardinality type or the relationship is cross source group.<\/li><\/ul>\n\n\n\n<p>For more visit &#8211; <a href=\"https:\/\/docs.microsoft.com\/en-us\/power-bi\/transform-model\/desktop-relationships-understand\" target=\"_blank\" rel=\"noreferrer noopener\">Model Relationships<\/a><\/p>\n\n\n\n<div class=\"wp-block-image is-style-default\"><figure class=\"aligncenter size-large\"><a href=\"https:\/\/www.testpreptraining.ai\/analyzing-data-with-microsoft-power-bi-da-100-free-test\" target=\"_blank\" rel=\"noopener\"><img loading=\"lazy\" decoding=\"async\" width=\"961\" height=\"150\" src=\"https:\/\/www.testpreptraining.ai\/tutorial\/wp-content\/uploads\/2021\/01\/Microsoft-Exam-DA-100-Free-Practice-Test.png\" alt=\"Microsoft Exam DA-100 Free Practice Test\" class=\"wp-image-31483\" srcset=\"https:\/\/www.testpreptraining.ai\/tutorial\/wp-content\/uploads\/2021\/01\/Microsoft-Exam-DA-100-Free-Practice-Test.png 961w, https:\/\/www.testpreptraining.ai\/tutorial\/wp-content\/uploads\/2021\/01\/Microsoft-Exam-DA-100-Free-Practice-Test-750x117.png 750w\" sizes=\"auto, (max-width: 961px) 100vw, 961px\" \/><\/a><\/figure><\/div>\n","protected":false},"excerpt":{"rendered":"<p>We shall discuss import data modelers working with Power BI Desktop considered as an important model design. It is considered essential to deliver intuitive, accurate, and optimal models. Primarily, model relationship paths are considered deterministic, indicating that filters are always propagated in the same manner and without random variation. Also, relationships can, be disabled, or&#8230;<\/p>\n","protected":false},"author":1,"featured_media":0,"parent":0,"menu_order":0,"comment_status":"closed","ping_status":"closed","template":"","meta":{"_acf_changed":false,"footnotes":""},"categories":[174],"tags":[3954,4023],"class_list":["post-32278","page","type-page","status-publish","hentry","category-microsoft-azure","tag-microsoft-exam-da-100-free-practice-test","tag-model-relationships"],"acf":[],"yoast_head":"<!-- This site is optimized with the Yoast SEO plugin v22.1 - https:\/\/yoast.com\/wordpress\/plugins\/seo\/ -->\n<title>Overview of Model Relationships in Power BI Desktop | Testprep Training<\/title>\n<meta name=\"description\" content=\"Boost your chances and get ready to qualify Microsoft Exam DA-100 exam. Learn more about Model Relationships in Power BI Desktop Now!\" \/>\n<meta name=\"robots\" content=\"index, follow, max-snippet:-1, max-image-preview:large, max-video-preview:-1\" \/>\n<link rel=\"canonical\" href=\"https:\/\/www.testpreptraining.ai\/tutorial\/overview-of-model-relationships-in-power-bi-desktop\/\" \/>\n<meta property=\"og:locale\" content=\"en_US\" \/>\n<meta property=\"og:type\" content=\"article\" \/>\n<meta property=\"og:title\" content=\"Overview of Model Relationships in Power BI Desktop | Testprep Training\" \/>\n<meta property=\"og:description\" content=\"Boost your chances and get ready to qualify Microsoft Exam DA-100 exam. Learn more about Model Relationships in Power BI Desktop Now!\" \/>\n<meta property=\"og:url\" content=\"https:\/\/www.testpreptraining.ai\/tutorial\/overview-of-model-relationships-in-power-bi-desktop\/\" \/>\n<meta property=\"og:site_name\" content=\"Testprep Training Tutorials\" \/>\n<meta property=\"article:modified_time\" content=\"2021-01-15T15:18:33+00:00\" \/>\n<meta property=\"og:image\" content=\"https:\/\/www.testpreptraining.ai\/tutorial\/wp-content\/uploads\/2021\/01\/Microsoft-Exam-DA-100-Free-Practice-Test.png\" \/>\n<meta name=\"twitter:card\" content=\"summary_large_image\" \/>\n<meta name=\"twitter:label1\" content=\"Est. reading time\" \/>\n\t<meta name=\"twitter:data1\" content=\"2 minutes\" \/>\n<script type=\"application\/ld+json\" class=\"yoast-schema-graph\">{\"@context\":\"https:\/\/schema.org\",\"@graph\":[{\"@type\":\"WebPage\",\"@id\":\"https:\/\/www.testpreptraining.ai\/tutorial\/overview-of-model-relationships-in-power-bi-desktop\/\",\"url\":\"https:\/\/www.testpreptraining.ai\/tutorial\/overview-of-model-relationships-in-power-bi-desktop\/\",\"name\":\"Overview of Model Relationships in Power BI Desktop | Testprep Training\",\"isPartOf\":{\"@id\":\"https:\/\/www.testpreptraining.ai\/tutorial\/#website\"},\"datePublished\":\"2021-01-15T15:18:31+00:00\",\"dateModified\":\"2021-01-15T15:18:33+00:00\",\"description\":\"Boost your chances and get ready to qualify Microsoft Exam DA-100 exam. Learn more about Model Relationships in Power BI Desktop Now!\",\"breadcrumb\":{\"@id\":\"https:\/\/www.testpreptraining.ai\/tutorial\/overview-of-model-relationships-in-power-bi-desktop\/#breadcrumb\"},\"inLanguage\":\"en-US\",\"potentialAction\":[{\"@type\":\"ReadAction\",\"target\":[\"https:\/\/www.testpreptraining.ai\/tutorial\/overview-of-model-relationships-in-power-bi-desktop\/\"]}]},{\"@type\":\"BreadcrumbList\",\"@id\":\"https:\/\/www.testpreptraining.ai\/tutorial\/overview-of-model-relationships-in-power-bi-desktop\/#breadcrumb\",\"itemListElement\":[{\"@type\":\"ListItem\",\"position\":1,\"name\":\"Home\",\"item\":\"https:\/\/www.testpreptraining.ai\/tutorial\/\"},{\"@type\":\"ListItem\",\"position\":2,\"name\":\"Overview of Model Relationships in Power BI Desktop\"}]},{\"@type\":\"WebSite\",\"@id\":\"https:\/\/www.testpreptraining.ai\/tutorial\/#website\",\"url\":\"https:\/\/www.testpreptraining.ai\/tutorial\/\",\"name\":\"Testprep Training Tutorials\",\"description\":\"\",\"publisher\":{\"@id\":\"https:\/\/www.testpreptraining.ai\/tutorial\/#organization\"},\"potentialAction\":[{\"@type\":\"SearchAction\",\"target\":{\"@type\":\"EntryPoint\",\"urlTemplate\":\"https:\/\/www.testpreptraining.ai\/tutorial\/?s={search_term_string}\"},\"query-input\":\"required name=search_term_string\"}],\"inLanguage\":\"en-US\"},{\"@type\":\"Organization\",\"@id\":\"https:\/\/www.testpreptraining.ai\/tutorial\/#organization\",\"name\":\"Testprep Training\",\"url\":\"https:\/\/www.testpreptraining.ai\/tutorial\/\",\"logo\":{\"@type\":\"ImageObject\",\"inLanguage\":\"en-US\",\"@id\":\"https:\/\/www.testpreptraining.ai\/tutorial\/#\/schema\/logo\/image\/\",\"url\":\"https:\/\/www.testpreptraining.com\/tutorial\/wp-content\/uploads\/2020\/07\/tpt-logo-6.png\",\"contentUrl\":\"https:\/\/www.testpreptraining.com\/tutorial\/wp-content\/uploads\/2020\/07\/tpt-logo-6.png\",\"width\":583,\"height\":153,\"caption\":\"Testprep Training\"},\"image\":{\"@id\":\"https:\/\/www.testpreptraining.ai\/tutorial\/#\/schema\/logo\/image\/\"}}]}<\/script>\n<!-- \/ Yoast SEO plugin. -->","yoast_head_json":{"title":"Overview of Model Relationships in Power BI Desktop | Testprep Training","description":"Boost your chances and get ready to qualify Microsoft Exam DA-100 exam. Learn more about Model Relationships in Power BI Desktop Now!","robots":{"index":"index","follow":"follow","max-snippet":"max-snippet:-1","max-image-preview":"max-image-preview:large","max-video-preview":"max-video-preview:-1"},"canonical":"https:\/\/www.testpreptraining.ai\/tutorial\/overview-of-model-relationships-in-power-bi-desktop\/","og_locale":"en_US","og_type":"article","og_title":"Overview of Model Relationships in Power BI Desktop | Testprep Training","og_description":"Boost your chances and get ready to qualify Microsoft Exam DA-100 exam. Learn more about Model Relationships in Power BI Desktop Now!","og_url":"https:\/\/www.testpreptraining.ai\/tutorial\/overview-of-model-relationships-in-power-bi-desktop\/","og_site_name":"Testprep Training Tutorials","article_modified_time":"2021-01-15T15:18:33+00:00","og_image":[{"url":"https:\/\/www.testpreptraining.ai\/tutorial\/wp-content\/uploads\/2021\/01\/Microsoft-Exam-DA-100-Free-Practice-Test.png"}],"twitter_card":"summary_large_image","twitter_misc":{"Est. reading time":"2 minutes"},"schema":{"@context":"https:\/\/schema.org","@graph":[{"@type":"WebPage","@id":"https:\/\/www.testpreptraining.ai\/tutorial\/overview-of-model-relationships-in-power-bi-desktop\/","url":"https:\/\/www.testpreptraining.ai\/tutorial\/overview-of-model-relationships-in-power-bi-desktop\/","name":"Overview of Model Relationships in Power BI Desktop | Testprep Training","isPartOf":{"@id":"https:\/\/www.testpreptraining.ai\/tutorial\/#website"},"datePublished":"2021-01-15T15:18:31+00:00","dateModified":"2021-01-15T15:18:33+00:00","description":"Boost your chances and get ready to qualify Microsoft Exam DA-100 exam. Learn more about Model Relationships in Power BI Desktop Now!","breadcrumb":{"@id":"https:\/\/www.testpreptraining.ai\/tutorial\/overview-of-model-relationships-in-power-bi-desktop\/#breadcrumb"},"inLanguage":"en-US","potentialAction":[{"@type":"ReadAction","target":["https:\/\/www.testpreptraining.ai\/tutorial\/overview-of-model-relationships-in-power-bi-desktop\/"]}]},{"@type":"BreadcrumbList","@id":"https:\/\/www.testpreptraining.ai\/tutorial\/overview-of-model-relationships-in-power-bi-desktop\/#breadcrumb","itemListElement":[{"@type":"ListItem","position":1,"name":"Home","item":"https:\/\/www.testpreptraining.ai\/tutorial\/"},{"@type":"ListItem","position":2,"name":"Overview of Model Relationships in Power BI Desktop"}]},{"@type":"WebSite","@id":"https:\/\/www.testpreptraining.ai\/tutorial\/#website","url":"https:\/\/www.testpreptraining.ai\/tutorial\/","name":"Testprep Training Tutorials","description":"","publisher":{"@id":"https:\/\/www.testpreptraining.ai\/tutorial\/#organization"},"potentialAction":[{"@type":"SearchAction","target":{"@type":"EntryPoint","urlTemplate":"https:\/\/www.testpreptraining.ai\/tutorial\/?s={search_term_string}"},"query-input":"required name=search_term_string"}],"inLanguage":"en-US"},{"@type":"Organization","@id":"https:\/\/www.testpreptraining.ai\/tutorial\/#organization","name":"Testprep Training","url":"https:\/\/www.testpreptraining.ai\/tutorial\/","logo":{"@type":"ImageObject","inLanguage":"en-US","@id":"https:\/\/www.testpreptraining.ai\/tutorial\/#\/schema\/logo\/image\/","url":"https:\/\/www.testpreptraining.com\/tutorial\/wp-content\/uploads\/2020\/07\/tpt-logo-6.png","contentUrl":"https:\/\/www.testpreptraining.com\/tutorial\/wp-content\/uploads\/2020\/07\/tpt-logo-6.png","width":583,"height":153,"caption":"Testprep Training"},"image":{"@id":"https:\/\/www.testpreptraining.ai\/tutorial\/#\/schema\/logo\/image\/"}}]}},"_links":{"self":[{"href":"https:\/\/www.testpreptraining.ai\/tutorial\/wp-json\/wp\/v2\/pages\/32278","targetHints":{"allow":["GET"]}}],"collection":[{"href":"https:\/\/www.testpreptraining.ai\/tutorial\/wp-json\/wp\/v2\/pages"}],"about":[{"href":"https:\/\/www.testpreptraining.ai\/tutorial\/wp-json\/wp\/v2\/types\/page"}],"author":[{"embeddable":true,"href":"https:\/\/www.testpreptraining.ai\/tutorial\/wp-json\/wp\/v2\/users\/1"}],"replies":[{"embeddable":true,"href":"https:\/\/www.testpreptraining.ai\/tutorial\/wp-json\/wp\/v2\/comments?post=32278"}],"version-history":[{"count":2,"href":"https:\/\/www.testpreptraining.ai\/tutorial\/wp-json\/wp\/v2\/pages\/32278\/revisions"}],"predecessor-version":[{"id":32280,"href":"https:\/\/www.testpreptraining.ai\/tutorial\/wp-json\/wp\/v2\/pages\/32278\/revisions\/32280"}],"wp:attachment":[{"href":"https:\/\/www.testpreptraining.ai\/tutorial\/wp-json\/wp\/v2\/media?parent=32278"}],"wp:term":[{"taxonomy":"category","embeddable":true,"href":"https:\/\/www.testpreptraining.ai\/tutorial\/wp-json\/wp\/v2\/categories?post=32278"},{"taxonomy":"post_tag","embeddable":true,"href":"https:\/\/www.testpreptraining.ai\/tutorial\/wp-json\/wp\/v2\/tags?post=32278"}],"curies":[{"name":"wp","href":"https:\/\/api.w.org\/{rel}","templated":true}]}}