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

The Power BI DataViz World Championships are on! With four chances to enter, you could win a spot in the LIVE Grand Finale in Las Vegas. Show off your skills.

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]),
    )






Did I answer your question? Mark my post as a solution!
Appreciate your Like/Kudos

Proud to be a Super User!





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




Did I answer your question? Mark my post as a solution!
Appreciate your Like/Kudos

Proud to be a Super User!





Helpful resources

Announcements
Las Vegas 2025

Join us at the Microsoft Fabric Community Conference

March 31 - April 2, 2025, in Las Vegas, Nevada. Use code MSCUST for a $150 discount! Prices go up Feb. 11th.

Feb2025 Sticker Challenge

Join our Community Sticker Challenge 2025

If you love stickers, then you will definitely want to check out our Community Sticker Challenge!

Jan NL Carousel

Fabric Community Update - January 2025

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