Hello everyone, I send some fields from power apps to the dataverse and save them in the image type column. I then need to view this data in Power BI but when I connect the field is blank, but when I see it in the dataverse and click on custom column I can see the image. Does anyone know what's going on?
any help is very welcome
Ty!
Solved! Go to Solution.
Hi @Silva_BR,
This is because image columns are saved in Blob Storage behind the scenes and not directly in the table. To get the image, you'll need call image download URL, for example:
https://myorg.crm.dynamics.com/image/download.aspx?attribute=entityimage&entity=myentity&id={ECB6D3DF-4A04-E311-AFE0-00155D9C3020}×tamp=635120312218444444
More info: https://docs.microsoft.com/powerapps/developer/data-platform/image-attributes#entityimage_url-column
Hope this helps!
Usually i store the image as Metadata using the base64 conversion.
The Url created is something like : data:image/jpeg;base64,/9j/4AAQSk........
Then you can use the string as Image and you will see the picture.
Hi @Silva_BR,
This is because image columns are saved in Blob Storage behind the scenes and not directly in the table. To get the image, you'll need call image download URL, for example:
https://myorg.crm.dynamics.com/image/download.aspx?attribute=entityimage&entity=myentity&id={ECB6D3DF-4A04-E311-AFE0-00155D9C3020}×tamp=635120312218444444
More info: https://docs.microsoft.com/powerapps/developer/data-platform/image-attributes#entityimage_url-column
Hope this helps!
The first Microsoft-sponsored Power Platform Conference is coming in September. 100+ speakers, 150+ sessions, and what's new and next for Power Platform.
User | Count |
---|---|
23 | |
5 | |
4 | |
3 | |
3 |
User | Count |
---|---|
25 | |
11 | |
10 | |
9 | |
8 |