Forum Discussion

selpaqm's avatar
selpaqm
Helper V
3 years ago

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-123a-1asd-a1b233453sdf/35a34b35-01234-43ab-a1a1-1a2b3c4d5e6f.jpeg","id":"aaabbb12-a123-b234-ab90-123asd123as"}

 

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

 

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

Need Help

1 Reply

  • christinepayton's avatar
    christinepayton
    Most Valuable Professional
    3 years ago

    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.