How to display an image in PBIX, which has been stored in Dataverse- uploaded via model driven app?

[Dtrain2024]

In a model-driven app, I have a column with datatype "image", which then stores uploaded images in Dataverse - is it possible to then display those images in a Power BI desktop report?

I have loaded the image URLs through power query - even made a new column which mimics the URL as it displays the image in my model driven app - but still get no image... 

I'm guessing that in order to display the image uploaded, my desktop report would need some sort of app security clearance to access images stored in Data verse? 

It seems overly limited to have the capacity to upload images to Dataverse, via a model driven app, but the inability to display them in a Power BI report.. 

Any help is much appreciated!

[Dtrain2024]

As this issue is still unresolved - I have marke the topic as new... again, if there is general concensus that no solution is currently possible - I would also appreciate advice on elevating this as a suggestion to Microsoft for future development. 

[Anonymous]

Hi, @Dtrain2024 
In Power BI, you can display the picture that the url points to. As shown below, I've created a simple sample of data:

Here are the results:

The visuals I use to view your URL aren't standard visuals for Microsoft. You can try to find the technical support side for the corresponding visual from the image below:

How to Get Your Question Answered Quickly

If it does not help, please provide more details with your desired output and pbix file without privacy information (or some sample data) .

Best Regards

Jianpeng Li

If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.

[Dtrain2024]

Thanks @Anonymous , 

Unfortunately, my question is not simply about displaying images in Power Bi - that's straightforward. 

The question is -  can you display images in Power BI, which are stored in Dataverse (which have been uploaded via a model-driven app).

If anyone has experience building model driven apps - It would take 5 mins to create an table with image column, create an app, upload any image via the app, then connect to Dataverse in Power BI, then try display the image in a power BI report. There's honestly no point in me providing my own pbix in order for someone to solve this problem .

FYI - The URL where the images are stored is essentially:

https://[ENVIRONMENT].dynamics.com/image/download/aspx?Entity.....

[Environment] = being my own organisational environment set up to develop the app. 

In my attempts through power Query, I've recreated the URL exactly, as it displays when I open it within my model-driven app - however when I try visualise that URL in Power BI Dsektop - I get no image, and no error message, - when I use the "Simple Image" visual in Power Bi, or any of the image visuals I tried in Power Bi Desktop. 

Any additional help would be hugely appreciated. 

[Anonymous]

Hi, @Dtrain2024 

Thank you very much for your reply. First, you need to make sure that the image connection provided by Dataverse can be directly accessed. You can paste your link in your browser's address bar to see if you can read the photo directly as shown below:

If it is accessible, check to see if there are other contributing factors, such as whether the network firewall is preventing Power BI from reading the image that the current link points to.

Best Regards

Jianpeng Li

If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.

[Dtrain2024]

Thanks Jianpeng, 

Yes, as I noteded in my innitial post,  I suspect there is some sort of security/firewall preventing images from Dataverse being displayed. 

I can see the image if I paste the URL into the same browser that I'm already logged into the Model Driven App.

But authorization is denied when I paste it into a different browser. 

This seems like a serious limitation of Dataverse, namely that it stores images but can't display them in Power BI - even though its all part of Fabric, Power Apps, Power BI etc.

This is what I need help with - and if its currently not possible - could someone please direct me to where I could suggest Microsoft fix this situation?

Thanks,

[Anonymous]

Hi, @Dtrain2024 
Thank you very much for your reply. Based on your description, it's true that it's subject to some kind of access restriction so that Power BI can't access the picture that the current connection points to.

Best Regards

Jianpeng Li