Forum Discussion
Image Column type on SharePoint list
I'm trying to Display the picture on my Dashboard but would display it a a thumbnail image
I figured out by creating a parshed JSON column. I change the column to ServerURL then I copied the column and changed that to serverRelativeUrl. Then I creatd a custom Column and combined the two to create the Web Url. I renamed all the errors to null.
9 Replies
Its a image users upload on my Sharepoint Site using the Image column in the list. In PowerBI it shows the image like below:
{"type":"thumbnail","fileName":"FY2023 Establishment Performance Plans 2-16-23.jpg","nativeFile":{},"fieldName":"Appendix","serverUrl":"https://hudgov.sharepoint.com","fieldId":"31bd640d-3941-4178-a7ad-42517d37f762","serverRelativeUrl":"/sites/HSNG/GDAS/SiteAssets/Lists/688205f1-59aa-4457-9d13-5e379def389f/FY2023%20Establishment%20Performance%20Plans%202-16-23.jpg","id":"5f90eb26-d27b-4e77-bd09-a3d59bfde273"}
Hi,
Were you able to fix this issue? i have the same issue.
No it did not resolve my issue
No I'm using this column type
I figured out by creating a parshed JSON column. I change the column to ServerURL then I copied the column and changed that to serverRelativeUrl. Then I creatd a custom Column and combined the two to create the Web Url. I renamed all the errors to null.
The solution was using parshed JSON column. I change the column to ServerURL then I copied the column and changed that to serverRelativeUrl. Then I created a custom Column and combined the two to create the Web Url. I renamed all the errors to null. You have to combine the 2 columns together to get the image URL.
