{"id":26668,"date":"2021-02-03T12:41:03","date_gmt":"2021-02-03T12:41:03","guid":{"rendered":"https:\/\/www.inogic.com\/blog\/?p=26668"},"modified":"2021-02-03T12:41:03","modified_gmt":"2021-02-03T12:41:03","slug":"how-to-show-images-uploaded-by-file-or-image-type-field-of-model-driven-apps-into-power-bi-report","status":"publish","type":"post","link":"https:\/\/www.inogic.com\/blog\/2021\/02\/how-to-show-images-uploaded-by-file-or-image-type-field-of-model-driven-apps-into-power-bi-report\/","title":{"rendered":"How to Show Images Uploaded by File or Image Type Field of Model Driven Apps into Power BI Report"},"content":{"rendered":"<h2>Introduction<\/h2>\n<p style=\"text-align: justify;\">Currently, we have a requirement where a client needs to upload a visiting card against their Account record and they need one Power BI Dashboard where their salesperson wants to see visiting cards for every Account. The client has stored the visiting image file into the Image data type of field.<\/p>\n<p style=\"text-align: justify;\">This blog will help to understand how to show images uploaded by the Image or File data type field of Dynamics 365 CRM into the Power BI report. You can learn more about File and Image type fields <a href=\"https:\/\/www.inogic.com\/blog\/2020\/04\/file-and-image-type-attributes-now-supported-in-model-driven-power-apps-with-2020-release-wave-1\/\" target=\"_blank\" rel=\"noopener noreferrer\">here<\/a>.<\/p>\n<p style=\"text-align: justify;\">When you add the Image type column in the Power BI report, it will just show the path of that file where it is stored.<\/p>\n<p style=\"text-align: justify;\">See the below screenshot for reference<\/p>\n<p><a href=\"https:\/\/www.inogic.com\/blog\/wp-content\/uploads\/2021\/02\/1-show-images-uploaded-by-Image-or-File-data-type-field.png\" target=\"_blank\" rel=\"noopener noreferrer\"><img decoding=\"async\" class=\"aligncenter wp-image-26669 size-full\" src=\"https:\/\/www.inogic.com\/blog\/wp-content\/uploads\/2021\/02\/1-show-images-uploaded-by-Image-or-File-data-type-field.png\" alt=\"show Images uploaded by File or Image type field \" width=\"1094\" height=\"321\" srcset=\"https:\/\/www.inogic.com\/blog\/wp-content\/uploads\/2021\/02\/1-show-images-uploaded-by-Image-or-File-data-type-field.png 1094w, https:\/\/www.inogic.com\/blog\/wp-content\/uploads\/2021\/02\/1-show-images-uploaded-by-Image-or-File-data-type-field-300x88.png 300w, https:\/\/www.inogic.com\/blog\/wp-content\/uploads\/2021\/02\/1-show-images-uploaded-by-Image-or-File-data-type-field-768x225.png 768w, https:\/\/www.inogic.com\/blog\/wp-content\/uploads\/2021\/02\/1-show-images-uploaded-by-Image-or-File-data-type-field-1024x300.png 1024w, https:\/\/www.inogic.com\/blog\/wp-content\/uploads\/2021\/02\/1-show-images-uploaded-by-Image-or-File-data-type-field-660x194.png 660w\" sizes=\"(max-width: 1094px) 100vw, 1094px\" \/><\/a><\/p>\n<p style=\"text-align: justify;\">To show these images, please follow the below steps<\/p>\n<p>\u2022First, we need to create a new custom column to append the Model-driven app URL before the path of the Image. Click on the \u201cNew Column\u201d and add the expression as shown below in the screenshot,<\/p>\n<p><a href=\"https:\/\/www.inogic.com\/blog\/wp-content\/uploads\/2021\/02\/2-show-images-uploaded-by-Image-or-File-data-type-field.png\" target=\"_blank\" rel=\"noopener noreferrer\"><img decoding=\"async\" class=\"aligncenter wp-image-26670 size-full\" src=\"https:\/\/www.inogic.com\/blog\/wp-content\/uploads\/2021\/02\/2-show-images-uploaded-by-Image-or-File-data-type-field.png\" alt=\"show Images uploaded by File or Image type field \" width=\"1115\" height=\"191\" srcset=\"https:\/\/www.inogic.com\/blog\/wp-content\/uploads\/2021\/02\/2-show-images-uploaded-by-Image-or-File-data-type-field.png 1115w, https:\/\/www.inogic.com\/blog\/wp-content\/uploads\/2021\/02\/2-show-images-uploaded-by-Image-or-File-data-type-field-300x51.png 300w, https:\/\/www.inogic.com\/blog\/wp-content\/uploads\/2021\/02\/2-show-images-uploaded-by-Image-or-File-data-type-field-768x132.png 768w, https:\/\/www.inogic.com\/blog\/wp-content\/uploads\/2021\/02\/2-show-images-uploaded-by-Image-or-File-data-type-field-1024x175.png 1024w, https:\/\/www.inogic.com\/blog\/wp-content\/uploads\/2021\/02\/2-show-images-uploaded-by-Image-or-File-data-type-field-660x113.png 660w\" sizes=\"(max-width: 1115px) 100vw, 1115px\" \/><\/a><\/p>\n<p style=\"text-align: justify;\">Here we have concatenated the model-driven app\u2019s URL with the value from the Image or File column.<\/p>\n<p>\u2022 Now add this newly created column into the report and save the report<\/p>\n<p><a href=\"https:\/\/www.inogic.com\/blog\/wp-content\/uploads\/2021\/02\/3-show-images-uploaded-by-Image-or-File-data-type-field.png\" target=\"_blank\" rel=\"noopener noreferrer\"><img decoding=\"async\" class=\"aligncenter wp-image-26671 size-full\" src=\"https:\/\/www.inogic.com\/blog\/wp-content\/uploads\/2021\/02\/3-show-images-uploaded-by-Image-or-File-data-type-field.png\" alt=\"show Images uploaded by File or Image type field \" width=\"1026\" height=\"289\" srcset=\"https:\/\/www.inogic.com\/blog\/wp-content\/uploads\/2021\/02\/3-show-images-uploaded-by-Image-or-File-data-type-field.png 1026w, https:\/\/www.inogic.com\/blog\/wp-content\/uploads\/2021\/02\/3-show-images-uploaded-by-Image-or-File-data-type-field-300x85.png 300w, https:\/\/www.inogic.com\/blog\/wp-content\/uploads\/2021\/02\/3-show-images-uploaded-by-Image-or-File-data-type-field-768x216.png 768w, https:\/\/www.inogic.com\/blog\/wp-content\/uploads\/2021\/02\/3-show-images-uploaded-by-Image-or-File-data-type-field-1024x288.png 1024w, https:\/\/www.inogic.com\/blog\/wp-content\/uploads\/2021\/02\/3-show-images-uploaded-by-Image-or-File-data-type-field-660x186.png 660w\" sizes=\"(max-width: 1026px) 100vw, 1026px\" \/><\/a><\/p>\n<p style=\"text-align: justify;\">Still, images will not be visible because the data category is not set for that custom column.<\/p>\n<p>\u2022 Navigate to Modeling -&gt; Data tab.<\/p>\n<p><a href=\"https:\/\/www.inogic.com\/blog\/wp-content\/uploads\/2021\/02\/4-show-images-uploaded-by-Image-or-File-data-type-field.png\" target=\"_blank\" rel=\"noopener noreferrer\"><img decoding=\"async\" class=\"aligncenter wp-image-26672 size-full\" src=\"https:\/\/www.inogic.com\/blog\/wp-content\/uploads\/2021\/02\/4-show-images-uploaded-by-Image-or-File-data-type-field.png\" alt=\"show Images uploaded by File or Image type field \" width=\"1021\" height=\"236\" srcset=\"https:\/\/www.inogic.com\/blog\/wp-content\/uploads\/2021\/02\/4-show-images-uploaded-by-Image-or-File-data-type-field.png 1021w, https:\/\/www.inogic.com\/blog\/wp-content\/uploads\/2021\/02\/4-show-images-uploaded-by-Image-or-File-data-type-field-300x69.png 300w, https:\/\/www.inogic.com\/blog\/wp-content\/uploads\/2021\/02\/4-show-images-uploaded-by-Image-or-File-data-type-field-768x178.png 768w, https:\/\/www.inogic.com\/blog\/wp-content\/uploads\/2021\/02\/4-show-images-uploaded-by-Image-or-File-data-type-field-660x153.png 660w\" sizes=\"(max-width: 1021px) 100vw, 1021px\" \/><\/a><\/p>\n<p>\u2022 Now select the column that we created and change the Data Category from Uncategorized to Image URL<\/p>\n<p><a href=\"https:\/\/www.inogic.com\/blog\/wp-content\/uploads\/2021\/02\/5-show-images-uploaded-by-Image-or-File-data-type-field.png\" target=\"_blank\" rel=\"noopener noreferrer\"><img decoding=\"async\" class=\"aligncenter wp-image-26673 size-full\" src=\"https:\/\/www.inogic.com\/blog\/wp-content\/uploads\/2021\/02\/5-show-images-uploaded-by-Image-or-File-data-type-field.png\" alt=\"show Images uploaded by File or Image type field \" width=\"983\" height=\"542\" srcset=\"https:\/\/www.inogic.com\/blog\/wp-content\/uploads\/2021\/02\/5-show-images-uploaded-by-Image-or-File-data-type-field.png 983w, https:\/\/www.inogic.com\/blog\/wp-content\/uploads\/2021\/02\/5-show-images-uploaded-by-Image-or-File-data-type-field-300x165.png 300w, https:\/\/www.inogic.com\/blog\/wp-content\/uploads\/2021\/02\/5-show-images-uploaded-by-Image-or-File-data-type-field-768x423.png 768w, https:\/\/www.inogic.com\/blog\/wp-content\/uploads\/2021\/02\/5-show-images-uploaded-by-Image-or-File-data-type-field-660x364.png 660w\" sizes=\"(max-width: 983px) 100vw, 983px\" \/><\/a><\/p>\n<p>\u2022 Save and publish the report. This should start showing the actual images.<\/p>\n<p><a href=\"https:\/\/www.inogic.com\/blog\/wp-content\/uploads\/2021\/02\/6-show-images-uploaded-by-Image-or-File-data-type-field.png\" target=\"_blank\" rel=\"noopener noreferrer\"><img decoding=\"async\" class=\"aligncenter wp-image-26674 size-full\" src=\"https:\/\/www.inogic.com\/blog\/wp-content\/uploads\/2021\/02\/6-show-images-uploaded-by-Image-or-File-data-type-field.png\" alt=\"show Images uploaded by File or Image type field \" width=\"782\" height=\"491\" srcset=\"https:\/\/www.inogic.com\/blog\/wp-content\/uploads\/2021\/02\/6-show-images-uploaded-by-Image-or-File-data-type-field.png 782w, https:\/\/www.inogic.com\/blog\/wp-content\/uploads\/2021\/02\/6-show-images-uploaded-by-Image-or-File-data-type-field-300x188.png 300w, https:\/\/www.inogic.com\/blog\/wp-content\/uploads\/2021\/02\/6-show-images-uploaded-by-Image-or-File-data-type-field-768x482.png 768w, https:\/\/www.inogic.com\/blog\/wp-content\/uploads\/2021\/02\/6-show-images-uploaded-by-Image-or-File-data-type-field-660x414.png 660w\" sizes=\"(max-width: 782px) 100vw, 782px\" \/><\/a><\/p>\n<h2>Conclusion<\/h2>\n<p style=\"text-align: justify;\">We can easily show images in the Power BI report uploaded for any Image or File data type field of Dynamics 365 CRM.<\/p>\n<p><a href=\"https:\/\/www.inogic.com\/product\/productivity-apps\/map-my-relationships-dynamics-365-crm\" target=\"_blank\" rel=\"noopener noreferrer\"><img decoding=\"async\" class=\"aligncenter wp-image-26675 size-full\" src=\"https:\/\/www.inogic.com\/blog\/wp-content\/uploads\/2021\/02\/map-my-relationships.jpg\" alt=\"map my relationships\" width=\"800\" height=\"200\" srcset=\"https:\/\/www.inogic.com\/blog\/wp-content\/uploads\/2021\/02\/map-my-relationships.jpg 800w, https:\/\/www.inogic.com\/blog\/wp-content\/uploads\/2021\/02\/map-my-relationships-300x75.jpg 300w, https:\/\/www.inogic.com\/blog\/wp-content\/uploads\/2021\/02\/map-my-relationships-768x192.jpg 768w, https:\/\/www.inogic.com\/blog\/wp-content\/uploads\/2021\/02\/map-my-relationships-660x165.jpg 660w\" sizes=\"(max-width: 800px) 100vw, 800px\" \/><\/a><\/p>\n","protected":false},"excerpt":{"rendered":"<p>Introduction Currently, we have a requirement where a client needs to upload a visiting card against their Account record and they need one Power BI Dashboard where their salesperson wants to see visiting cards for every Account. The client has stored the visiting image file into the Image data type of field. This blog will\u2026 <span class=\"read-more\"><a href=\"https:\/\/www.inogic.com\/blog\/2021\/02\/how-to-show-images-uploaded-by-file-or-image-type-field-of-model-driven-apps-into-power-bi-report\/\">Read More &raquo;<\/a><\/span><\/p>\n","protected":false},"author":13,"featured_media":0,"comment_status":"closed","ping_status":"closed","sticky":false,"template":"","format":"standard","meta":{"om_disable_all_campaigns":false,"_monsterinsights_skip_tracking":false,"_monsterinsights_sitenote_active":false,"_monsterinsights_sitenote_note":"","_monsterinsights_sitenote_category":0,"footnotes":""},"categories":[16,19,45],"tags":[545,2146,2028,1339,1345,2145],"class_list":["post-26668","post","type-post","status-publish","format-standard","hentry","category-dynamics-365","category-dynamics-crm","category-power-bi","tag-dynamics-365-crm","tag-image-type-field","tag-model-driven-apps","tag-power-bi","tag-power-bi-report-dynamics-365","tag-show-images-uploaded-by-file"],"aioseo_notices":[],"_links":{"self":[{"href":"https:\/\/www.inogic.com\/blog\/wp-json\/wp\/v2\/posts\/26668","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=26668"}],"version-history":[{"count":0,"href":"https:\/\/www.inogic.com\/blog\/wp-json\/wp\/v2\/posts\/26668\/revisions"}],"wp:attachment":[{"href":"https:\/\/www.inogic.com\/blog\/wp-json\/wp\/v2\/media?parent=26668"}],"wp:term":[{"taxonomy":"category","embeddable":true,"href":"https:\/\/www.inogic.com\/blog\/wp-json\/wp\/v2\/categories?post=26668"},{"taxonomy":"post_tag","embeddable":true,"href":"https:\/\/www.inogic.com\/blog\/wp-json\/wp\/v2\/tags?post=26668"}],"curies":[{"name":"wp","href":"https:\/\/api.w.org\/{rel}","templated":true}]}}