Using IMAGES in Power BI

[@theitguy8835]

There is a 4th option. Convert the image to base64 and you can store the image in the database. If the images are sensitive information like pages in a pdf. (If the pdf you want uploaded is to large for pdfviewer. ) you will be able to place rls on it as well as make a larger file. Just have a slicer for pages/page name on the row and place the base 64 image string as a image url. My client wanted 30 page PDFs visible in powerbi, so I did it this way.

[@nathanphillips3628]

This is the method I use.

[@fabrice2213]

I also used this method :)

[@gonzo202]

Hey this sounds like what I'm doing with high res images, good to know it applies to pdf similarly and strong enough to handle the job. I only uploaded a few images into the model but they filter like a charm. Perfect for engineer diagrams or anywhere that thumbnails may be insufficient or where security restricts connecting to web source.

[@SayuriValente]

Function in Power query: = (ImagemBim as binary) as text=> let Base64 = "data:image/jpeg;base64, " & Binary.ToText(ImagemBim, BinaryEncoding.Base64) in Base64 www.linkedin.com/posts/sayurivalente_powerbi-dataviz-businessintelligence-activity-6707087005370601472-NhUx

[@oldbrawler9332]

This is the only approach if you work with certified custom visuals ;)

[@gabrielpimentel8540]

Shoutout to the production here, animations and overall design are getting better every video! As always, Patrick killing it too

[@bronsontitus6298]

A tip : watch movies at flixzone. Been using them for watching lots of of movies these days.

[@graysongarrett798]

@Bronson Titus Yea, I have been watching on Flixzone} for months myself :)

[@harlemmaddux9564]

@Bronson Titus yea, I have been using Flixzone} for since december myself :D

[@mohamedezequiel9458]

@Bronson Titus definitely, I've been watching on Flixzone} for since november myself :)

[@adampetley9618]

Hi Patrick, Thank you for this one, working great here now thanks. However when going to Power Bi service and download to PDF or powerpoint, the images have disappeared? any ideas please?

[@Nappa74]

I'm using this to display product images in an Inventory report. Really useful. Thanks for helping me numerous times! I always recommend your channel to colleagues needing help.

[@rohaake]

Is there also the opportunity to use images stored in sharepoint ? I have trouble with authorizations to view the images from the sharepoint via Power Bi Webservice - Even if the power Bi Gateway has access to the sharepoint. Any Idea ?

[@DavidBridgeTechnology]

This is the easy bit though Patrick. The hard part in Power BI is displaying the images correctly for Size. Use the image in a table and it is too small with very poor control over scaling (one size almost fits all) and using in a card looks better but now cannot adjust other items such as column with

[@willcisler7069]

Thanks Patrick for showing the Azure blog configuration.

[@oehizele]

Honestly, i can't do without watching Patrick's videos. I am a Qlik user but i love the awesome short videos.

[@yeraldo05]

I haven't use Qlik yet but can you tell me your opinion on why you chose Qlik over Power BI? Thanks for the feedback

[@didiermaignan76400]

Hi Patrick What about Image as a background in a report ? what top 10 visual do you suggest ?

[@roadtech6472]

Niiiice video, as expected from you guys (in a cube). Quick question: how to get images from sharepoint online? Especially about images that are attached on an item from a Sharepoint List...

[@akhilannan]

I think we don't need a calculated column here right? A measure can also be categorized as Image URL I assume.

[@datamaniacs3749]

Hi Patrick! Great material. Is there any option to use confidential images in report? Let's imagine a case where I would have pictures of employees and I am not allowed to make them publicly accessible. Is there any scenario for such a case?

[@angelamessina7187]

Hi I have the same issue. Did you figure out how to achieve this?

[@stephenkeefe8205]

Great video. Method #4 Use the "Enlighten World Flag Slicer" which worked like a dream for me (when being used as an image visual, rather than a slicer). I could not force the Sort Order when it was being used as a Slicer which is a problem for me, maybe I missed something.

[@aas2943]

ur videos r always motivating ....which software ur using for video recording and for showing details with blue rectangle box,,,,,,,kindly let me know

[@GuyInACube]

Videos are edited with Adobe products. We have a video editing team that we contract with now.

[@mgolarte3537]

Hi Patric... Can I use Sharepoint to save my images? Our company does not allow us to use outside sources, so I would appreciate if you let me know walk around using Sharepoint.

[@gulhermepereira249]

I miss the subscribe count in the "SUBSCRIBE". It was great to see the channel's growth

[@FabianaFatimadeToledo]

This vídeo was very helpful for me! I've also tried to decode de image inside the PowerBi but did not work! So with your video I could use the Azure Blob Storage!! I really appreciate your help! And what a amasing vídeo!!! Congrats!!!!

[@SayuriValente]

Function in Power query: = (ImagemBim as binary) as text=> let Base64 = "data:image/jpeg;base64, " & Binary.ToText(ImagemBim, BinaryEncoding.Base64) in Base64

[@laurosoto9074]

Thanks man 3 years to late , but still it help me a lot !

[@zeynabyassin3095]

Hi I have a column in the SQl database for photos. I convert the data type for the column to image URL but still I can't see the pictures. The pictures are jpg type so any advice

[@aienee98]

what if i want to use my own picture? Thank you in advance! im using my own url, but there is no picture came out. my picture store in sharepoint.

[@yernarsmagulov3508]

Patrick, Hi I have problem with connect image. My task: we have folder and there is 1 image. everyday we change image in folder name image constant. Could you help with live connect this image. (Everyday after refresh Power BI image elso must refresh too). please reply this message. If you know information about it please share. Best regard Yernar

[@eagillum]

2:00- First Method: use a public URL 4:08- Second Method: upload the images from the internet to your own website 5:00- Third Method: upload them to the cloud (a blob storage in Azure)

[@shashidharagowda]

Lebron and Steph of Power BI :) Thank you guys

[@ChrisWilliams808]

This was interesting, but the three methods were really similar, just variations on the location where the images were stored. Especially for small images like these, I think it's ideal to store them as base64 data in a table, and then build the image from the stored base64 data without having to make an http request. In this way, access is generally faster, and you don't have to worry if the user has Internet access to download images.

[@GuyInACube]

Great point, but stay tuned!!!!

[@brenthelton2723]

@@GuyInACube I don't believe any of these solutions work if your primary goals is to export your Dashboards from PowerBI Service to a PDF or PowerPoint. It seems to me that PowerBI is built to utilize Images sourced from a URLs but that is in conflict with Microsoft's security policy for certified visuals, which I think is requirement for exporting to PDF. What I am missing? I think several other comments call out similar challenges.

[@hermandorfling4001]

Hi. Great content. Question, is it possible to ad small image to a data point? E.g: on a scatterplot , replace the dots with a small image.? Excell can do it.

[@MrYoghee]

Hi Patrick, Thanks for the video. For some of data, I may not have images (Ex:Surgeon photo). In that scenario, my report shows broken default image. I do not want to show that. All images are with unique Ids and stored in our server with name as the Ids. I could not find in DAX to check that Id image is available or not in the path. If I come to know image not there, then I need to display a blank face image. Could you please suggest a solution?

[@prateek30walke]

Hi, need help with the image URL, some of my colleagues are not able to see the images when they open the report, is it because of low network? Or any other changes I have to make?

[@maxxouful]

Does your 3rd option could allow security restriction and export in PDF? We have highly sensitive images stored on prem with high security. The issue is that the export in PDF or any format from PBI service provide empty images (I do believe the process of the export is done on separate infra in MS side which does not have access to our infra). We then imported the images in our DWH but this is painful and not user friendly with limitations. Any solution around this?

[@agalya9938]

Hi patrick ! In my report ,I need to display the logo of different companies based on the slicer (visual)selection. Can u suggest some ideas to achieve this without using URL link, instead im importing the images (Logo)

[@programmingexplorer9435]

Hi I have an image in Azure cloud which is not publicly accessible. I can get the image contents as binary and display image in power bi. But when I am trying the approach of Image URL, it does not work. Is this a limitation in Power BI?

[@venantiusgalih.w]

love to see that, but can't we rezise the image? so it can be large size.

[@tinahelg340]

Thanks for this. Incredibly timely! I am writing a report that must display different branding depending on the user choice of product. :-)

[@TheLazzanova61]

Is this also possible using images stored in Sharepoint?

[@AlaneNotElaine]

Great video! Thanks!

[@melissasherman9910]

Hi Patrick! This works great for say small icons and such. Is there a way to do the same thing but only have one single row/column (picture) that would fill the screen without using a 3rd party app (my company doesn't allow me to publish 3rd party) Thanks.

[@ressafriggeri6566]

Is it possible to do something similar based on a numeric value of data that has a slicer applied? Switch isn't working since there are multiple values in the value field (one for each slice option)

[@rafaelosipov3820]

Is there a way to import my organizational pictures from Teams to Power BI?

[@elpedropablo]

hi! and what we have to do to make bigger the picture? regards!

[@wasifqureshi3110]

I used this tutorial as a guide to insert image URL's to my dashboard. Good news, it works in Power BI desktop! Bad news, when publishing the same report to the Power BI web app, the images do not show, any ideas why this could be?

[@jasonstark5152]

For an internal work environment how can you use a SharePoint library of images? It’s a website? Right? Thanks love your channel! Great support!

[@tonykuiper9127]

I have a couple of dataverse tables which have to handle images. 1 is populated by a form which sends images as attachments to dataverse. The second is a table which takes the base64 data and puts that in another table with a powerbi relationship between the first and second tables. The base64 data string is around 600k characters per image. When I categorise the column as image url, only about 10% of the image shows in the visual (grid, card or imported visuals). Any idea why the whole image is not shown?

[@tonianibal7585]

Perfect! thank you!

[@jamesrancho]

Can we filter images with higher than 512x512 resolution?

[@14fathauerk]

Can this be done with PDFs?

[@sixtyfiveroses2968]

Easy and efficient as always, awesome video, thank you!

[@denwo1982]

Do you know of any websites that has a picture of the country based on three code i.e GBR, USA, NOR etc…

[@tamiresronchini3355]

Good job 👍👏

[@Santisanguibruck]

We can do this uploading the images in SharePoint?

[@OlivierTravers]

I never could get this to work even after making the files shared with anyone in SharePoint. This would be 10x more convenient than using Azure blob storage when you want to hand over a Power BI solution to "regular business users".

[@joaquinmaverick82]

Great video!!! Thanks for those amazing videos guys. Greetings from Argentina!

[@jacalynmarfisi6487]

Hi Patrick! I loved this video, but I actually was looking for the ability to use parameters to import logos for our multiple customers. My boss told me I could utilize parameters for this, but I can't find a good walk through that helps explain how to do that. The issue we have currently is that the logo is going to have to come from a web image, and not a localized folder. Any help you can provide would be AWESOME!

[@firdausjahan8261]

Tooltip option isn't available for tables & matrices

[@abdullashaik4902]

Can we have an image +text in the same Matrix column?

[@gonzo202]

Great topic! IMHO Power BI isn't so well-suited for images (yet); either we need an instructional video or MSFT needs to add a feature to add **LOCAL** HIGH RESOLUTION FILTERABLE IMAGES into the report. This can be done!!! But you're either a Power BI expert or else you followed 3 blog posts cobbled together, like I did.

[@alinaho5069]

What three blog posts? Trying to get this to work now.

[@gonzo202]

@alinaho5069 dang man, I recently had a 6 page guide I wrote but lost it when my laptop crashed. Chris Webb blog was one of them... let me see if I can find more and follow up here shortly

[@gonzo202]

@alinaho5069 I posted something long but can't see my comments anymore. Did you locate the Chris Webb blog at least? If not, Google "chris webb blog local high resolution filterable images"

[@nathanphillips3628]

Another solution is to encode the images and write them to SQL so they live in the core data model. A base64 encoded image must also be data typed as image url in the pbix. My question: what happened to app.powerbi within the past 7-8 days that has made it darn near impossible to run a python selenium script and click elements for testing? Prior to 8ish days ago, no problems. Any inside knowledge you can pass on?

[@anamariagalvis8397]

You guys are the best!

[@narasimhaprasad847]

I have images of employees in a folder in my local drive, how do incorporate these images into a table as a link to use in PBI HR dashboard

[@iiiiii-w8h]

What about base64 encoding?

[@vishalvvnagar]

Just have query I am trying to export the power bi dynamic images in pdf file. Which gives me the blank image Can u pls help on this issue?

[@yernarsmagulov3508]

Hi Vishal. I have same issuue. Do you solve it?

[@vishalvvnagar]

@@yernarsmagulov3508 use power report builder and add it is as a paginated in power bi desktop

[@pablosantemusica]

I am displaying images from One Drive in a table and they look good, but I export it to PDF and then they appear to be broken. (Only happens with images stored in OneDrive). ¿What could be the cause?

[@razvanipate8034]

Anybody having this issue? I'm using SVG files to create some buttons in my report. Works fine on Power BI service. When I try to embed the report to SharePoint, the buttons only have the outline and are empty. Any ideas?

[@wmfexcel]

Thanks for the video. It will be great if we can use images in a "shared" folder within organization.

[@hanbao7804]

dear， I wonder to know how to show"up" image or "down " image dynamically?

[@hanbao7804]

in "Cross profit margin" part...

[@cleanthisconstantinou7013]

Any ideas when the hover tooltips are going to appear on published on the web reports??

[@shamindra9679]

I have one doubt, is this possible to point out flag from my local disk in power BI?

[@ajitkancherla9594]

Appreciated you knowledge Sharing on every latest Feature!! will that be possible to make a video on Hide/show radio button using DAX measure and filed Value. I have seen some which not Clear

[@saradag6939]

How to add country flag url to excel sr.

[@leighb1652]

I added the blob within my SQL table and migrated the data with the image that way

[@kairmali]

How add image form my desktop in power bi?

[@dillonjohnston512]

Hi All, i am using the Synoptic Designer for power BI and i have it working great, i have create 6 of them but i want to overlay them on top of eachother and i want the option to chose which one i want to see, Does anyone know how to do this ?

[@jwaconditionmonitoring]

Hi, You can create bookmarks for each layer

[@nathandekock6011]

Hi Patrick, Can you share Instagram posts as an image?

[@claudiosantoro75]

Is it just me but option 3 flag is always USA. Nonetheless great video love you guys.

[@amrselim2167]

Hi Patrick, this is Amr from cairo, I'm your biggest fan, you are my model and u helpt me a lot with my work as data analyst, but i need your urgent help, i have a task to manipulate image size by value, Let's say i have sales table Name | sales | image Ahmed | 60 | his image Amr | 70 | his image Patrick | 80 | his image I want to show his image colmn image based on sales value, so your Patrick image will be the biggest Can i do that in power bi?!!

[@kristinamelnichenko4372]

Blob vs SharePoint?

[@elhazardmx]

its dosent work on lately version ( december 2021 :( )

[@TienNguyen-zg9od]

Has anyone been able to do it with images from SharePoint or OneDrive? Would love to know how.

[@jwaconditionmonitoring]

I have a great solution. You can use any image type. Let me know if you need help

[@aleena1549]

3:35 but why exactly multi row card? Why not a simple card?

[@rubensanchezgil722]

Simple cards cannot show images, even though the column used is categorised as Image URL. You will only see the URL itself in the card. Images are only shown in multi-row Cards, tables and matrices.

[@aleena1549]

@@rubensanchezgil722 Got it, Thanks.

[@moulik2341]

Patrick, you're looking less energetic. What happened???

[@poggers_innit8561]

I thought you were talking about bi like bisexual TwT