Forum Discussion

Nielf's avatar
Nielf
Helper I
2 years ago
Solved

Get Dataverse image column (Base64)

I have a report with Dataverse as the main source.    I would like to use the default image column from the Account table in my report. However, the default image column isn't inluded when you conn...
Need Help
  • AmiraBedh's avatar
    AmiraBedh
    2 years ago

    I think all you need the url no ?

    When adding custom image columns to your Dataverse table in Power Query, the column will display the image URL in the following format:

    /Image/download.aspx?Entity=cree3_MYTABLE&Attribute=cree3_image2&Id=36cc42c6-0cd2-ec11-a7b5-000d3a0d0c9c&Timestamp=637879702012941786

    To properly display these images in your reports, create a custom column named "MyImageURL" in Power Query and prepend your company's Dataverse URL to this image URL. This URL can be found in the datasource settings within Power BI. For example:

    https://orgc7cxyz123.crm11.dynamics.com/Image/download.aspx?Entity=cree3_MYTABLE&Attribute=cree3_image2&Id=36cc42c6-0blahblah

    Change the data category of the "MyImageURL" column to "Image URL" to enable image display in your reports.

     

Nielf's avatar
Nielf
Helper I
2 years ago

AmiraBedh your solution works but only if the user is already logged in Power Apps/Dynamics 365. Otherwise, they will see a red X until they authorize.  That's why i would prefer to use the Base64 string. 

 

I way to overcome thise, could simply be create the Base 64 string in another column in Dataverse, e.g. using Power Automate. However, it seems redudant since the string is already there - it's just no available to select in Power BI.