{"id":3922,"date":"2022-01-13T16:40:56","date_gmt":"2022-01-14T00:40:56","guid":{"rendered":"https:\/\/SUMMALAI.COM\/?p=3922"},"modified":"2022-01-13T16:40:58","modified_gmt":"2022-01-14T00:40:58","slug":"how-to-enable-assume-referential-integrity-to-speed-up-directquery","status":"publish","type":"post","link":"https:\/\/SUMMALAI.COM\/?p=3922","title":{"rendered":"How to Enable &#8220;Assume referential integrity&#8221; to Speed Up DirectQuery"},"content":{"rendered":"\n<p>When connecting to a data source using&nbsp;<strong>DirectQuery<\/strong>, you can use the&nbsp;<strong>Assume Referential Integrity<\/strong>&nbsp;selection to enable running more efficient queries against your data source. This feature has a few requirements of the underlying data, and it is only available when using&nbsp;<strong>DirectQuery<\/strong>.<\/p>\n\n\n\n<p>Setting&nbsp;<strong>Assume referential integrity<\/strong>&nbsp;enables queries on the data source to use&nbsp;<strong>INNER JOIN<\/strong>&nbsp;statements rather than&nbsp;<strong>OUTER JOIN<\/strong>, which improves query efficiency.<\/p>\n\n\n\n<figure class=\"wp-block-image\"><img decoding=\"async\" src=\"https:\/\/docs.microsoft.com\/en-us\/power-bi\/connect-data\/media\/desktop-assume-referential-integrity\/assume-referential-integrity_1.png\" alt=\"Screenshot of an Edit Relationship dialog to select Assume referential integrity.\"\/><\/figure>\n\n\n\n<h2 class=\"wp-block-heading\" id=\"requirements-for-using-assume-referential-integrity\"><a href=\"https:\/\/docs.microsoft.com\/en-us\/power-bi\/connect-data\/desktop-assume-referential-integrity#requirements-for-using-assume-referential-integrity\"><\/a>Requirements for using Assume referential integrity<\/h2>\n\n\n\n<p>This is an advanced setting, and is only enabled when connecting to data using&nbsp;<strong>DirectQuery<\/strong>. The following requirements are necessary for&nbsp;<strong>Assume referential integrity<\/strong>&nbsp;to work properly:<\/p>\n\n\n\n<ul class=\"wp-block-list\"><li>Data in the&nbsp;<strong>From<\/strong>&nbsp;column in the relationship is never&nbsp;<em>Null<\/em>&nbsp;or&nbsp;<em>blank<\/em><\/li><li>For each value in the&nbsp;<strong>From<\/strong>&nbsp;column, there is a corresponding value in the&nbsp;<strong>To<\/strong>&nbsp;column<\/li><\/ul>\n\n\n\n<p>In this context, the&nbsp;<strong>From<\/strong>&nbsp;column is the&nbsp;<em>Many<\/em>&nbsp;in a&nbsp;<em>One-to-Many<\/em>&nbsp;relationship, or it is the column in the first table in a&nbsp;<em>One-to-One<\/em>&nbsp;relationship.<\/p>\n\n\n\n<h2 class=\"wp-block-heading\" id=\"example-of-using-assume-referential-integrity\"><a href=\"https:\/\/docs.microsoft.com\/en-us\/power-bi\/connect-data\/desktop-assume-referential-integrity#example-of-using-assume-referential-integrity\"><\/a>Example of using Assume referential integrity<\/h2>\n\n\n\n<p>The following example demonstrates how&nbsp;<strong>Assume referential integrity<\/strong>&nbsp;behaves when used in data connections. The example connects to a data source that includes an&nbsp;<strong>Orders<\/strong>&nbsp;table, a&nbsp;<strong>Products<\/strong>&nbsp;table, and a&nbsp;<strong>Depots<\/strong>&nbsp;table.<\/p>\n\n\n\n<ol class=\"wp-block-list\"><li>In the following image that shows the&nbsp;<strong>Orders<\/strong>&nbsp;table and the&nbsp;<strong>Products<\/strong>&nbsp;table, note that referential integrity exists between&nbsp;<strong>Orders[ProductID]<\/strong>&nbsp;and&nbsp;<strong>Products[ProductID]<\/strong>. The&nbsp;<strong>[ProductID]<\/strong>&nbsp;column in the&nbsp;<strong>Orders<\/strong>&nbsp;table is never&nbsp;<em>Null<\/em>, and every value also appears in the&nbsp;<strong>Products<\/strong>&nbsp;table. As such,&nbsp;<strong>Assume Referential Integrity<\/strong>&nbsp;should be set to get more efficient queries (using this setting does not change the values shown in visuals).<img decoding=\"async\" src=\"https:\/\/docs.microsoft.com\/en-us\/power-bi\/connect-data\/media\/desktop-assume-referential-integrity\/assume-referential-integrity_2.png\" alt=\"Screenshot of Orders table and Products table.\"><\/li><li>In the next image, notice that no referential integrity exists between&nbsp;<strong>Orders[DepotID]<\/strong>&nbsp;and&nbsp;<strong>Depots[DepotID]<\/strong>, because the&nbsp;<strong>DepotID<\/strong>&nbsp;is&nbsp;<em>Null<\/em>&nbsp;for some&nbsp;<em>Orders<\/em>. As such,&nbsp;<strong>Assume Referential Integrity<\/strong>&nbsp;should&nbsp;<em>not<\/em>&nbsp;be set.<img decoding=\"async\" src=\"https:\/\/docs.microsoft.com\/en-us\/power-bi\/connect-data\/media\/desktop-assume-referential-integrity\/assume-referential-integrity_3.png\" alt=\"Screenshot of Orders table and Depots table.\"><\/li><li>Finally, no referential integrity exists between&nbsp;<strong>Orders[CustomerID]<\/strong>&nbsp;and&nbsp;<strong>Customers[CustID]<\/strong>&nbsp;in the following tables; the&nbsp;<strong>CustomerID<\/strong>&nbsp;contains some values (in this case,&nbsp;<em>CustX<\/em>) that do not exist in the&nbsp;<em>Customers<\/em>&nbsp;table. As such,&nbsp;<strong>Assume Referential Integrity<\/strong>&nbsp;should&nbsp;<em>not<\/em>&nbsp;be set.<img decoding=\"async\" src=\"https:\/\/docs.microsoft.com\/en-us\/power-bi\/connect-data\/media\/desktop-assume-referential-integrity\/assume-referential-integrity_4.png\" alt=\"Screenshot of Orders table and Customers table.\"><\/li><\/ol>\n\n\n\n<h2 class=\"wp-block-heading\" id=\"setting-assume-referential-integrity\"><a href=\"https:\/\/docs.microsoft.com\/en-us\/power-bi\/connect-data\/desktop-assume-referential-integrity#setting-assume-referential-integrity\"><\/a>Setting Assume referential integrity<\/h2>\n\n\n\n<p>To enable this feature, select the checkbox next to&nbsp;<strong>Assume Referential Integrity<\/strong>&nbsp;as shown in the following image.<\/p>\n\n\n\n<figure class=\"wp-block-image\"><img decoding=\"async\" src=\"https:\/\/docs.microsoft.com\/en-us\/power-bi\/connect-data\/media\/desktop-assume-referential-integrity\/assume-referential-integrity_1.png\" alt=\"Screenshot of an Edit Relationship dialog that allows you to select Assume referential integrity.\"\/><\/figure>\n\n\n\n<p>When selected, the setting is validated against the data to ensure there are no&nbsp;<em>Null<\/em>&nbsp;or mismatched rows.&nbsp;<em>However<\/em>, for cases with a very large number of values, the validation is not a guarantee that there are no referential integrity issues.<\/p>\n\n\n\n<p>In addition, the validation occurs at the time of editing the relationship, and does&nbsp;<em>not<\/em>&nbsp;reflect any subsequent changes to the data.<\/p>\n\n\n\n<h2 class=\"wp-block-heading\" id=\"what-happens-if-you-incorrectly-set-assume-referential-integrity\"><a href=\"https:\/\/docs.microsoft.com\/en-us\/power-bi\/connect-data\/desktop-assume-referential-integrity#what-happens-if-you-incorrectly-set-assume-referential-integrity\"><\/a>What happens if you incorrectly set Assume referential integrity?<\/h2>\n\n\n\n<p>If you set&nbsp;<strong>Assume Referential Integrity<\/strong>&nbsp;when there are referential integrity issues in the data, this will not result in errors. However, it will result in apparent inconsistencies in the data. For example, in the case of the relationship to the&nbsp;<strong>Depots<\/strong>&nbsp;table described above, it would result in the following:<\/p>\n\n\n\n<ul class=\"wp-block-list\"><li>A visual showing the total\u00a0<em>Order Qty<\/em>\u00a0would show a value of 40<\/li><li>A visual showing the total\u00a0<em>Order Qty by Depot City<\/em>\u00a0would show a total value of only\u00a0<em>30<\/em>, because it would not include Order ID 1, where\u00a0<strong>DepotID<\/strong>\u00a0is\u00a0<em>Null<\/em>.<\/li><\/ul>\n\n\n\n<p>Ref: https:\/\/docs.microsoft.com\/en-us\/power-bi\/connect-data\/desktop-assume-referential-integrity<\/p>\n","protected":false},"excerpt":{"rendered":"<p>When connecting to a data source using&nbsp;DirectQuery, you can use the&nbsp;Assume Referential Integrity&nbsp;selection to enable running more efficient queries against your data source. This feature has a few requirements of the underlying data, and it is only available when using&nbsp;DirectQuery. Setting&nbsp;Assume referential integrity&nbsp;enables queries on the data source to use&nbsp;INNER JOIN&nbsp;statements rather than&nbsp;OUTER JOIN, which <a class=\"read-more\" href=\"https:\/\/SUMMALAI.COM\/?p=3922\">Read More<\/a><\/p>\n","protected":false},"author":2,"featured_media":0,"comment_status":"closed","ping_status":"closed","sticky":false,"template":"","format":"standard","meta":{"_bbp_topic_count":0,"_bbp_reply_count":0,"_bbp_total_topic_count":0,"_bbp_total_reply_count":0,"_bbp_voice_count":0,"_bbp_anonymous_reply_count":0,"_bbp_topic_count_hidden":0,"_bbp_reply_count_hidden":0,"_bbp_forum_subforum_count":0,"om_disable_all_campaigns":false,"_monsterinsights_skip_tracking":false,"_monsterinsights_sitenote_active":false,"_monsterinsights_sitenote_note":"","_monsterinsights_sitenote_category":0,"footnotes":""},"categories":[10,621],"tags":[1046,1047],"class_list":["post-3922","post","type-post","status-publish","format-standard","hentry","category-microsoft","category-power-bi","tag-assume-referential-integrity","tag-speed-up-directquery"],"aioseo_notices":[],"aioseo_head":"\n\t\t<!-- All in One SEO 4.9.8 - aioseo.com -->\n\t<meta name=\"description\" content=\"When connecting to a data source using DirectQuery, you can use the Assume Referential Integrity selection to enable running more efficient queries against your data source. This feature has a few requirements of the underlying data, and it is only available when using DirectQuery. Setting Assume referential integrity enables queries on the data source to use INNER JOIN statements rather than OUTER JOIN, which\" \/>\n\t<meta name=\"robots\" content=\"max-image-preview:large\" \/>\n\t<meta name=\"author\" content=\"Summa Lai\"\/>\n\t<meta name=\"keywords\" content=\"assume referential integrity,speed up directquery,microsoft family,power bi\" \/>\n\t<link rel=\"canonical\" href=\"https:\/\/SUMMALAI.COM\/?p=3922\" \/>\n\t<meta name=\"generator\" content=\"All in One SEO (AIOSEO) 4.9.8\" \/>\n\t\t<script type=\"application\/ld+json\" class=\"aioseo-schema\">\n\t\t\t{\"@context\":\"https:\\\/\\\/schema.org\",\"@graph\":[{\"@type\":\"Article\",\"@id\":\"https:\\\/\\\/SUMMALAI.COM\\\/?p=3922#article\",\"name\":\"How to Enable \\u201cAssume referential integrity\\u201d to Speed Up DirectQuery | Summa Lai\",\"headline\":\"How to Enable &#8220;Assume referential integrity&#8221; to Speed Up DirectQuery\",\"author\":{\"@id\":\"https:\\\/\\\/SUMMALAI.COM\\\/?author=2#author\"},\"publisher\":{\"@id\":\"https:\\\/\\\/SUMMALAI.COM\\\/#person\"},\"image\":{\"@type\":\"ImageObject\",\"url\":\"https:\\\/\\\/docs.microsoft.com\\\/en-us\\\/power-bi\\\/connect-data\\\/media\\\/desktop-assume-referential-integrity\\\/assume-referential-integrity_1.png\",\"@id\":\"https:\\\/\\\/SUMMALAI.COM\\\/?p=3922\\\/#articleImage\"},\"datePublished\":\"2022-01-13T16:40:56-08:00\",\"dateModified\":\"2022-01-13T16:40:58-08:00\",\"inLanguage\":\"en-US\",\"mainEntityOfPage\":{\"@id\":\"https:\\\/\\\/SUMMALAI.COM\\\/?p=3922#webpage\"},\"isPartOf\":{\"@id\":\"https:\\\/\\\/SUMMALAI.COM\\\/?p=3922#webpage\"},\"articleSection\":\"Microsoft Family, Power BI, Assume referential integrity, Speed Up DirectQuery\"},{\"@type\":\"BreadcrumbList\",\"@id\":\"https:\\\/\\\/SUMMALAI.COM\\\/?p=3922#breadcrumblist\",\"itemListElement\":[{\"@type\":\"ListItem\",\"@id\":\"https:\\\/\\\/SUMMALAI.COM#listItem\",\"position\":1,\"name\":\"Home\",\"item\":\"https:\\\/\\\/SUMMALAI.COM\",\"nextItem\":{\"@type\":\"ListItem\",\"@id\":\"https:\\\/\\\/SUMMALAI.COM\\\/?cat=10#listItem\",\"name\":\"Microsoft Family\"}},{\"@type\":\"ListItem\",\"@id\":\"https:\\\/\\\/SUMMALAI.COM\\\/?cat=10#listItem\",\"position\":2,\"name\":\"Microsoft Family\",\"item\":\"https:\\\/\\\/SUMMALAI.COM\\\/?cat=10\",\"nextItem\":{\"@type\":\"ListItem\",\"@id\":\"https:\\\/\\\/SUMMALAI.COM\\\/?cat=621#listItem\",\"name\":\"Power BI\"},\"previousItem\":{\"@type\":\"ListItem\",\"@id\":\"https:\\\/\\\/SUMMALAI.COM#listItem\",\"name\":\"Home\"}},{\"@type\":\"ListItem\",\"@id\":\"https:\\\/\\\/SUMMALAI.COM\\\/?cat=621#listItem\",\"position\":3,\"name\":\"Power BI\",\"item\":\"https:\\\/\\\/SUMMALAI.COM\\\/?cat=621\",\"nextItem\":{\"@type\":\"ListItem\",\"@id\":\"https:\\\/\\\/SUMMALAI.COM\\\/?p=3922#listItem\",\"name\":\"How to Enable &#8220;Assume referential integrity&#8221; to Speed Up DirectQuery\"},\"previousItem\":{\"@type\":\"ListItem\",\"@id\":\"https:\\\/\\\/SUMMALAI.COM\\\/?cat=10#listItem\",\"name\":\"Microsoft Family\"}},{\"@type\":\"ListItem\",\"@id\":\"https:\\\/\\\/SUMMALAI.COM\\\/?p=3922#listItem\",\"position\":4,\"name\":\"How to Enable &#8220;Assume referential integrity&#8221; to Speed Up DirectQuery\",\"previousItem\":{\"@type\":\"ListItem\",\"@id\":\"https:\\\/\\\/SUMMALAI.COM\\\/?cat=621#listItem\",\"name\":\"Power BI\"}}]},{\"@type\":\"Person\",\"@id\":\"https:\\\/\\\/SUMMALAI.COM\\\/#person\",\"name\":\"sladmin\",\"image\":{\"@type\":\"ImageObject\",\"@id\":\"https:\\\/\\\/SUMMALAI.COM\\\/?p=3922#personImage\",\"url\":\"https:\\\/\\\/SUMMALAI.COM\\\/wp-content\\\/uploads\\\/2020\\\/05\\\/Summa_Logo-150x150.png\",\"width\":96,\"height\":96,\"caption\":\"sladmin\"}},{\"@type\":\"Person\",\"@id\":\"https:\\\/\\\/SUMMALAI.COM\\\/?author=2#author\",\"url\":\"https:\\\/\\\/SUMMALAI.COM\\\/?author=2\",\"name\":\"Summa Lai\",\"image\":{\"@type\":\"ImageObject\",\"@id\":\"https:\\\/\\\/SUMMALAI.COM\\\/?p=3922#authorImage\",\"url\":\"https:\\\/\\\/SUMMALAI.COM\\\/wp-content\\\/uploads\\\/2020\\\/05\\\/Summa_Logo-150x150.png\",\"width\":96,\"height\":96,\"caption\":\"Summa Lai\"}},{\"@type\":\"WebPage\",\"@id\":\"https:\\\/\\\/SUMMALAI.COM\\\/?p=3922#webpage\",\"url\":\"https:\\\/\\\/SUMMALAI.COM\\\/?p=3922\",\"name\":\"How to Enable \\u201cAssume referential integrity\\u201d to Speed Up DirectQuery | Summa Lai\",\"description\":\"When connecting to a data source using DirectQuery, you can use the Assume Referential Integrity selection to enable running more efficient queries against your data source. This feature has a few requirements of the underlying data, and it is only available when using DirectQuery. Setting Assume referential integrity enables queries on the data source to use INNER JOIN statements rather than OUTER JOIN, which\",\"inLanguage\":\"en-US\",\"isPartOf\":{\"@id\":\"https:\\\/\\\/SUMMALAI.COM\\\/#website\"},\"breadcrumb\":{\"@id\":\"https:\\\/\\\/SUMMALAI.COM\\\/?p=3922#breadcrumblist\"},\"author\":{\"@id\":\"https:\\\/\\\/SUMMALAI.COM\\\/?author=2#author\"},\"creator\":{\"@id\":\"https:\\\/\\\/SUMMALAI.COM\\\/?author=2#author\"},\"datePublished\":\"2022-01-13T16:40:56-08:00\",\"dateModified\":\"2022-01-13T16:40:58-08:00\"},{\"@type\":\"WebSite\",\"@id\":\"https:\\\/\\\/SUMMALAI.COM\\\/#website\",\"url\":\"https:\\\/\\\/SUMMALAI.COM\\\/\",\"name\":\"Summa Lai\",\"description\":\"Never Stop Learning, Building a Little Wiki...\",\"inLanguage\":\"en-US\",\"publisher\":{\"@id\":\"https:\\\/\\\/SUMMALAI.COM\\\/#person\"}}]}\n\t\t<\/script>\n\t\t<!-- All in One SEO -->\n\n","aioseo_head_json":{"title":"How to Enable \u201cAssume referential integrity\u201d to Speed Up DirectQuery | Summa Lai","description":"When connecting to a data source using DirectQuery, you can use the Assume Referential Integrity selection to enable running more efficient queries against your data source. This feature has a few requirements of the underlying data, and it is only available when using DirectQuery. Setting Assume referential integrity enables queries on the data source to use INNER JOIN statements rather than OUTER JOIN, which","canonical_url":"https:\/\/SUMMALAI.COM\/?p=3922","robots":"max-image-preview:large","keywords":"assume referential integrity,speed up directquery,microsoft family,power bi","webmasterTools":{"miscellaneous":""},"schema":{"@context":"https:\/\/schema.org","@graph":[{"@type":"Article","@id":"https:\/\/SUMMALAI.COM\/?p=3922#article","name":"How to Enable \u201cAssume referential integrity\u201d to Speed Up DirectQuery | Summa Lai","headline":"How to Enable &#8220;Assume referential integrity&#8221; to Speed Up DirectQuery","author":{"@id":"https:\/\/SUMMALAI.COM\/?author=2#author"},"publisher":{"@id":"https:\/\/SUMMALAI.COM\/#person"},"image":{"@type":"ImageObject","url":"https:\/\/docs.microsoft.com\/en-us\/power-bi\/connect-data\/media\/desktop-assume-referential-integrity\/assume-referential-integrity_1.png","@id":"https:\/\/SUMMALAI.COM\/?p=3922\/#articleImage"},"datePublished":"2022-01-13T16:40:56-08:00","dateModified":"2022-01-13T16:40:58-08:00","inLanguage":"en-US","mainEntityOfPage":{"@id":"https:\/\/SUMMALAI.COM\/?p=3922#webpage"},"isPartOf":{"@id":"https:\/\/SUMMALAI.COM\/?p=3922#webpage"},"articleSection":"Microsoft Family, Power BI, Assume referential integrity, Speed Up DirectQuery"},{"@type":"BreadcrumbList","@id":"https:\/\/SUMMALAI.COM\/?p=3922#breadcrumblist","itemListElement":[{"@type":"ListItem","@id":"https:\/\/SUMMALAI.COM#listItem","position":1,"name":"Home","item":"https:\/\/SUMMALAI.COM","nextItem":{"@type":"ListItem","@id":"https:\/\/SUMMALAI.COM\/?cat=10#listItem","name":"Microsoft Family"}},{"@type":"ListItem","@id":"https:\/\/SUMMALAI.COM\/?cat=10#listItem","position":2,"name":"Microsoft Family","item":"https:\/\/SUMMALAI.COM\/?cat=10","nextItem":{"@type":"ListItem","@id":"https:\/\/SUMMALAI.COM\/?cat=621#listItem","name":"Power BI"},"previousItem":{"@type":"ListItem","@id":"https:\/\/SUMMALAI.COM#listItem","name":"Home"}},{"@type":"ListItem","@id":"https:\/\/SUMMALAI.COM\/?cat=621#listItem","position":3,"name":"Power BI","item":"https:\/\/SUMMALAI.COM\/?cat=621","nextItem":{"@type":"ListItem","@id":"https:\/\/SUMMALAI.COM\/?p=3922#listItem","name":"How to Enable &#8220;Assume referential integrity&#8221; to Speed Up DirectQuery"},"previousItem":{"@type":"ListItem","@id":"https:\/\/SUMMALAI.COM\/?cat=10#listItem","name":"Microsoft Family"}},{"@type":"ListItem","@id":"https:\/\/SUMMALAI.COM\/?p=3922#listItem","position":4,"name":"How to Enable &#8220;Assume referential integrity&#8221; to Speed Up DirectQuery","previousItem":{"@type":"ListItem","@id":"https:\/\/SUMMALAI.COM\/?cat=621#listItem","name":"Power BI"}}]},{"@type":"Person","@id":"https:\/\/SUMMALAI.COM\/#person","name":"sladmin","image":{"@type":"ImageObject","@id":"https:\/\/SUMMALAI.COM\/?p=3922#personImage","url":"https:\/\/SUMMALAI.COM\/wp-content\/uploads\/2020\/05\/Summa_Logo-150x150.png","width":96,"height":96,"caption":"sladmin"}},{"@type":"Person","@id":"https:\/\/SUMMALAI.COM\/?author=2#author","url":"https:\/\/SUMMALAI.COM\/?author=2","name":"Summa Lai","image":{"@type":"ImageObject","@id":"https:\/\/SUMMALAI.COM\/?p=3922#authorImage","url":"https:\/\/SUMMALAI.COM\/wp-content\/uploads\/2020\/05\/Summa_Logo-150x150.png","width":96,"height":96,"caption":"Summa Lai"}},{"@type":"WebPage","@id":"https:\/\/SUMMALAI.COM\/?p=3922#webpage","url":"https:\/\/SUMMALAI.COM\/?p=3922","name":"How to Enable \u201cAssume referential integrity\u201d to Speed Up DirectQuery | Summa Lai","description":"When connecting to a data source using DirectQuery, you can use the Assume Referential Integrity selection to enable running more efficient queries against your data source. This feature has a few requirements of the underlying data, and it is only available when using DirectQuery. Setting Assume referential integrity enables queries on the data source to use INNER JOIN statements rather than OUTER JOIN, which","inLanguage":"en-US","isPartOf":{"@id":"https:\/\/SUMMALAI.COM\/#website"},"breadcrumb":{"@id":"https:\/\/SUMMALAI.COM\/?p=3922#breadcrumblist"},"author":{"@id":"https:\/\/SUMMALAI.COM\/?author=2#author"},"creator":{"@id":"https:\/\/SUMMALAI.COM\/?author=2#author"},"datePublished":"2022-01-13T16:40:56-08:00","dateModified":"2022-01-13T16:40:58-08:00"},{"@type":"WebSite","@id":"https:\/\/SUMMALAI.COM\/#website","url":"https:\/\/SUMMALAI.COM\/","name":"Summa Lai","description":"Never Stop Learning, Building a Little Wiki...","inLanguage":"en-US","publisher":{"@id":"https:\/\/SUMMALAI.COM\/#person"}}]}},"aioseo_meta_data":{"post_id":"3922","title":null,"description":null,"keywords":[],"keyphrases":{"focus":[],"additional":[]},"primary_term":null,"canonical_url":null,"og_title":null,"og_description":null,"og_object_type":"default","og_image_type":"default","og_image_url":null,"og_image_width":null,"og_image_height":null,"og_image_custom_url":null,"og_image_custom_fields":null,"og_video":"","og_custom_url":null,"og_article_section":null,"og_article_tags":[],"twitter_use_og":false,"twitter_card":"default","twitter_image_type":"default","twitter_image_url":null,"twitter_image_custom_url":null,"twitter_image_custom_fields":null,"twitter_title":null,"twitter_description":null,"schema":{"blockGraphs":[],"customGraphs":[],"default":{"data":{"Article":{"id":"#aioseo-article-65a0cdcf5eea2","slug":"article","graphName":"Article","label":"Article","properties":{"type":"BlogPosting","name":"#post_title","headline":"#post_title","description":"#post_excerpt","image":"","keywords":"","author":{"name":"#author_name","url":"#author_url"},"dates":{"include":true,"datePublished":"","dateModified":""}}},"Course":[],"Dataset":[],"FAQPage":[],"Movie":[],"Person":[],"Product":[],"ProductReview":[],"Car":[],"Recipe":[],"Service":[],"SoftwareApplication":[],"WebPage":[]},"graphName":"Article","isEnabled":true},"graphs":[]},"schema_type":"default","schema_type_options":"{\"article\":{\"articleType\":\"BlogPosting\"},\"course\":{\"name\":\"\",\"description\":\"\",\"provider\":\"\"},\"faq\":{\"pages\":[]},\"product\":{\"reviews\":[]},\"recipe\":{\"ingredients\":[],\"instructions\":[],\"keywords\":[]},\"software\":{\"reviews\":[],\"operatingSystems\":[]},\"webPage\":{\"webPageType\":\"WebPage\"}}","pillar_content":false,"robots_default":true,"robots_noindex":false,"robots_noarchive":false,"robots_nosnippet":false,"robots_nofollow":false,"robots_noimageindex":false,"robots_noodp":false,"robots_notranslate":false,"robots_max_snippet":"-1","robots_max_videopreview":"-1","robots_max_imagepreview":"large","priority":null,"frequency":"default","local_seo":null,"breadcrumb_settings":null,"limit_modified_date":false,"ai":null,"created":"2022-01-14 00:38:00","updated":"2024-01-12 05:27:43","seo_analyzer_scan_date":null},"aioseo_breadcrumb":"<div class=\"aioseo-breadcrumbs\"><span class=\"aioseo-breadcrumb\">\n\t\t\t<a href=\"https:\/\/SUMMALAI.COM\" title=\"Home\">Home<\/a>\n\t\t<\/span><span class=\"aioseo-breadcrumb-separator\">&raquo;<\/span><span class=\"aioseo-breadcrumb\">\n\t\t\t<a href=\"https:\/\/SUMMALAI.COM\/?cat=10\" title=\"Microsoft Family\">Microsoft Family<\/a>\n\t\t<\/span><span class=\"aioseo-breadcrumb-separator\">&raquo;<\/span><span class=\"aioseo-breadcrumb\">\n\t\t\t<a href=\"https:\/\/SUMMALAI.COM\/?cat=621\" title=\"Power BI\">Power BI<\/a>\n\t\t<\/span><span class=\"aioseo-breadcrumb-separator\">&raquo;<\/span><span class=\"aioseo-breadcrumb\">\n\t\t\tHow to Enable \u201cAssume referential integrity\u201d to Speed Up DirectQuery\n\t\t<\/span><\/div>","aioseo_breadcrumb_json":[{"label":"Home","link":"https:\/\/SUMMALAI.COM"},{"label":"Microsoft Family","link":"https:\/\/SUMMALAI.COM\/?cat=10"},{"label":"Power BI","link":"https:\/\/SUMMALAI.COM\/?cat=621"},{"label":"How to Enable &#8220;Assume referential integrity&#8221; to Speed Up DirectQuery","link":"https:\/\/SUMMALAI.COM\/?p=3922"}],"_links":{"self":[{"href":"https:\/\/SUMMALAI.COM\/index.php?rest_route=\/wp\/v2\/posts\/3922","targetHints":{"allow":["GET"]}}],"collection":[{"href":"https:\/\/SUMMALAI.COM\/index.php?rest_route=\/wp\/v2\/posts"}],"about":[{"href":"https:\/\/SUMMALAI.COM\/index.php?rest_route=\/wp\/v2\/types\/post"}],"author":[{"embeddable":true,"href":"https:\/\/SUMMALAI.COM\/index.php?rest_route=\/wp\/v2\/users\/2"}],"replies":[{"embeddable":true,"href":"https:\/\/SUMMALAI.COM\/index.php?rest_route=%2Fwp%2Fv2%2Fcomments&post=3922"}],"version-history":[{"count":1,"href":"https:\/\/SUMMALAI.COM\/index.php?rest_route=\/wp\/v2\/posts\/3922\/revisions"}],"predecessor-version":[{"id":3923,"href":"https:\/\/SUMMALAI.COM\/index.php?rest_route=\/wp\/v2\/posts\/3922\/revisions\/3923"}],"wp:attachment":[{"href":"https:\/\/SUMMALAI.COM\/index.php?rest_route=%2Fwp%2Fv2%2Fmedia&parent=3922"}],"wp:term":[{"taxonomy":"category","embeddable":true,"href":"https:\/\/SUMMALAI.COM\/index.php?rest_route=%2Fwp%2Fv2%2Fcategories&post=3922"},{"taxonomy":"post_tag","embeddable":true,"href":"https:\/\/SUMMALAI.COM\/index.php?rest_route=%2Fwp%2Fv2%2Ftags&post=3922"}],"curies":[{"name":"wp","href":"https:\/\/api.w.org\/{rel}","templated":true}]}}