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
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,
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
Still, images will not be visible because the data category is not set for that custom column.
• Navigate to Modeling -> Data tab.
• Now select the column that we created and change the Data Category from Uncategorized to Image URL
• Save and publish the report. This should start showing the actual images.
We can easily show images in the Power BI report uploaded for any Image or File data type field of Dynamics 365 CRM.