Image display in Power bi report

[joeanish_0523]

I have added an image in the sharepoint list from my one drive. Now i wish to add that to my power bi report in a table format. However, i did try multiple ways to achieve it but unsuccessful. I tried to extract the url from transform view. I extracted url from one drive and directly pasted it to the sharepoint and converted it to image url and then displayed it in power bi dashboard. But still not working. 

I would really like some support in this.

[jaineshp · Accepted solution]

Hi @joeanish_0523 ,

I can help you resolve this image display issue. The problem is likely with the URL format and permissions. Here's a reliable solution:

Method 1: SharePoint Image Column (Recommended)

1. In your SharePoint list, make sure the image column is set to "Picture" type (not hyperlink)
2. Upload images directly to SharePoint (not linking to OneDrive)
3. In Power BI, the image column should automatically display in table visuals

Method 2: OneDrive Sharing Links (If you must use OneDrive)

1. Right-click your image in OneDrive → Share → Copy Link
2. Important: Change the sharing link format:
   • Original: https://1drv.ms/i/s!ABC123.../image.jpg?e=xyz
   • Convert to: https://onedrive.live.com/download?cid=YOUR_CID&resid=YOUR_RESID&authkey=YOUR_KEY
3. Use this converted URL in SharePoint

Method 3: SharePoint Document Library Approach

1. Create a document library in SharePoint for images
2. Upload images there and get the direct file URL: https://yourtenant.sharepoint.com/sites/sitename/Shared%20Documents/image.jpg
3. Reference this URL in your list

Power BI Settings:

• In Power BI Desktop: Format → Column formatting → Set to "Image URL"
• Ensure the column data category is set to "Image URL"

Troubleshooting:

• Test the URL in a browser first - it should directly display the image
• Check sharing permissions (images must be accessible to report viewers)

Best Regards,
Jainesh Poojara | Power BI Developer

[v-hjannapu]

Hi @joeanish_0523,

I would also take a moment to thank  @rohit1991 , @jaineshp for actively participating in the community forum and for the solutions you’ve been sharing in the community forum. Your contributions make a real difference.

I wanted to check if you had the opportunity to review the information provided. Please feel free to contact us if you have any further questions.

Best Regards,
Harshitha.

[v-hjannapu]

Hi @joeanish_0523,
I hope the above details help you fix the issue. If you still have any questions or need more help, feel free to reach out. We are always here to support you.

Regards,
Harshitha.

[v-hjannapu]

Hi @joeanish_0523,
I wanted to follow up and see if you have had a chance to review the information that was shared. If you have any additional questions or need further clarification, please don’t hesitate to reach out. I am here to assist with any concerns you might have.

Regards,
Harshitha.

[jaineshp]

Hey @v-hjannapu,

Thank you - I appreciate the recognition and am glad my contributions to the community forum have been helpful.

Best Regards,
Jainesh Poojara | Power BI Developer

[rohit1991 · Accepted solution]

hI @joeanish_0523 ,

1. Always Use a Direct Image Link Make sure your image link ends in .jpg, .png, etc. if there’s a long string of parameters or it opens a SharePoint/OneDrive page (instead of the image itself), Power BI won’t display it. For SharePoint: Right-click the image in your document library and choose “Copy Link.” It should look clean sometimes you’ll need to trim everything after the file extension. For OneDrive: Use “Share” → “Copy Link” and, if needed, convert it to the download format: https://onedrive.live.com/download?cid=YOUR_CID&resid=YOUR_RESID

2. Paste These Links into Your Table You can keep these in Excel, SharePoint list, or wherever your data lives—just make sure every row gets its matching image URL. 

3. Tell Power BI It’s an Image Click your image URL column in Power BI Desktop. On the ribbon, go to Column tools > Data Category > set it to Image URL. Drop that field into a table or matrix visual and boom, you should see images, not hyperlinks.

4. Double-Check Permissions Open your image link in a private/incognito browser window. If you can see it without logging in, you’re good. If not, change the permissions/sharing settings on the file or folder. The most common issue: the link works for you but not for viewers of your report (especially if your org is strict about access).

5. Bonus: Troubleshooting Tips Try uploading an image to the SharePoint “Site Assets” library, which is sometimes less picky about permissions. If you see a broken image icon, it almost always means the link is private or isn’t a direct image file. For tons of images, keep file sizes small Power BI loads everything each time.

[jaineshp · Accepted solution]

Hi @joeanish_0523 ,

I can help you resolve this image display issue. The problem is likely with the URL format and permissions. Here's a reliable solution:

Method 1: SharePoint Image Column (Recommended)

1. In your SharePoint list, make sure the image column is set to "Picture" type (not hyperlink)
2. Upload images directly to SharePoint (not linking to OneDrive)
3. In Power BI, the image column should automatically display in table visuals

Method 2: OneDrive Sharing Links (If you must use OneDrive)

1. Right-click your image in OneDrive → Share → Copy Link
2. Important: Change the sharing link format:
   • Original: https://1drv.ms/i/s!ABC123.../image.jpg?e=xyz
   • Convert to: https://onedrive.live.com/download?cid=YOUR_CID&resid=YOUR_RESID&authkey=YOUR_KEY
3. Use this converted URL in SharePoint

Method 3: SharePoint Document Library Approach

1. Create a document library in SharePoint for images
2. Upload images there and get the direct file URL: https://yourtenant.sharepoint.com/sites/sitename/Shared%20Documents/image.jpg
3. Reference this URL in your list

Power BI Settings:

• In Power BI Desktop: Format → Column formatting → Set to "Image URL"
• Ensure the column data category is set to "Image URL"

Troubleshooting:

• Test the URL in a browser first - it should directly display the image
• Check sharing permissions (images must be accessible to report viewers)

Best Regards,
Jainesh Poojara | Power BI Developer