This is a great question. From my experience, there isn't a way to "lock" the size of an image. It is dynamic and it will adjust to the column width. I just end up adjusting the column width to get the image to the size I want.
Hi, thanks for this; it is extremely helpful. I had one issue where I wanted the image to come through and when I extended it, it was pixilated as the file was a thumbnail. After a bit of experimentation, I solved it by changing your formula to =left(replace(A5,26,7,"uc?id="),71). i.e. changed thumbnail to uc.
Thank you! It helps indeed to have a high quality picture! Don't forget though to replace 71 with 64 at the end of the formula, as now we have less symbols
Thanks for asking. Here is a formula suggestion by another person. Try using this formula to make the resolution better: =left(replace(A5,26,7,"uc?id="),71)
I hope this message finds you well. I'm reaching out to seek assistance with an issue I'm encountering while embedding and publishing reports on our Google Site. When I embed the report onto the site, it seems to only be visible to me and not to others who visit the site. Additionally, even when I publish the report publicly, only the data reflects, while the images remain inaccessible. Could you please provide some guidance or assistance in resolving this issue? I believe ensuring that our reports are properly visible and accessible to all visitors is crucial for effective communication and collaboration. Your help in resolving this matter would be greatly appreciated.
Thanks for reaching out. I'd suggest checking the google drive folder where your images are stored. You'll need to make sure the folder and/or the images inside are viewable on the web. This should help. If you are using a Google Site to embed the report, you can set up permissions in at the Google Site level for access but make your report public. You can do this by making the URL unlisted. Reach out if that doesn't help.
Most links seem to work for me, if it is an image. Google Drive links have been the exception. You can also create a calculated field using the HYPERLINK formula: HYPERLINK(URL, Link Label)
Thanks for the video! Super easy and helpful :) I do have a question, though. I'm trying to put an image of a PPT into the dashboard and use a filter to go through executive summary slides. I've got the filter to work and everything, however I'm having an issue with image resolution when I expand the table to fit the space. Do you know how to help with resolution issues? I'm used to Tableau and this is super easy in that, but hitting this brick wall in Data Studio.
Hey there. Thanks for your comments and asking. I haven't had success with this yet, but someone else suggested to change the word thumbnail in the formula with uc. =left(replace(A5,26,7,"uc?id="),71). Give that a try and see if it helps.
This video was so helpful! My question is this - when I try to blend my Images table with Google Analytics data source (join key is Source / Medium, which I have added as a text column in my google sheet next to each image URL), the blended table works, but the images don't show! Would appreciate any advice!
I've had issues with this myself. Sometimes it works and sometimes it doesn't. I'm sure there is a way to test it and set it up for sure, I just haven't gotten around to figuring it out.
Hello i tried the steps but the images not shown up in Data Studio, by the way i got the image from my iphone, is there any particular types of format of picture must be use, or any types of it can use, Thanks
You might try using this technique, recommended by another viewer: "I solved it by changing your formula to =left(replace(A5,26,7,"uc?id="),71). i.e. changed thumbnail to UC"
You can embed items in Looker directly. If you want to get it out of Drive, you can check out this post about how to do it: www.colby.edu/acits/2020/01/30/how-to-embed-a-video-from-google-drive/#:~:text=Click%20on%20the%20three%2Ddot%20icon%20and%20then%20choose%20%E2%80%9COpen,into%20your%20platform%20of%20choice.
If your Drive images are restricted by a user email, you can also set this up in your Looker Studio project. You do have the option to Filter by Email, if the email address are also listed in your data source.
thanks....i had this issue and about 2 weeks tried to solved, with your video, my problem solved...thanks a lot!
You're welcome!
Thank you thank you so much.... Finally someone had uploaded the most useful video. Thanks again. Keep uploading good videos.
Thanks for this awesome tutorial. just wanted to check if we can limit the images from scaling up when resizing the table.
This is a great question. From my experience, there isn't a way to "lock" the size of an image. It is dynamic and it will adjust to the column width. I just end up adjusting the column width to get the image to the size I want.
Very thoroughly explained, thank you
Thanks for your help, saudations from Brazil!
Thank you Smith grateful, will defenetly follow other links
Man, you saved my life! Thank you for sharing with us!
Glad I could help!
Great video, thanks a lot for this very useful tip.
Unfortunately the copied links would be not in order according to filename
Sorry about that. You might try this instead: =REGEXREPLACE(REPLACE(B6,26,7,"uc?id="),"/view.*","")
@@smithviz I mean when you copy links from google drive, it would return URLs but not ordered
thank you for the video. you just made my life easier. thank you so much
Glad I could help!
Thanks very much for your sharing!
Thank you. you have solved my problem
Hi, thanks for this; it is extremely helpful. I had one issue where I wanted the image to come through and when I extended it, it was pixilated as the file was a thumbnail. After a bit of experimentation, I solved it by changing your formula to =left(replace(A5,26,7,"uc?id="),71). i.e. changed thumbnail to uc.
Thanks for sharing this workaround. Awesome stuff!
Had the same issue and this solves it brilliantly! Thank you brother!
Thank you! It helps indeed to have a high quality picture! Don't forget though to replace 71 with 64 at the end of the formula, as now we have less symbols
This clip really helpful to done my job
Thanks, but how to increase to actual image resolution?
Thanks for asking. Here is a formula suggestion by another person. Try using this formula to make the resolution better: =left(replace(A5,26,7,"uc?id="),71)
Hi, thanks for this. Can you also use the 'Find and Replace' feature to achieve the same thing?
Yes, I think you could absolutely use Find and Replace, as long as you know the entire string to replace. Good idea!
hi there..thanks so much for the formula, how to hide the thumbnail?id=.. from appear if the cell is blank
if there is anyway to hide it
@@sabrinarina5371 Yes. You can do that. Use this formula instead: =IF(ISBLANK(A2)," ",LEFT(REPLACE(A2,26,7,"thumbnail?id="),71))
I hope this message finds you well. I'm reaching out to seek assistance with an issue I'm encountering while embedding and publishing reports on our Google Site.
When I embed the report onto the site, it seems to only be visible to me and not to others who visit the site. Additionally, even when I publish the report publicly, only the data reflects, while the images remain inaccessible.
Could you please provide some guidance or assistance in resolving this issue? I believe ensuring that our reports are properly visible and accessible to all visitors is crucial for effective communication and collaboration.
Your help in resolving this matter would be greatly appreciated.
Thanks for reaching out. I'd suggest checking the google drive folder where your images are stored. You'll need to make sure the folder and/or the images inside are viewable on the web. This should help. If you are using a Google Site to embed the report, you can set up permissions in at the Google Site level for access but make your report public. You can do this by making the URL unlisted. Reach out if that doesn't help.
Thankyou so much @@smithviz
Thanks,
How can we know what links work or which hyperlink format is accepted by data studio?
Most links seem to work for me, if it is an image. Google Drive links have been the exception. You can also create a calculated field using the HYPERLINK formula: HYPERLINK(URL, Link Label)
Thanks for the video! Super easy and helpful :) I do have a question, though. I'm trying to put an image of a PPT into the dashboard and use a filter to go through executive summary slides. I've got the filter to work and everything, however I'm having an issue with image resolution when I expand the table to fit the space. Do you know how to help with resolution issues? I'm used to Tableau and this is super easy in that, but hitting this brick wall in Data Studio.
Hey there. Thanks for your comments and asking. I haven't had success with this yet, but someone else suggested to change the word thumbnail in the formula with uc. =left(replace(A5,26,7,"uc?id="),71). Give that a try and see if it helps.
@@smithviz I had to adjust the formula to 64 at the end so that it would get rid of /view?u
@@MadeforMath Awesome. Thanks for the update.
Hi, Thank you for this wonderful guide. Please advice similar to these images can a pdf be shown ? if Yes how ?
Thank you. I wish there was a way to display PDFs, but I haven't figured that one out yet.
This video was so helpful! My question is this - when I try to blend my Images table with Google Analytics data source (join key is Source / Medium, which I have added as a text column in my google sheet next to each image URL), the blended table works, but the images don't show! Would appreciate any advice!
I've had issues with this myself. Sometimes it works and sometimes it doesn't. I'm sure there is a way to test it and set it up for sure, I just haven't gotten around to figuring it out.
currently face the same issue, image not showing when i blended the data, is this a bug or not ?
i tried this formula also change it to uc but the image show and then it disappear again, is there other way to solve it?
Hello i tried the steps but the images not shown up in Data Studio, by the way i got the image from my iphone, is there any particular types of format of picture must be use, or any types of it can use, Thanks
You might try using this technique, recommended by another viewer: "I solved it by changing your formula to =left(replace(A5,26,7,"uc?id="),71). i.e. changed thumbnail to UC"
i followed exactly but it doesnt shows in my google studio
How do I ensure that the resolution used does not change, because in mine it has changed to small?
Try this: =REGEXREPLACE(REPLACE(B6,26,7,"uc?id="),"/view.*","")
Thank you for that Thumbnail ...
How about Full View ? Can you teach us ? Thx
You could try replacing "thumbnail" with "uc?id="
@@smithviz Thank you so much, its really work ... 🙏🙏🙏
How can to sort image link like as them sort in google drive
Is there any way to play a video using g drive link in data studio??
You can embed items in Looker directly. If you want to get it out of Drive, you can check out this post about how to do it: www.colby.edu/acits/2020/01/30/how-to-embed-a-video-from-google-drive/#:~:text=Click%20on%20the%20three%2Ddot%20icon%20and%20then%20choose%20%E2%80%9COpen,into%20your%20platform%20of%20choice.
It comes for me blurry picture? do you know how to adjust?
You can try uc?id instead of thumbnail
How to get image name from the URL, any google sheet formula instead for script
I only know how to do this with a script...
Thank u so much, u save me haha
i want to ise this metric i created on a time series chart, is that possible?
You'll need a time stamp on each file. You might be able to extract that with a script
Hello !
How do you replicate this for Google Drive images restricted to a group of people?
Has anyone been able to do this?
Thanks!
If your Drive images are restricted by a user email, you can also set this up in your Looker Studio project. You do have the option to Filter by Email, if the email address are also listed in your data source.
by click one link all images are showing, is this possible?
thanks
Welcome
Thanks :) for me the number 71 didn't work so I changed your formula
=REGEXREPLACE(REPLACE(B6,26,7,"uc?id="),"/view.*","")