Showing pictures from SharePoint online attachments

[Anonymous]

I wanted to display an image in a Power BI report that was attached to a sharepoint list item. It is showing as broken.

However, if the user is already logged into sharepoint, then the images appear.

How can i get the images to appear without forcing the user to log onto sharepoint (before they run the report)?

I can access the URL by following these steps:

1. Open the Query Editor and find the column named AttachmentFiles

2.Expand the table with the double arrow and select ServerRelativeURL. This will give you a new column called AttachmentFiles.ServerRelativeURL 

3. Add a custom column to concat your Sharepoint URL and the Path like this ="https://mysite.sharepoint.com" & [AttachmentFiles.ServerRelativeUrl] 

4. Save and close the Query Editor

5. In the data table view, select the custom column you created and in the modeling tab select Data Category:Image URL

6. Add the custom column to your table/image visual

The image is showing as broken.

If the user is already logged into sharepoint, the images appear

[Anonymous]

I had the same problem.
It worked fine after publishing the Desktop BI.
In the published version on Sharepoint I now can see my pictures - though still not on my Desktop version.

If you make a list with the direct path to the pictures on sharepoint - it's enough; 

No need to concatenate, then.
Best regards and luck 🙂

[Anonymous]

Hi @Anonymous ,

Is this problem of yours to load image into power bi from the Sharepoint site is solved. If there is any alternate solution for this issue kindly could you please let me know. 

I am also facing the same type of issue. I need to load the image from a sharepoint site. It is loaded into the sharepoint as an attachment. If i use the link into the Power BI As Image URL  it shows an broken image link. 

Please do let me know.

[Petroclcat]

Same issue as @Anonymous .  Is there another thread with a solution for this?  Broken image icon when pulling in images from a sharepoint list. Any help would be greatly appreciated.  

[Anonymous]

Hi @Petroclcat 

Try using Https with the image link as you construct them in the Query Editor / Joining in the Dax. This worked for me. 

Also if you are using the Sharepoint Online List from O365 means it will not work as the account which you used to login will not allow to you revalidate for fetching the images from the online list. 

Hope this helps. 

[Petroclcat]

@Anonymous Makes sense.  Thank you for the information!

[parry2k]

@Anonymous hope this link help.

[Anonymous]

Hi @parry2k 

Thanks for the quick response.

Unfortunately, what you have suggested does not work, as the images I am working with as stored as attachment to an item in a SharePoint list.