Forum Discussion
Unable to find the ServerURL and ServerRelativeURL for the image columns from MS List in PBI
Hi JaganSuri1988,
You're using a modern Image column in your Microsoft List, which only provides limited metadata like fileName and originalImageName in Power BI even after using "Parse JSON". This column type doesn’t expose full URLs (like serverUrl or serverRelativeUrl), which are required to display images in Power BI.
To resolve this, either switch to using an Attachment column, which provides the necessary URL data for building image links, or use Power Automate to extract the image URL from the image column and write it into a text field. Then, set that text field as an Image URL category in Power BI. Keep in mind, images will render only in Power BI Service, not in Desktop.
Thanks for reaching out! If this answer was helpful, please consider marking it as Accepted Solution and giving a Kudos, it helps the community!
Hi JaganSuri1988 ,
If you use the "Parse JSON" button in Power Query, it will convert the image column data into separate columns, including the server-relative URL. Once you have this, you need to merge it with the rest of your image URL (e.g., https://yourcompany.sharepoint.com).
After you've combined the full image URL, you can load the data back into Power BI and set the data category of the new column to "Image URL". This will allow the image to render properly in visuals like tables, matrices, etc.
However, keep in mind that SharePoint images will not render in the Power BI Desktop app. Instead, you’ll see a broken image thumbnail. To verify that it works correctly, you will need to publish the report to Power BI Service, where the images will display properly.
Thanks.