{"id":13191,"date":"2018-10-22T17:43:46","date_gmt":"2018-10-22T12:13:46","guid":{"rendered":"https:\/\/www.inogic.com\/blog\/?p=13191"},"modified":"2022-07-01T14:47:12","modified_gmt":"2022-07-01T09:17:12","slug":"working-on-lookup-field-of-dynamics-365-in-power-bi","status":"publish","type":"post","link":"https:\/\/www.inogic.com\/blog\/2018\/10\/working-on-lookup-field-of-dynamics-365-in-power-bi\/","title":{"rendered":"Working on Lookup field of Dynamics 365 in Power BI"},"content":{"rendered":"<h2><strong>Introduction:<\/strong><\/h2>\n<p style=\"text-align: justify;\">Recently, we had a business requirement to show lookup fields name in our Power BI Reports. In Power BI Lookup columns show its guid and not name. So after some research and play around we found a solution to this problem.<\/p>\n<p style=\"text-align: justify;\">We achieved it by using LOOKUPVALUE function.<\/p>\n<p style=\"text-align: justify;\">Here as you can see in below screenshot Primary Contact is showing with guid and not directly with name on Account table, so to show lookup value with name instead of guid, we can make use of <strong>LOOKUPVALUE function<\/strong> in our report.<\/p>\n<p style=\"text-align: justify;\"><img decoding=\"async\" class=\"aligncenter wp-image-13193\" style=\"border: 1px solid #0a0a0a; padding: 1px; margin: 1px;\" src=\"https:\/\/www.inogic.com\/blog\/wp-content\/uploads\/2018\/10\/1Working-on-Lookup-field-of-Dynamics-365-in-Power-BI.png\" alt=\"Working on Lookup field of Dynamics 365 in Power BI\" width=\"967\" height=\"330\" \/><\/p>\n<h2>Steps to show Lookup name:<\/h2>\n<p><strong>1<\/strong>. At first Add new column for the lookup field. In Our case field is primary contact. please check below screenshot:<\/p>\n<p style=\"padding-left: 180px;\"><img decoding=\"async\" class=\"aligncenter size-full wp-image-13194\" style=\"border: 1px solid #0a0a0a; padding: 1px; margin: 1px;\" src=\"https:\/\/www.inogic.com\/blog\/wp-content\/uploads\/2018\/10\/2Working-on-Lookup-field-of-Dynamics-365-in-Power-BI.png\" alt=\"Working on Lookup field of Dynamics 365 in Power BI\" width=\"265\" height=\"287\" \/><\/p>\n<p><strong>2<\/strong>. Now we can set LOOKUPVALUE function on our newly created column above, as you can see in our below screenshots:<\/p>\n<ul>\n<li>Once we added new column in table it looks like as below:<\/li>\n<\/ul>\n<p><img decoding=\"async\" class=\"aligncenter wp-image-13195\" style=\"border: 1px solid #0a0a0a; padding: 1px; margin: 1px;\" src=\"https:\/\/www.inogic.com\/blog\/wp-content\/uploads\/2018\/10\/3Working-on-Lookup-field-of-Dynamics-365-in-Power-BI.png\" alt=\"Working on Lookup field of Dynamics 365 in Power BI\" width=\"971\" height=\"327\" \/><\/p>\n<ul>\n<li>Now in the second step, we need to implement LOOKUPVALUE function in our column. You can also change the name of column. In our case we have changed it with Primary Contact.<\/li>\n<\/ul>\n<p><img decoding=\"async\" class=\"aligncenter wp-image-13196\" style=\"border: 1px solid #0a0a0a; padding: 1px; margin: 1px;\" src=\"https:\/\/www.inogic.com\/blog\/wp-content\/uploads\/2018\/10\/4Working-on-Lookup-field-of-Dynamics-365-in-Power-BI.png\" alt=\"Working on Lookup field of Dynamics 365 in Power BI\" width=\"965\" height=\"248\" \/><\/p>\n<p style=\"padding-left: 90px;\">a.\u00a0LOOKUPValue(Target table result field, Target table key, Source table matching key as on Target table)<\/p>\n<p style=\"padding-left: 90px;\">b. For Example In Our case the expression look like below: LOOKUPValue(contacts[fullname],contacts[contactid],accounts[_primarycontactid_value])<\/p>\n<ul>\n<li>Once done with it we will save it by clicking on icon highlighted in red rectangle below:<\/li>\n<\/ul>\n<p><img decoding=\"async\" class=\"aligncenter wp-image-13197\" style=\"border: 1px solid #0a0a0a; padding: 1px; margin: 1px;\" src=\"https:\/\/www.inogic.com\/blog\/wp-content\/uploads\/2018\/10\/5Working-on-Lookup-field-of-Dynamics-365-in-Power-BI.png\" alt=\"Working on Lookup field of Dynamics 365 in Power BI\" width=\"967\" height=\"231\" \/><\/p>\n<p><strong>3<\/strong>. Now as you can see in below screenshot Primary Contact names are added in newly created columns i.e. Primary Contact.<\/p>\n<p style=\"padding-left: 240px;\"><img decoding=\"async\" class=\"aligncenter wp-image-13198\" style=\"border: 1px solid #0a0a0a; padding: 1px; margin: 1px;\" src=\"https:\/\/www.inogic.com\/blog\/wp-content\/uploads\/2018\/10\/6Working-on-Lookup-field-of-Dynamics-365-in-Power-BI.png\" alt=\"Working on Lookup field of Dynamics 365 in Power BI\" width=\"215\" height=\"227\" \/><\/p>\n<h2><strong>Conclusion:\u00a0 <\/strong><\/h2>\n<p>With the above simple steps and using LOOKUPVALUE function we can show data from other table easily without having any relationship, but make sure that there should be common key present in both tables.<\/p>\n<h2 style=\"text-align: left;\"><div class=\"su-heading su-heading-style-default su-heading-align-center\" id=\"\" style=\"font-size:15px;margin-bottom:5px\"><div class=\"su-heading-inner\">One Pic = 1000 words! Analyze data 90% faster with visualization apps!<\/div><\/div><\/h2>\n<p style=\"text-align: left;\"><em>Get optimum visualization of Dynamics 365 CRM data with &#8211;<\/em><br \/>\n<em><strong><a href=\"https:\/\/bit.ly\/3lYvozZ\" target=\"_blank\" rel=\"noopener noreferrer\">Kanban Board<\/a> <\/strong>\u2013 Visualize Dynamics 365 CRM data in Kanban view by categorizing entity records in lanes and rows as per their status, priority, etc.<\/em><br \/>\n<em><strong><a href=\"https:\/\/bit.ly\/3lCSBaA\" target=\"_blank\" rel=\"noopener noreferrer\">Map My Relationships<\/a><\/strong> \u2013 Map My Relationships \u2013 Visualize connections and relationships between Dynamics 365 CRM entities or related records in a Mind Map view.<\/em><\/p>\n","protected":false},"excerpt":{"rendered":"<p>Introduction: Recently, we had a business requirement to show lookup fields name in our Power BI Reports. In Power BI Lookup columns show its guid and not name. So after some research and play around we found a solution to this problem. We achieved it by using LOOKUPVALUE function. Here as you can see in\u2026 <span class=\"read-more\"><a href=\"https:\/\/www.inogic.com\/blog\/2018\/10\/working-on-lookup-field-of-dynamics-365-in-power-bi\/\">Read More: Working on Lookup field of Dynamics 365 in Power BI &raquo;<\/a><\/span><\/p>\n","protected":false},"author":13,"featured_media":13192,"comment_status":"closed","ping_status":"closed","sticky":false,"template":"","format":"standard","meta":{"footnotes":""},"categories":[16,19,45],"tags":[559,643,1018,1019],"class_list":["post-13191","post","type-post","status-publish","format-standard","has-post-thumbnail","hentry","category-dynamics-365","category-dynamics-crm","category-power-bi","tag-dynamics-365-in-power-bi","tag-dynamics-crm-in-power-bi","tag-lookup-field-of-dynamics-365-in-power-bi","tag-lookup-field-of-dynamics-crm-in-power-bi"],"aioseo_notices":[],"aioseo_head":"\n\t\t<!-- All in One SEO 4.9.8 - aioseo.com -->\n\t<meta name=\"description\" content=\"With the provided simple steps and using LOOKUPVALUE function we can show data from other table easily without having any relationship, but make sure that there should be common key present in both tables.\" \/>\n\t<meta name=\"robots\" content=\"max-image-preview:large\" \/>\n\t<meta name=\"author\" content=\"Inogic\"\/>\n\t<link rel=\"canonical\" href=\"https:\/\/www.inogic.com\/blog\/2018\/10\/working-on-lookup-field-of-dynamics-365-in-power-bi\/\" \/>\n\t<meta name=\"generator\" content=\"All in One SEO (AIOSEO) 4.9.8\" \/>\n\t\t<meta property=\"og:locale\" content=\"en_US\" \/>\n\t\t<meta property=\"og:site_name\" content=\"Microsoft Dynamics 365 CRM Tips and Tricks - By Inogic\" \/>\n\t\t<meta property=\"og:type\" content=\"article\" \/>\n\t\t<meta property=\"og:title\" content=\"Working on Lookup field of Dynamics 365 in Power BI - Microsoft Dynamics 365 CRM Tips and Tricks\" \/>\n\t\t<meta property=\"og:description\" content=\"With the provided simple steps and using LOOKUPVALUE function we can show data from other table easily without having any relationship, but make sure that there should be common key present in both tables.\" \/>\n\t\t<meta property=\"og:url\" content=\"https:\/\/www.inogic.com\/blog\/2018\/10\/working-on-lookup-field-of-dynamics-365-in-power-bi\/\" \/>\n\t\t<meta property=\"og:image\" content=\"https:\/\/www.inogic.com\/blog\/wp-content\/uploads\/2018\/10\/1Working-on-Lookup-field-of-Dynamics-365-in-Power-BI.png\" \/>\n\t\t<meta property=\"og:image:secure_url\" content=\"https:\/\/www.inogic.com\/blog\/wp-content\/uploads\/2018\/10\/1Working-on-Lookup-field-of-Dynamics-365-in-Power-BI.png\" \/>\n\t\t<meta property=\"article:published_time\" content=\"2018-10-22T12:13:46+00:00\" \/>\n\t\t<meta property=\"article:modified_time\" content=\"2022-07-01T09:17:12+00:00\" \/>\n\t\t<meta property=\"article:publisher\" content=\"https:\/\/www.facebook.com\/inogicindia\" \/>\n\t\t<meta name=\"twitter:card\" content=\"summary_large_image\" \/>\n\t\t<meta name=\"twitter:site\" content=\"@inogic\" \/>\n\t\t<meta name=\"twitter:title\" content=\"Working on Lookup field of Dynamics 365 in Power BI - Microsoft Dynamics 365 CRM Tips and Tricks\" \/>\n\t\t<meta name=\"twitter:description\" content=\"With the provided simple steps and using LOOKUPVALUE function we can show data from other table easily without having any relationship, but make sure that there should be common key present in both tables.\" \/>\n\t\t<meta name=\"twitter:creator\" content=\"@inogic\" \/>\n\t\t<meta name=\"twitter:image\" content=\"https:\/\/www.inogic.com\/blog\/wp-content\/uploads\/2018\/10\/1Working-on-Lookup-field-of-Dynamics-365-in-Power-BI.png\" \/>\n\t\t<meta name=\"twitter:label1\" content=\"Written by\" \/>\n\t\t<meta name=\"twitter:data1\" content=\"Inogic\" \/>\n\t\t<meta name=\"twitter:label2\" content=\"Est. reading time\" \/>\n\t\t<meta name=\"twitter:data2\" content=\"2 minutes\" \/>\n\t\t<script type=\"application\/ld+json\" class=\"aioseo-schema\">\n\t\t\t{\"@context\":\"https:\\\/\\\/schema.org\",\"@graph\":[{\"@type\":\"BlogPosting\",\"@id\":\"https:\\\/\\\/www.inogic.com\\\/blog\\\/2018\\\/10\\\/working-on-lookup-field-of-dynamics-365-in-power-bi\\\/#blogposting\",\"name\":\"Working on Lookup field of Dynamics 365 in Power BI - Microsoft Dynamics 365 CRM Tips and Tricks\",\"headline\":\"Working on Lookup field of Dynamics 365 in Power BI\",\"author\":{\"@id\":\"https:\\\/\\\/www.inogic.com\\\/blog\\\/author\\\/inogic-2\\\/#author\"},\"publisher\":{\"@id\":\"https:\\\/\\\/www.inogic.com\\\/blog\\\/#organization\"},\"image\":{\"@type\":\"ImageObject\",\"url\":\"https:\\\/\\\/www.inogic.com\\\/blog\\\/wp-content\\\/uploads\\\/2018\\\/10\\\/How-to-work-on-Lookup-field-of-Dynamics365-In-PowerBI-1-1.png\",\"width\":150,\"height\":150,\"caption\":\"How to work on Lookup field of Dynamics365 In PowerBI\"},\"datePublished\":\"2018-10-22T17:43:46+05:30\",\"dateModified\":\"2022-07-01T14:47:12+05:30\",\"inLanguage\":\"en-US\",\"mainEntityOfPage\":{\"@id\":\"https:\\\/\\\/www.inogic.com\\\/blog\\\/2018\\\/10\\\/working-on-lookup-field-of-dynamics-365-in-power-bi\\\/#webpage\"},\"isPartOf\":{\"@id\":\"https:\\\/\\\/www.inogic.com\\\/blog\\\/2018\\\/10\\\/working-on-lookup-field-of-dynamics-365-in-power-bi\\\/#webpage\"},\"articleSection\":\"Dynamics 365, Dynamics CRM, Power BI, Dynamics 365 in Power BI, Dynamics CRM in Power BI, Lookup field of Dynamics 365 in Power BI, Lookup field of Dynamics CRM in Power BI\"},{\"@type\":\"BreadcrumbList\",\"@id\":\"https:\\\/\\\/www.inogic.com\\\/blog\\\/2018\\\/10\\\/working-on-lookup-field-of-dynamics-365-in-power-bi\\\/#breadcrumblist\",\"itemListElement\":[{\"@type\":\"ListItem\",\"@id\":\"https:\\\/\\\/www.inogic.com\\\/blog#listItem\",\"position\":1,\"name\":\"Home\",\"item\":\"https:\\\/\\\/www.inogic.com\\\/blog\",\"nextItem\":{\"@type\":\"ListItem\",\"@id\":\"https:\\\/\\\/www.inogic.com\\\/blog\\\/category\\\/dynamics-365\\\/#listItem\",\"name\":\"Dynamics 365\"}},{\"@type\":\"ListItem\",\"@id\":\"https:\\\/\\\/www.inogic.com\\\/blog\\\/category\\\/dynamics-365\\\/#listItem\",\"position\":2,\"name\":\"Dynamics 365\",\"item\":\"https:\\\/\\\/www.inogic.com\\\/blog\\\/category\\\/dynamics-365\\\/\",\"nextItem\":{\"@type\":\"ListItem\",\"@id\":\"https:\\\/\\\/www.inogic.com\\\/blog\\\/2018\\\/10\\\/working-on-lookup-field-of-dynamics-365-in-power-bi\\\/#listItem\",\"name\":\"Working on Lookup field of Dynamics 365 in Power BI\"},\"previousItem\":{\"@type\":\"ListItem\",\"@id\":\"https:\\\/\\\/www.inogic.com\\\/blog#listItem\",\"name\":\"Home\"}},{\"@type\":\"ListItem\",\"@id\":\"https:\\\/\\\/www.inogic.com\\\/blog\\\/2018\\\/10\\\/working-on-lookup-field-of-dynamics-365-in-power-bi\\\/#listItem\",\"position\":3,\"name\":\"Working on Lookup field of Dynamics 365 in Power BI\",\"previousItem\":{\"@type\":\"ListItem\",\"@id\":\"https:\\\/\\\/www.inogic.com\\\/blog\\\/category\\\/dynamics-365\\\/#listItem\",\"name\":\"Dynamics 365\"}}]},{\"@type\":\"Organization\",\"@id\":\"https:\\\/\\\/www.inogic.com\\\/blog\\\/#organization\",\"name\":\"Microsoft Dynamics 365 CRM Tips and Tricks\",\"description\":\"By Inogic\",\"url\":\"https:\\\/\\\/www.inogic.com\\\/blog\\\/\",\"logo\":{\"@type\":\"ImageObject\",\"url\":\"https:\\\/\\\/www.inogic.com\\\/blog\\\/wp-content\\\/uploads\\\/2023\\\/02\\\/inogic-logo.png\",\"@id\":\"https:\\\/\\\/www.inogic.com\\\/blog\\\/2018\\\/10\\\/working-on-lookup-field-of-dynamics-365-in-power-bi\\\/#organizationLogo\",\"width\":1000,\"height\":325,\"caption\":\"inogic logo\"},\"image\":{\"@id\":\"https:\\\/\\\/www.inogic.com\\\/blog\\\/2018\\\/10\\\/working-on-lookup-field-of-dynamics-365-in-power-bi\\\/#organizationLogo\"},\"sameAs\":[\"https:\\\/\\\/www.facebook.com\\\/inogicindia\",\"https:\\\/\\\/twitter.com\\\/inogic\",\"https:\\\/\\\/www.instagram.com\\\/inogicindia\\\/\",\"https:\\\/\\\/www.youtube.com\\\/channel\\\/UCM4V7ousgLSu1hbOEv4DUuQ\",\"https:\\\/\\\/www.linkedin.com\\\/company\\\/inogicindia\"]},{\"@type\":\"Person\",\"@id\":\"https:\\\/\\\/www.inogic.com\\\/blog\\\/author\\\/inogic-2\\\/#author\",\"url\":\"https:\\\/\\\/www.inogic.com\\\/blog\\\/author\\\/inogic-2\\\/\",\"name\":\"Inogic\",\"image\":{\"@type\":\"ImageObject\",\"@id\":\"https:\\\/\\\/www.inogic.com\\\/blog\\\/2018\\\/10\\\/working-on-lookup-field-of-dynamics-365-in-power-bi\\\/#authorImage\",\"url\":\"https:\\\/\\\/secure.gravatar.com\\\/avatar\\\/839d9ae7d2b941d2d09e91df322267a429821f2ce5494302b53bd5ca3679f1a0?s=96&d=mm&r=g\",\"width\":96,\"height\":96,\"caption\":\"Inogic\"}},{\"@type\":\"WebPage\",\"@id\":\"https:\\\/\\\/www.inogic.com\\\/blog\\\/2018\\\/10\\\/working-on-lookup-field-of-dynamics-365-in-power-bi\\\/#webpage\",\"url\":\"https:\\\/\\\/www.inogic.com\\\/blog\\\/2018\\\/10\\\/working-on-lookup-field-of-dynamics-365-in-power-bi\\\/\",\"name\":\"Working on Lookup field of Dynamics 365 in Power BI - Microsoft Dynamics 365 CRM Tips and Tricks\",\"description\":\"With the provided simple steps and using LOOKUPVALUE function we can show data from other table easily without having any relationship, but make sure that there should be common key present in both tables.\",\"inLanguage\":\"en-US\",\"isPartOf\":{\"@id\":\"https:\\\/\\\/www.inogic.com\\\/blog\\\/#website\"},\"breadcrumb\":{\"@id\":\"https:\\\/\\\/www.inogic.com\\\/blog\\\/2018\\\/10\\\/working-on-lookup-field-of-dynamics-365-in-power-bi\\\/#breadcrumblist\"},\"author\":{\"@id\":\"https:\\\/\\\/www.inogic.com\\\/blog\\\/author\\\/inogic-2\\\/#author\"},\"creator\":{\"@id\":\"https:\\\/\\\/www.inogic.com\\\/blog\\\/author\\\/inogic-2\\\/#author\"},\"image\":{\"@type\":\"ImageObject\",\"url\":\"https:\\\/\\\/www.inogic.com\\\/blog\\\/wp-content\\\/uploads\\\/2018\\\/10\\\/How-to-work-on-Lookup-field-of-Dynamics365-In-PowerBI-1-1.png\",\"@id\":\"https:\\\/\\\/www.inogic.com\\\/blog\\\/2018\\\/10\\\/working-on-lookup-field-of-dynamics-365-in-power-bi\\\/#mainImage\",\"width\":150,\"height\":150,\"caption\":\"How to work on Lookup field of Dynamics365 In PowerBI\"},\"primaryImageOfPage\":{\"@id\":\"https:\\\/\\\/www.inogic.com\\\/blog\\\/2018\\\/10\\\/working-on-lookup-field-of-dynamics-365-in-power-bi\\\/#mainImage\"},\"datePublished\":\"2018-10-22T17:43:46+05:30\",\"dateModified\":\"2022-07-01T14:47:12+05:30\"},{\"@type\":\"WebSite\",\"@id\":\"https:\\\/\\\/www.inogic.com\\\/blog\\\/#website\",\"url\":\"https:\\\/\\\/www.inogic.com\\\/blog\\\/\",\"name\":\"Microsoft Dynamics 365 CRM Tips and Tricks\",\"alternateName\":\"Inogic\",\"description\":\"By Inogic\",\"inLanguage\":\"en-US\",\"publisher\":{\"@id\":\"https:\\\/\\\/www.inogic.com\\\/blog\\\/#organization\"}}]}\n\t\t<\/script>\n\t\t<!-- All in One SEO -->\n\n","aioseo_head_json":{"title":"Working on Lookup field of Dynamics 365 in Power BI - Microsoft Dynamics 365 CRM Tips and Tricks","description":"With the provided simple steps and using LOOKUPVALUE function we can show data from other table easily without having any relationship, but make sure that there should be common key present in both tables.","canonical_url":"https:\/\/www.inogic.com\/blog\/2018\/10\/working-on-lookup-field-of-dynamics-365-in-power-bi\/","robots":"max-image-preview:large","keywords":"","webmasterTools":{"miscellaneous":""},"schema":{"@context":"https:\/\/schema.org","@graph":[{"@type":"BlogPosting","@id":"https:\/\/www.inogic.com\/blog\/2018\/10\/working-on-lookup-field-of-dynamics-365-in-power-bi\/#blogposting","name":"Working on Lookup field of Dynamics 365 in Power BI - Microsoft Dynamics 365 CRM Tips and Tricks","headline":"Working on Lookup field of Dynamics 365 in Power BI","author":{"@id":"https:\/\/www.inogic.com\/blog\/author\/inogic-2\/#author"},"publisher":{"@id":"https:\/\/www.inogic.com\/blog\/#organization"},"image":{"@type":"ImageObject","url":"https:\/\/www.inogic.com\/blog\/wp-content\/uploads\/2018\/10\/How-to-work-on-Lookup-field-of-Dynamics365-In-PowerBI-1-1.png","width":150,"height":150,"caption":"How to work on Lookup field of Dynamics365 In PowerBI"},"datePublished":"2018-10-22T17:43:46+05:30","dateModified":"2022-07-01T14:47:12+05:30","inLanguage":"en-US","mainEntityOfPage":{"@id":"https:\/\/www.inogic.com\/blog\/2018\/10\/working-on-lookup-field-of-dynamics-365-in-power-bi\/#webpage"},"isPartOf":{"@id":"https:\/\/www.inogic.com\/blog\/2018\/10\/working-on-lookup-field-of-dynamics-365-in-power-bi\/#webpage"},"articleSection":"Dynamics 365, Dynamics CRM, Power BI, Dynamics 365 in Power BI, Dynamics CRM in Power BI, Lookup field of Dynamics 365 in Power BI, Lookup field of Dynamics CRM in Power BI"},{"@type":"BreadcrumbList","@id":"https:\/\/www.inogic.com\/blog\/2018\/10\/working-on-lookup-field-of-dynamics-365-in-power-bi\/#breadcrumblist","itemListElement":[{"@type":"ListItem","@id":"https:\/\/www.inogic.com\/blog#listItem","position":1,"name":"Home","item":"https:\/\/www.inogic.com\/blog","nextItem":{"@type":"ListItem","@id":"https:\/\/www.inogic.com\/blog\/category\/dynamics-365\/#listItem","name":"Dynamics 365"}},{"@type":"ListItem","@id":"https:\/\/www.inogic.com\/blog\/category\/dynamics-365\/#listItem","position":2,"name":"Dynamics 365","item":"https:\/\/www.inogic.com\/blog\/category\/dynamics-365\/","nextItem":{"@type":"ListItem","@id":"https:\/\/www.inogic.com\/blog\/2018\/10\/working-on-lookup-field-of-dynamics-365-in-power-bi\/#listItem","name":"Working on Lookup field of Dynamics 365 in Power BI"},"previousItem":{"@type":"ListItem","@id":"https:\/\/www.inogic.com\/blog#listItem","name":"Home"}},{"@type":"ListItem","@id":"https:\/\/www.inogic.com\/blog\/2018\/10\/working-on-lookup-field-of-dynamics-365-in-power-bi\/#listItem","position":3,"name":"Working on Lookup field of Dynamics 365 in Power BI","previousItem":{"@type":"ListItem","@id":"https:\/\/www.inogic.com\/blog\/category\/dynamics-365\/#listItem","name":"Dynamics 365"}}]},{"@type":"Organization","@id":"https:\/\/www.inogic.com\/blog\/#organization","name":"Microsoft Dynamics 365 CRM Tips and Tricks","description":"By Inogic","url":"https:\/\/www.inogic.com\/blog\/","logo":{"@type":"ImageObject","url":"https:\/\/www.inogic.com\/blog\/wp-content\/uploads\/2023\/02\/inogic-logo.png","@id":"https:\/\/www.inogic.com\/blog\/2018\/10\/working-on-lookup-field-of-dynamics-365-in-power-bi\/#organizationLogo","width":1000,"height":325,"caption":"inogic logo"},"image":{"@id":"https:\/\/www.inogic.com\/blog\/2018\/10\/working-on-lookup-field-of-dynamics-365-in-power-bi\/#organizationLogo"},"sameAs":["https:\/\/www.facebook.com\/inogicindia","https:\/\/twitter.com\/inogic","https:\/\/www.instagram.com\/inogicindia\/","https:\/\/www.youtube.com\/channel\/UCM4V7ousgLSu1hbOEv4DUuQ","https:\/\/www.linkedin.com\/company\/inogicindia"]},{"@type":"Person","@id":"https:\/\/www.inogic.com\/blog\/author\/inogic-2\/#author","url":"https:\/\/www.inogic.com\/blog\/author\/inogic-2\/","name":"Inogic","image":{"@type":"ImageObject","@id":"https:\/\/www.inogic.com\/blog\/2018\/10\/working-on-lookup-field-of-dynamics-365-in-power-bi\/#authorImage","url":"https:\/\/secure.gravatar.com\/avatar\/839d9ae7d2b941d2d09e91df322267a429821f2ce5494302b53bd5ca3679f1a0?s=96&d=mm&r=g","width":96,"height":96,"caption":"Inogic"}},{"@type":"WebPage","@id":"https:\/\/www.inogic.com\/blog\/2018\/10\/working-on-lookup-field-of-dynamics-365-in-power-bi\/#webpage","url":"https:\/\/www.inogic.com\/blog\/2018\/10\/working-on-lookup-field-of-dynamics-365-in-power-bi\/","name":"Working on Lookup field of Dynamics 365 in Power BI - Microsoft Dynamics 365 CRM Tips and Tricks","description":"With the provided simple steps and using LOOKUPVALUE function we can show data from other table easily without having any relationship, but make sure that there should be common key present in both tables.","inLanguage":"en-US","isPartOf":{"@id":"https:\/\/www.inogic.com\/blog\/#website"},"breadcrumb":{"@id":"https:\/\/www.inogic.com\/blog\/2018\/10\/working-on-lookup-field-of-dynamics-365-in-power-bi\/#breadcrumblist"},"author":{"@id":"https:\/\/www.inogic.com\/blog\/author\/inogic-2\/#author"},"creator":{"@id":"https:\/\/www.inogic.com\/blog\/author\/inogic-2\/#author"},"image":{"@type":"ImageObject","url":"https:\/\/www.inogic.com\/blog\/wp-content\/uploads\/2018\/10\/How-to-work-on-Lookup-field-of-Dynamics365-In-PowerBI-1-1.png","@id":"https:\/\/www.inogic.com\/blog\/2018\/10\/working-on-lookup-field-of-dynamics-365-in-power-bi\/#mainImage","width":150,"height":150,"caption":"How to work on Lookup field of Dynamics365 In PowerBI"},"primaryImageOfPage":{"@id":"https:\/\/www.inogic.com\/blog\/2018\/10\/working-on-lookup-field-of-dynamics-365-in-power-bi\/#mainImage"},"datePublished":"2018-10-22T17:43:46+05:30","dateModified":"2022-07-01T14:47:12+05:30"},{"@type":"WebSite","@id":"https:\/\/www.inogic.com\/blog\/#website","url":"https:\/\/www.inogic.com\/blog\/","name":"Microsoft Dynamics 365 CRM Tips and Tricks","alternateName":"Inogic","description":"By Inogic","inLanguage":"en-US","publisher":{"@id":"https:\/\/www.inogic.com\/blog\/#organization"}}]},"og:locale":"en_US","og:site_name":"Microsoft Dynamics 365 CRM Tips and Tricks - By Inogic","og:type":"article","og:title":"Working on Lookup field of Dynamics 365 in Power BI - Microsoft Dynamics 365 CRM Tips and Tricks","og:description":"With the provided simple steps and using LOOKUPVALUE function we can show data from other table easily without having any relationship, but make sure that there should be common key present in both tables.","og:url":"https:\/\/www.inogic.com\/blog\/2018\/10\/working-on-lookup-field-of-dynamics-365-in-power-bi\/","og:image":"https:\/\/www.inogic.com\/blog\/wp-content\/uploads\/2018\/10\/1Working-on-Lookup-field-of-Dynamics-365-in-Power-BI.png","og:image:secure_url":"https:\/\/www.inogic.com\/blog\/wp-content\/uploads\/2018\/10\/1Working-on-Lookup-field-of-Dynamics-365-in-Power-BI.png","article:published_time":"2018-10-22T12:13:46+00:00","article:modified_time":"2022-07-01T09:17:12+00:00","article:publisher":"https:\/\/www.facebook.com\/inogicindia","twitter:card":"summary_large_image","twitter:site":"@inogic","twitter:title":"Working on Lookup field of Dynamics 365 in Power BI - Microsoft Dynamics 365 CRM Tips and Tricks","twitter:description":"With the provided simple steps and using LOOKUPVALUE function we can show data from other table easily without having any relationship, but make sure that there should be common key present in both tables.","twitter:creator":"@inogic","twitter:image":"https:\/\/www.inogic.com\/blog\/wp-content\/uploads\/2018\/10\/1Working-on-Lookup-field-of-Dynamics-365-in-Power-BI.png","twitter:label1":"Written by","twitter:data1":"Inogic","twitter:label2":"Est. reading time","twitter:data2":"2 minutes"},"aioseo_meta_data":{"post_id":"13191","title":null,"description":"With the provided simple steps and using LOOKUPVALUE function we can show data from other table easily without having any relationship, but make sure that there should be common key present in both tables.","keywords":null,"keyphrases":null,"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":null,"og_custom_url":null,"og_article_section":null,"og_article_tags":null,"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":[],"Course":[],"Dataset":[],"FAQPage":[],"Movie":[],"Person":[],"Product":[],"ProductReview":[],"Car":[],"Recipe":[],"Service":[],"SoftwareApplication":[],"WebPage":[]},"graphName":"","isEnabled":true},"graphs":[]},"schema_type":"default","schema_type_options":null,"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":null,"robots_max_videopreview":null,"robots_max_imagepreview":"large","priority":null,"frequency":null,"local_seo":null,"breadcrumb_settings":null,"limit_modified_date":false,"ai":null,"created":"2023-02-02 06:59:52","updated":"2025-07-04 05:15:02","seo_analyzer_scan_date":null},"aioseo_breadcrumb":"<div class=\"aioseo-breadcrumbs\"><span class=\"aioseo-breadcrumb\">\n\t\t\t<a href=\"https:\/\/www.inogic.com\/blog\" 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:\/\/www.inogic.com\/blog\/category\/dynamics-365\/\" title=\"Dynamics 365\">Dynamics 365<\/a>\n\t\t<\/span><span class=\"aioseo-breadcrumb-separator\">&raquo;<\/span><span class=\"aioseo-breadcrumb\">\n\t\t\tWorking on Lookup field of Dynamics 365 in Power BI\n\t\t<\/span><\/div>","aioseo_breadcrumb_json":[{"label":"Home","link":"https:\/\/www.inogic.com\/blog"},{"label":"Dynamics 365","link":"https:\/\/www.inogic.com\/blog\/category\/dynamics-365\/"},{"label":"Working on Lookup field of Dynamics 365 in Power BI","link":"https:\/\/www.inogic.com\/blog\/2018\/10\/working-on-lookup-field-of-dynamics-365-in-power-bi\/"}],"_links":{"self":[{"href":"https:\/\/www.inogic.com\/blog\/wp-json\/wp\/v2\/posts\/13191","targetHints":{"allow":["GET"]}}],"collection":[{"href":"https:\/\/www.inogic.com\/blog\/wp-json\/wp\/v2\/posts"}],"about":[{"href":"https:\/\/www.inogic.com\/blog\/wp-json\/wp\/v2\/types\/post"}],"author":[{"embeddable":true,"href":"https:\/\/www.inogic.com\/blog\/wp-json\/wp\/v2\/users\/13"}],"replies":[{"embeddable":true,"href":"https:\/\/www.inogic.com\/blog\/wp-json\/wp\/v2\/comments?post=13191"}],"version-history":[{"count":0,"href":"https:\/\/www.inogic.com\/blog\/wp-json\/wp\/v2\/posts\/13191\/revisions"}],"wp:featuredmedia":[{"embeddable":true,"href":"https:\/\/www.inogic.com\/blog\/wp-json\/wp\/v2\/media\/13192"}],"wp:attachment":[{"href":"https:\/\/www.inogic.com\/blog\/wp-json\/wp\/v2\/media?parent=13191"}],"wp:term":[{"taxonomy":"category","embeddable":true,"href":"https:\/\/www.inogic.com\/blog\/wp-json\/wp\/v2\/categories?post=13191"},{"taxonomy":"post_tag","embeddable":true,"href":"https:\/\/www.inogic.com\/blog\/wp-json\/wp\/v2\/tags?post=13191"}],"curies":[{"name":"wp","href":"https:\/\/api.w.org\/{rel}","templated":true}]}}