Get Dataverse image column (Base64)

[Nielf]

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 connect using the standard Dataverse connector.

Only the image URL and ID columns are available.

The actual image column with the Base64 string is not included in the query. 

Is it possible to add this column somehow - or is there are reason it's not included? E.g. due to a limitation with the length of the string? The example above is around 4000 characters. 

[Nielf]

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

[AmiraBedh · Accepted solution]

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

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