Skip to main content
cancel
Showing results for 
Search instead for 
Did you mean: 

Register now to learn Fabric in free live sessions led by the best Microsoft experts. From Apr 16 to May 9, in English and Spanish.

Reply
Unicorn_Tech
Resolver I
Resolver I

Image URL not displaying in visual

Hello.  I've searched the forum and not found a relevant answer.

I have a dynamics field image, and I have a concatenated column like the following:

Photopacking =
    IF(
        NOT(ISBLANK(new_packinghouseevaluations[cr7f8_photospacking1_url])),
        CONCATENATE("https://grapacrm.crm4.dynamics.com/", new_packinghouseevaluations[cr7f8_photospacking1_url]),
        BLANK()
    )

The column when formatted as an image url is broken in the visual.

If I format the column as a web url, a clickable web url appears in the visual, which when clicked, opens the photo.

So I can't figure out why the image url isn't working.

Any ideas?
4 REPLIES 4
Unicorn_Tech
Resolver I
Resolver I

Hi @PijushRoy ,

This is the finished link, and when I open it it works for me, because I am signed in to my system iwth permissions. (as all users will be)

https://grapacrm.crm4.dynamics.com//Image/download.aspx?Entity=new_packinghouseevaluation&Attribute=...

when clicked, it opens a browser with the image.

When i convert the column to image url, it shows a broken image icon.

 

I am using the table visual, and I also tried another visual specifically for images.

I also tried modifying the formula to this, removing an extra /

Photopacking =
    IF(
        NOT(ISBLANK(new_packinghouseevaluations[cr7f8_photospacking1_url])),
        CONCATENATE("https://grapacrm.crm4.dynamics.com", new_packinghouseevaluations[cr7f8_photospacking1_url]),
        BLANK()
    )
No change.

Hi @Unicorn_Tech 

I have used this URL and ended with the .jpg or .png

https://i.ibb.co/SRcvhtf/2022-12-08-152256.jpg

 

PijushRoy_1-1706698831967.png

 

Works perfectly. Please use the Image link in your measure and check

 

Photopacking =
    IF(
        NOT(ISBLANK(new_packinghouseevaluations[cr7f8_photospacking1_url])),
        CONCATENATE("https://grapacrm.crm4.dynamics.com", new_packinghouseevaluations[cr7f8_photospacking1_url]),
    )



Hi.  Thank you for the suggestion, I tried that formula, but unfortunately there has been no change.

PijushRoy
Super User
Super User

Hi @Unicorn_Tech 

Are you using image url in Table visual or any other visual? 
Is your URL link end with .png or .jpg like this extension

Helpful resources

Announcements
Microsoft Fabric Learn Together

Microsoft Fabric Learn Together

Covering the world! 9:00-10:30 AM Sydney, 4:00-5:30 PM CET (Paris/Berlin), 7:00-8:30 PM Mexico City

PBI_APRIL_CAROUSEL1

Power BI Monthly Update - April 2024

Check out the April 2024 Power BI update to learn about new features.

April Fabric Community Update

Fabric Community Update - April 2024

Find out what's new and trending in the Fabric Community.