Bas, I love you! I am building a dashboard for my board of directors and i want go show the top 5 customers per category And i want the customer logo My images were not showing before and I'll try this function Monday when i get to work!
@@HowtoPowerBI Thank YOU. So much of what I've integrated into our team's service offering in PBI was inspired by a technique or concept seen in your videos. Up next: A Gantt chart with inputs created by an embedded PowerApp.
Nice video, If I recall properly, Chris Webb has also created a function and measure that allow to have image bigger than the limit of one row. Basically the technic is to create multiple row to have the full image and them use measure to concatenate all rows together.
thanks Remi! I've seen - thought about incorporating it - but most of the times I go for compressing the images instead (and it would make the video very long haha). Its a great solution if you need higher resolution images for your report or for some reason cannot compress the images.
@@HowtoPowerBI I usually take this solution when I need to add images and so it became a standard approach. Still need to be conscious of image size to not Ballon dataset size. I though video length would have been a factor in your choice. Keep up the good work, you produce great content :).
You recalled correctly and restored my sanity, Remi. It is surprising to me that Chris Webb's method seems to be the only way to display images larger than ~20KB through Power BI
And more over, Chris’ solution does not work everytime. I experienced it yesterday and am still stuck with some images that do not render. Plus…such a long time to upload everything into the data model. 😢
Awesome mate. Back in days when I had to incorporate images, I had to take long-winded steps to convert to a Base64 format. This function makes it a breeze. 👍
Is there a possibility to add an image to a tooltip? For example on hover over a lat/long point I should get the image of that place that I have stored somewhere along with key data.
Wow, thank you you so much Bas for sharing this use case for the Base64 encoder! I love the implicaitons of it. Have you noticed very long refresh rate times in Power Query when trying to apply to "lots" of rows? I converted 715 rows of the binary content (jpegs) to the encoded text. Now, the refresh rates takes 3+ minutes -- I actually quit PBI desktop as I figured it wasn't worth waiting. Excluding one jpeg w/ a file size of 36 KB, all other jpegs hosted in my one drive folder do not exceed 27 KB w/ more than the 700 files not exceeding 19 KB. I suspect it might be the connection to a cloud folder -- haven't tested from a local drive as this solution will not serve my needs. Prior to using the Base 64 encoder method, I used the typical URL value approach. Refresh rate with the same files is almost instataneous (
Real usefull well done, one curiosity this process is applicable to shows some embedded documents in my sql and maybe then double click and visualize in full content?
Simply awesome Bas👌🏼👏🏼👊🏼 i do have a request to know if there is a way to show multiple images one after the other thru a click or automatically with a zoom out effect.. wud really appreciate if u can nail this ! Thanks again for your efforts and creative mind❤️
@@HowtoPowerBI thanks for replying Bas.. yes something like that.. when on click i would like all related product images to be displayed on a tooltip page or a new page - one after the other in a scrolling manner(if possible) through a click stating “next” below every image.. so you see one image in that tooltip page but below the image you have a next icone or so to see the following image.. its like you display a catalog of images with a scrolling effect as you have seen in some websites.. i knw i ask a lot but would love to hear your suggestion and creativity on it!
This is fantastic - but how do I use these images as labels in a visual like a bar graph or column graph? When I choose the image as my x-axis field I get the text information of the image not the image itself.
I figured out I could select each Series, choose Image URL, and paste the encoded text into the Image URL field. Works for me because I only have a handful so not too bad to paste them in manually. Thanks again, your video gave me the knowledge to figure this out myself ❤
Hola! Hi! thanks for the videos. I'm trying to have a vector image at Powerbi that can change from gray to green according if parameter yes/no. Any ideA? Thanks!
Hi, I have loaded images in Power BI, and the base64 string is not more than 32,766 characters. I am trying to increase the image size, but it is not increasing. Could you please assist me in this?
Hi, when encoding image URL stored in SharePoint to a text column using web.content(), I can no longer refresh the report in Power BI Service. Is there a way to solve that? Thank you in advance!!
Hi Bas, Hi Community! I have tried to do this way with folder contains SVG files and I got nothing in Power BI when I tried to display converted images. ChatGPT recommended to use "data:image/svg+xml;base64," prefix, but it doesn't help. Does anyone know how to? :)
Hi sir I really love you video. I learn a lot from all pf them. However i have a doubt in pbi. Is there any email id where i can reach you out ? Kindly help. Thanks
Hi can someone please help me out even i am facing the same issue with image links are broken and none of the images are getting displayed properly and i have a huge number of images and all images are coming Databricks and images are of high resolution
@@HowtoPowerBI You're right, sorry for my poor question wording! What I wanted to question is if this "binary image" columns can be used in Slicer controls. When you use a "url image" column the slicer control renders the image without any problem but If I use this option the image isn't render (it is render for example in Tables or Matrix). Do you know if there's a solution for that? Or i'm losing something? Again thanks for the reply and the very good explanation in the video :)
You are a hero! I have struggled for weeks and now solved it, thanks to this tutorial.🙂
Glad it helped! 😁
Great tutorial. Exactly what I was looking for - thanks for sharing!
Bas, you are the best!! You have helped me solve so many issues in PowerBI. You are the man!!
You are a superstar - a hero - simply the greatest. Thank you so much for your help.
Bas, I love you!
I am building a dashboard for my board of directors and i want go show the top 5 customers per category
And i want the customer logo
My images were not showing before and I'll try this function Monday when i get to work!
The BEST PBI content on the interwebs!
Thanks Douglas!
@@HowtoPowerBI Thank YOU. So much of what I've integrated into our team's service offering in PBI was inspired by a technique or concept seen in your videos. Up next: A Gantt chart with inputs created by an embedded PowerApp.
Nice video,
If I recall properly, Chris Webb has also created a function and measure that allow to have image bigger than the limit of one row. Basically the technic is to create multiple row to have the full image and them use measure to concatenate all rows together.
thanks Remi! I've seen - thought about incorporating it - but most of the times I go for compressing the images instead (and it would make the video very long haha). Its a great solution if you need higher resolution images for your report or for some reason cannot compress the images.
@@HowtoPowerBI I usually take this solution when I need to add images and so it became a standard approach. Still need to be conscious of image size to not Ballon dataset size.
I though video length would have been a factor in your choice. Keep up the good work, you produce great content :).
You recalled correctly and restored my sanity, Remi. It is surprising to me that Chris Webb's method seems to be the only way to display images larger than ~20KB through Power BI
And more over, Chris’ solution does not work everytime. I experienced it yesterday and am still stuck with some images that do not render. Plus…such a long time to upload everything into the data model. 😢
Awesome mate. Back in days when I had to incorporate images, I had to take long-winded steps to convert to a Base64 format. This function makes it a breeze. 👍
haha yea it is quite easy now. Though would be even easier if we could leave it as binary 😁
Fantastic way 👍🏼 keep going man, best source at youtube about PBI.
Your Teaching Skills are Excellent....
thank you very much!! 😊
Thanks Bas for the detailed explanation. I enjoy all your videos.
This tricks is incredible! Thank you very much for this video
You are so amazing!!!!!
Great video. Very crisp and clear explanation. Thanks!
Happy to hear you like it!
Fantastic Power BI tutorial as always!
Glad to hear this Gary! :) thx
Is there a possibility to add an image to a tooltip? For example on hover over a lat/long point I should get the image of that place that I have stored somewhere along with key data.
Thanks for sharing! Amazing video!!!
Wow, thank you you so much Bas for sharing this use case for the Base64 encoder! I love the implicaitons of it. Have you noticed very long refresh rate times in Power Query when trying to apply to "lots" of rows?
I converted 715 rows of the binary content (jpegs) to the encoded text. Now, the refresh rates takes 3+ minutes -- I actually quit PBI desktop as I figured it wasn't worth waiting. Excluding one jpeg w/ a file size of 36 KB, all other jpegs hosted in my one drive folder do not exceed 27 KB w/ more than the 700 files not exceeding 19 KB. I suspect it might be the connection to a cloud folder -- haven't tested from a local drive as this solution will not serve my needs.
Prior to using the Base 64 encoder method, I used the typical URL value approach. Refresh rate with the same files is almost instataneous (
Real usefull well done, one curiosity this process is applicable to shows some embedded documents in my sql and maybe then double click and visualize in full content?
Thank you ! I´m from Brazil , you saved me!
Super happy to hear that
Simply awesome Bas👌🏼👏🏼👊🏼 i do have a request to know if there is a way to show multiple images one after the other thru a click or automatically with a zoom out effect.. wud really appreciate if u can nail this ! Thanks again for your efforts and creative mind❤️
thank you Vignesver! So you would want to click on let's say product category and then see the images of all products?
@@HowtoPowerBI thanks for replying Bas.. yes something like that.. when on click i would like all related product images to be displayed on a tooltip page or a new page - one after the other in a scrolling manner(if possible) through a click stating “next” below every image.. so you see one image in that tooltip page but below the image you have a next icone or so to see the following image.. its like you display a catalog of images with a scrolling effect as you have seen in some websites.. i knw i ask a lot but would love to hear your suggestion and creativity on it!
Amazing tutorial..!! 👍🏼
Excellent explanation, thank you BAS😍
thanks a lot for watching Santhosh!😀
Man, you saved me!! Thanks!
You rock!!
This is fantastic - but how do I use these images as labels in a visual like a bar graph or column graph? When I choose the image as my x-axis field I get the text information of the image not the image itself.
Thanks for sharing.
How add image form my desktop in this slicer ?
watch my latest video - there i cover it
Outstanding 😍😍
Excellent, thanks for this video! Can we show these embedded images in the New Card Visual? I can’t figure out how.
I figured out I could select each Series, choose Image URL, and paste the encoded text into the Image URL field. Works for me because I only have a handful so not too bad to paste them in manually. Thanks again, your video gave me the knowledge to figure this out myself ❤
Great stuff!
Hey Bas, do you have any idea why the encoded images can be shown in a table but not in the new button slicer? Thx ;)
Hola! Hi! thanks for the videos. I'm trying to have a vector image at Powerbi that can change from gray to green according if parameter yes/no. Any ideA? Thanks!
How would I do the same in power bi paginated report using the report builder?
Good job.
Thank you boss
Thank you Kassio!!! 😊
images are not visible in slicer!
Can we have an image +text in the same Matrix column?
Hi, I have loaded images in Power BI, and the base64 string is not more than 32,766 characters. I am trying to increase the image size, but it is not increasing. Could you please assist me in this?
Hi,.. how to preview the thumbnail image column in the SharePoint list in Powerbi?
Hi, i am trying to retrieve image from Google sheets which in url format from Google drive but the image is not visible can you help on this 😊
hey, do you know how to remove white gap below the image?
Hi, when encoding image URL stored in SharePoint to a text column using web.content(), I can no longer refresh the report in Power BI Service. Is there a way to solve that? Thank you in advance!!
Hi Bas, Hi Community! I have tried to do this way with folder contains SVG files and I got nothing in Power BI when I tried to display converted images. ChatGPT recommended to use "data:image/svg+xml;base64," prefix, but it doesn't help. Does anyone know how to? :)
Fantastisch!
dankjewel Michiel ☺
Super usefull
Hi sir
I really love you video. I learn a lot from all pf them.
However i have a doubt in pbi. Is there any email id where i can reach you out ?
Kindly help. Thanks
Any way to compare images on powerbi ??
Hi can someone please help me out even i am facing the same issue with image links are broken and none of the images are getting displayed properly and i have a huge number of images and all images are coming Databricks and images are of high resolution
The best ever
:D:D:D Thx Ramon!
Hello, Great but this solution is not working for Slicer as it works for regular Web Image, right? Thanks a lot!
not sure what you mean
@@HowtoPowerBI You're right, sorry for my poor question wording! What I wanted to question is if this "binary image" columns can be used in Slicer controls. When you use a "url image" column the slicer control renders the image without any problem but If I use this option the image isn't render (it is render for example in Tables or Matrix). Do you know if there's a solution for that? Or i'm losing something? Again thanks for the reply and the very good explanation in the video :)
Replying back myself: it works for Chiclet Slicer control
why when i change the binary to text. the result is error? can u help me?
better if you did the query step by step. I had to figure out how to do it myself 😢
Sorry, you lost me at the last part when you tried to make a new query or function. Mine did not show any LET or IN statements
вери гуд 🙈
🤯
Ty u a lot