Unable to get image URL from Sharepoint List

[Isabel_Zhang]

Dear experts,

I tried to show the picture that saved in SharePoint List, but when I link the sharepoint list to Power BI Desktop, there is no URL available in the image field, all show as null.

I have another sharepoint list with the same setting about the image column, which can show the URL, and then show the picture in Power BI report. It is very strange that this sharepoint list is not working.

Could you please support to check if there is any set up in Power BI need to change?

Best Regards,

Zhang Jia

[123abc · Accepted solution]

Plesae follow given solved solution of commuinty ... hopefully this will solve your problem.

 

How can I display images from SharePoint Online List in PowerBI Report?

https://community.fabric.microsoft.com/t5/Desktop/How-can-I-display-images-from-SharePoint-Online-Li...

Get hyperlink (image url) from sharepoint and visual as picture in power BI

https://community.fabric.microsoft.com/t5/Desktop/Get-hyperlink-image-url-from-sharepoint-and-visual...

How to display images from SharePoint list

https://community.fabric.microsoft.com/t5/Desktop/How-to-display-images-from-SharePoint-list/td-p/35...

[Anonymous · Accepted solution]

Hi @Isabel_Zhang ,

Please check whether there is any difference between your two sharepoint lists. If you need to get the URL of a picture in a sharepoint list or in OneDrive for work or school, then the URL must be anonymously accessible, not on a site that requires a sign-in.
https://learn.microsoft.com/en-us/power-bi/create-reports/power-bi-images-tables#considerations 

Best Regards,
Dino Tao
If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.

[123abc · Accepted solution]

Plesae follow given solved solution of commuinty ... hopefully this will solve your problem.

 

How can I display images from SharePoint Online List in PowerBI Report?

https://community.fabric.microsoft.com/t5/Desktop/How-can-I-display-images-from-SharePoint-Online-Li...

Get hyperlink (image url) from sharepoint and visual as picture in power BI

https://community.fabric.microsoft.com/t5/Desktop/Get-hyperlink-image-url-from-sharepoint-and-visual...

How to display images from SharePoint list

https://community.fabric.microsoft.com/t5/Desktop/How-to-display-images-from-SharePoint-list/td-p/35...