Unanswered

Dataverse Images quality and format

(0) Share

Report

Posted on by Wallabh_S

Through a powerapps application the user is submitting some images, which are stored in a table in the Dataverse as a image data type. Further those images are displayed in the app. (here the images are displayed in a nice quality) When I export the table, in the csv file of the exported data, I can see a base64 formatted text inside the image column. Also, when imported into another environment the image quality degrades and blurs out to some extent.

I need help on these:

1. How the images are stored in dataverse ?

2. I am sending good quality PNGs and why a thumbnail quality images is stored in the Dataverse ?

3. How can I retain the original image quality in another environment after exporting and importing the data ?

Categories:

Microsoft Dataverse

All responses (3)

Answers (0)

VvBeek 2 on at

Like (0)

Report

Re: Dataverse Images quality and format

Is there any work-around as of yet? I would very much like the full image instead of the thumbnail version in my excel exports.
Guido Preite 1,488 Super User 2024 Season 1 on at

Like (0)

Report

Re: Dataverse Images quality and format

the problem is that with excel you will always get the thumbnail and not the full size image.

You will need to export and import the data in another way.

Another way to retrieve the image using api is with this syntax:

https://abc.crm.dynamics.com/api/data/v9.1/sample_customtables(ddd99cd3-bec1-4643-af90-c4b21760ec0d)/sample_image/$value?size=full
PowrToThePeople 4 on at

Like (1)

Report

Re: Dataverse Images quality and format

I had the same problem and found a helpful resource on Microsoft Learn: Use image column data (Microsoft Dataverse) - Power Apps | Microsoft Learn.

1. The files are stored in thumbnail size and, if you configure it, as full image. The setting of saving a full image is configured in column settings of the image column.
2. The thumbnail size is according the performance issue. If you have a list in your app and load in each row the full size image, it might lead to a decrease of performance. I assume thats the reason of the thumbnail size default.
3. In power app you can add the attribute ".full" after the image column:
In a API call you have to add "&Full=true":
https://yourorg.crm.dynamics.com/Image/download.aspx?Entity=account&Attribute=sample_imagecolumn&Id=7a4814f9-b0b8-ea11-a812-000d3a122b89&Timestamp=637388308718090885&Full=true

If you find this information helpful and it resolves your issue, please consider marking this message as the solution.

Best regards,
Alex