posting the Mcode for future copiers let BinaryToPbiImage = (BinaryContent as binary) as text => let Base64 = "data:image/png;base64, " & Binary.ToText(BinaryContent,BinaryEncoding.Base64) in Base64 in BinaryToPbiImage
@ahmadabdelgalil5894 Жыл бұрын
Thanks Pro
@ZahraAhmadian_199917 күн бұрын
Thank you
@mirrrvelll5164 Жыл бұрын
Superb solution, did it now, functioning like a charm.
@AbhishekGupta-ho8se4 жыл бұрын
Thanks Mr. Gupta for this useful video, it really helped me in one of the PowerBi projects.
Thanks for this informative video, I ran into a problem where my image was over 200KB, and only the top portion of the image was displayed. I also tried reducing the image size by resizing, when I do that the image is distorted. Is there any workaround for this? what is the size of the image you used to build this model?. Thanks.
@matsingh94903 жыл бұрын
FYI, there is a recent update in Chris Webbs blog to store large pictures in BI datasets, as an alternative to David solution. blog.crossjoin.co.uk/2019/05/19/storing-large-images-in-power-bi-datasets/ (just saw it by clicking on the link you provided to reach Gerhards blog)
@wooyeongjeong74052 жыл бұрын
Hi this video is very helpful. Meanwhile, i have the same issue here. was there any solutions for large image sizes?
@TV-mg2sz Жыл бұрын
@@wooyeongjeong7405 Hi, to make sure that pics will be loded properly, re-size them to max 200x200. This fix the issue with loading only~10% of the pic.
@bside36576 ай бұрын
A little bit late but there is a solution for higher resolution images. As it you can only store a little bit more than 32'000 characters in a Power Query column you have to split the entire binary string into multiple columns where each is not longer than 32000 characters. In Power BI DAX you can then create a new column and merge all those Binary columns together into one column (as in Power BI DAX you can store 2Mio characters in one column). Change this column to a Image URL type and use it for the simple image. This works for me.
@manishalive Жыл бұрын
Well I am a beginner to Power BI and your tool was excellent way of adding dynamic images. Great job there, however only one image comes up even with none selection and remains the same with any of the selection. What I am doing wrong. Your way was very simple but looks like I would need more help :)
@prasadpatil97062 жыл бұрын
Perfect..!!Thank U Sir😊
@andress373 ай бұрын
I don't have the SIMPLE VISUAL, how can I get it without a business account?
@stopthink90003 жыл бұрын
Brilliant! Tyvm for this!
@NishantVarshney-g1e11 күн бұрын
it is really helpful but how it will work once we publish the file..
@supriyanadkarni223 жыл бұрын
very helpful training video. Somehow some images do not appear properly, not sure what size to keep
@user-tt9kr4yr8i5 ай бұрын
Very Cool! Thx!
@juliom626010 ай бұрын
Can't see those images at PBI Service. Any solution when sharing rapports?
@ketanbutte34973 жыл бұрын
Thanks for the video. I have a question- Will this work if i publish the report in powerbi service? Will the users be able to access the images?
@renartoliva89833 жыл бұрын
Same question here.
@juliom626010 ай бұрын
Any solution for this? tnx
@raivisbalodis482711 ай бұрын
Can we get a sample file/folder used for example in video?
@ashishmohan47073 жыл бұрын
Hi very useful video and very practical need everyone for every project ......very big thanks to share with us. If it can possible can you plzz provide us excel data file which you used. Very greatful for us...👌👌👌👌👌👌👌👌💐💐💐💐🎂🎂🎂🎂🎂🎂🎂🎂🎂🎂🎂🎂
@fraz31882 жыл бұрын
Thanks for sharing the video; this is exactly what I needed. Unfortunately I am only able to see the top 10% of the images that I have included using this technique. Can you please advise? Each picture is only ~100kb.
@Jester75y2 жыл бұрын
I have the same issue. My images are bmp. Any idea how to convert bmp's to binary?
@TV-mg2sz Жыл бұрын
@@Jester75y Hi, to make sure that pics will be loded properly, re-size them to max 200x200. This fix the issue with loading only~10% of the pic.
@alicjaosiak8033 Жыл бұрын
@@TV-mg2sz I didn't help me :( my photo is 190x88 and still there is 10%
@Meven2001 Жыл бұрын
@@TV-mg2sz It didn't solve the problem. I have image at 1500x1118 which are fine at 100% and some at 308x661 which are 50% and some at 10%...
@Meven2001 Жыл бұрын
Ok, i found a solution. Simply optimize your picture. I gain 10 to 80% (passing from 100% quality to 50% and the quality is not bad). And now i see 100% of my image. It shorten the base64. Great for me.
@coffee_n_code2 жыл бұрын
AMaizing.,!!!!
@tanunagar59063 жыл бұрын
Hi Sir, in this video how you created this choose a parameter slicer. Please help.
@user-cm3qb8bz6e3 жыл бұрын
Thank you Sir
@prajaktasonawane35583 жыл бұрын
Hi, the video is really informative. I have one quick question if I want to import an image which is stored in SQL Server I'm DirectQuery mode. How can I do that?
@sandeepjoshi70153 жыл бұрын
Hi This video really useful for me. I can add the images in my report as you shown in your video, but i cannot see my image completely, its shows me only 10%, like i want to add room picture but in my report I can see only roof & light of the room. Can you please help me how I can see full image?
@matsingh94903 жыл бұрын
FYI, there is a recent update in Chris Webbs blog to store large pictures in BI datasets, as an alternative to David solution. blog.crossjoin.co.uk/2019/05/19/storing-large-images-in-power-bi-datasets/ (just saw it by clicking on the link you provided to reach Gerhards blog)
@TV-mg2sz Жыл бұрын
Hi, to make sure that pics will be loded properly, re-size them to max 200x200. This fix the issue with loading only~10% of the pic.
@hamidrezamohammadzadeh68074 жыл бұрын
Dear Mr.Gupta thanks for sharing, but I have problem with this code and it don't run and i get error that : "Expression.Error: The name 'BinaryEnconding.Base64' wasn't recognized. Make sure it's spelled correctly." What is the Problem ?!
@smarthome56263 жыл бұрын
Enconding* change to Encoding
@chevasflorian40553 жыл бұрын
You rock!
@dasarikumar59663 жыл бұрын
Hi, Thanks for the video. I have a question. My dataset tries to connect to my local folder using gateway during every refresh cycle and if my system is offline, the refresh fails. Since all images loaded to Dataset, is there a way to exclude table from connecting to local folder?
@TV-mg2sz Жыл бұрын
Hi, to make sure that pics will be loded properly, re-size them to max 200x200. This fix the issue with loading only~10% of the pic.
@powerbiselfstudyguide Жыл бұрын
Dear Nice Software Team, i also need M code for PDF File. Your kind & urgent support is requested.