{"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":"

Introduction<\/h2>\n

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

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 here<\/a>.<\/p>\n

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

See the below screenshot for reference<\/p>\n

\"show<\/a><\/p>\n

To show these images, please follow the below steps<\/p>\n

\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

\"show<\/a><\/p>\n

Here we have concatenated the model-driven app\u2019s URL with the value from the Image or File column.<\/p>\n

\u2022 Now add this newly created column into the report and save the report<\/p>\n

\"show<\/a><\/p>\n

Still, images will not be visible because the data category is not set for that custom column.<\/p>\n

\u2022 Navigate to Modeling -> Data tab.<\/p>\n

\"show<\/a><\/p>\n

\u2022 Now select the column that we created and change the Data Category from Uncategorized to Image URL<\/p>\n

\"show<\/a><\/p>\n

\u2022 Save and publish the report. This should start showing the actual images.<\/p>\n

\"show<\/a><\/p>\n

Conclusion<\/h2>\n

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

\"map<\/a><\/p>\n","protected":false},"excerpt":{"rendered":"

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 Read More: How to Show Images Uploaded by File or Image Type\u2026 »<\/a><\/span><\/p>\n","protected":false},"author":13,"featured_media":0,"comment_status":"closed","ping_status":"closed","sticky":false,"template":"","format":"standard","meta":{"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":[],"aioseo_head":"\n\t\t\n\t\n\t\n\t\n\t\n\t\n\t\t\n\t\t\n\t\t\n\t\t\n\t\t\n\t\t\n\t\t\n\t\t\n\t\t\n\t\t\n\t\t\n\t\t\n\t\t\n\t\t\n\t\t\n\t\t\n\t\t\n\t\t\n\t\t\n\t\t\n\t\t\n\t\t\n\t\t\n\t\t