Getting images into power BI

[SamTaylor]

Hi,

I want to create reports / pivot tables that include images of the products we sell.  We have lots of images stored on our server, plus we have the active products on our website.

What is the best way for me to get these images into power BI / power pivot?

I can store an image per product on OneDrive.

How can I get an embed code for the image  stored on OneDrive?

Cheers

Sam

[v-alq-msft · Accepted solution]

Hi, @SamTaylor 

1. You may go to the OneDrive website and sign in with your Microsoft account. 

2. Pick the image you want to include in Power BI reports or  dashboards.

3. Copy the path for the corresponding image.

You may create a table with a 'image URL' column and publish the report to service. Here is the result.

Best Regards

Allan

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

[amitchandak]

@SamTaylor ,

onedrive

https://www.fourmoo.com/2017/09/26/power-bi-using-onedrive-to-embed-and-host-images-for-power-bi/

https://community.powerbi.com/t5/Desktop/Image-viewer-working-for-Web-URL-not-for-One-Drive-or-Share...

Sharepoint

https://whitepages.unlimitedviz.com/2018/04/powerbi-report-hyperlink-picture-fields-sharepoint/
https://sharepoint.uservoice.com/forums/330318-sharepoint-administration/suggestions/35041747-powerb...
https://community.powerbi.com/t5/Service/Dashboard-Image-Tile-Image-not-loading-from-provided-URL/td...

local and others

https://blog.crossjoin.co.uk/2019/05/19/storing-large-images-in-power-bi-datasets/

https://www.youtube.com/watch?v=fhtCSUk1pUA

[pranit828]

HI @SamTaylor 

You have to store the image on a url location where PBI service can access it or where you host the report.

OneDrive will have your credentials so when you publish it to server, it maynot work with server credentials you have to sign in on the server with your credentials.

Chwkc the below link for displaying images.

https://docs.microsoft.com/en-us/power-bi/create-reports/power-bi-images-tables

[SamTaylor]

Hi @pranit828 

at the end of the article under consideration, it says you maybe able to get an Embed Code for One Drive?

do you know what this means?

cheers

sam

[pranit828]

Hi @SamTaylor 

Right click on your image and click share, you would get the below share page.

You have to select Anyone with the link if it is enabled for you or you can check other options on the popup.