How to Show Images Uploaded by File or Image Type Field of Model Driven Apps into Power BI Report

By | February 3, 2021

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 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.

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.

See the below screenshot for reference

show Images uploaded by File or Image type field

To show these images, please follow the below steps

•First, we need to create a new custom column to append the Model-driven app URL before the path of the Image. Click on the “New Column” and add the expression as shown below in the screenshot,

show Images uploaded by File or Image type field

Here we have concatenated the model-driven app’s URL with the value from the Image or File column.

• Now add this newly created column into the report and save the report

show Images uploaded by File or Image type field

Still, images will not be visible because the data category is not set for that custom column.

• Navigate to Modeling -> Data tab.

show Images uploaded by File or Image type field

• Now select the column that we created and change the Data Category from Uncategorized to Image URL

show Images uploaded by File or Image type field

• Save and publish the report. This should start showing the actual images.

show Images uploaded by File or Image type field

Conclusion

We can easily show images in the Power BI report uploaded for any Image or File data type field of Dynamics 365 CRM.

map my relationships