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

Grow your Fabric skills and prepare for the DP-600 certification exam by completing the latest Microsoft Fabric challenge.

Reply
selpaqm
Helper V
Helper V

change thumbnails to Image URL

Hi, I just tried to get the data from the shared point list and the pictures are shown as thumbnails, but I could not make them as picture URLs in Power BI. tried power query and custom column with = [serverurl] & [serverRelativeUrl] formula to get it as properly. then I faced a credentials error.  thumbnail view is as more or less

{"type":"thumbnail","fileName":"35a34b35-01234-43ab-a1a1-1a2b3c4d5e6f.jpeg","fieldName":"FAULT IMAGE 1","serverUrl":"https://mycompany.sharepoint.com","serverRelativeUrl":"/sites/techs/SiteAssets/Lists/12345asd-acac-1...

 

result should be: https://mycompany.sharepoint.com/sites/techs/SiteAssets/Lists/12345asd-acac-123a-1asd-a1b233453sdf/35a34b35-01234-43ab-a1a1-1a2b3c4d...

 

so I have 4 fault image column fault image 1, 2,3,4 

1 REPLY 1
christinepayton
Super User
Super User

Images hosted in SharePoint are not visible the Power BI desktop client - you should be able to see them in the web client after publishing if your image URL is correct. 

Helpful resources

Announcements
RTI Forums Carousel3

New forum boards available in Real-Time Intelligence.

Ask questions in Eventhouse and KQL, Eventstream, and Reflex.

MayPowerBICarousel1

Power BI Monthly Update - May 2024

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