Forum Discussion
Unable to find the ServerURL and ServerRelativeURL for the image columns from MS List in PBI
Hi, To begin with I am not a expert with PBI or MS List however I have been able to develop reports with the help of articles and youtube videos.
I am trying to build a report in PBI using the information from MS List saved in SharePoint. The list has various columns including text, numbers and a image column. When I pull the data into PBI from SharePoint List. I can see all the columns in the PowerQuery editor however the image column does not show the ServerURL and the ServerRelativeURL (please see the below which shows only the file name and the original image name). I understand that an image can be shown in the PBI reports only using the URL of the image and for some reason I am able to see only the file name in the field.
Could someone please help me with a solution?
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!
5 Replies
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.Hi Chaithra!
Thanks for your detailed explaination. I have indeed tried the same and convert to "Parse JSON" however even after that I am still able to see only the file name and OrginalFileName. Please find below the screenshot.
v-sgandrathiCommunity Support
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!
- v-sgandrathi
Hi JaganSuri1988,
I wanted to follow up on our previous suggestions regarding the issue. We would love to hear back from you to ensure we can assist you further.
If our response has addressed your query, please accept it as a solution and give a ‘Kudos’ so other members can easily find it. Please let us know if there’s anything else we can do to help.
Thank you.
- v-sgandrathi
Hi JaganSuri1988 \,
May I ask if you have gotten this issue resolved?
If it is solved, please mark the helpful reply or share your solution and accept it as solution, it will be helpful for other members of the community who have similar problems as yours to solve it faster.
Thank you.
