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

Earn the coveted Fabric Analytics Engineer certification. 100% off your exam for a limited time only!

Reply
Anonymous
Not applicable

Can't see image in table from Sharepoint in Desktop but can see it if I use Image button.

I have this strange problem. When using desktop, I have images saved on sharepoint, I have access to it. I use a simple table that connects a companyID to URL of the image, so the Logo is diplayed properly.

I can see the logos in the table when I publish it online but I can't see them in the same table in Desktop. If I use the "Image" button and select an .jpg from Sharepoint it displays properly in Desktop. Please refer to images below, any suggestions on how to fix that would be more than helpful. I tried everything, even trying to store images localy and then convert them using Base64 code (some of the images didn't display properly).

Online.jpgDeskt.jpg

 

 

1 ACCEPTED SOLUTION
dax
Community Support
Community Support

Hi kohckamyxa,

Based on my test, this might be related to permission. When I set image permission in sharepoint like below

129.png

Then use get data->sharepoint folder, add a custom column to display full path of image like below

l

et

    Source = SharePoint.Files("https://xxxxxxx.com", [ApiVersion = 15]),

    #"Added Custom" = Table.AddColumn(Source, "fp", each [Folder Path]&[Name])

in

#"Added Custom"

130.png

Then add it in table, and set data categories to image URL, then it will work

131.png

You could refer to Dashboard Image Tile: Image not loading from provided URL and Getting Image URLs to display Image for details.

 

Best Regards,

Zoe Zhi

 

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

View solution in original post

3 REPLIES 3
SYM1986
Helper I
Helper I
dax
Community Support
Community Support

Hi kohckamyxa,

Based on my test, this might be related to permission. When I set image permission in sharepoint like below

129.png

Then use get data->sharepoint folder, add a custom column to display full path of image like below

l

et

    Source = SharePoint.Files("https://xxxxxxx.com", [ApiVersion = 15]),

    #"Added Custom" = Table.AddColumn(Source, "fp", each [Folder Path]&[Name])

in

#"Added Custom"

130.png

Then add it in table, and set data categories to image URL, then it will work

131.png

You could refer to Dashboard Image Tile: Image not loading from provided URL and Getting Image URLs to display Image for details.

 

Best Regards,

Zoe Zhi

 

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

Anonymous
Not applicable

Unfortunetly, the organization doesn't allow setting the link to "Anyone with link". The only work around I found was to use the URL address of the tumbnail of the picture in Sharepoint to show properly. It contains token in the link and it's the same for all pictures.

Helpful resources

Announcements
April AMA free

Microsoft Fabric AMA Livestream

Join us Tuesday, April 09, 9:00 – 10:00 AM PST for a live, expert-led Q&A session on all things Microsoft Fabric!

March Fabric Community Update

Fabric Community Update - March 2024

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