Image through URL in Pivot Table

[saurabh_d19]

I'm Trying to add an thumbnail in the Pivot table but its only showing the URL Text even after selecting Image as a data type. Any Idea how can i get the image or it doesn't Support. 

[Looker_Studio_B]

Are your image publicly accessible? And is the URL something ending in .jpg or similar? If not accessible and the link is not an image file, it won't work.

[saurabh_d19]

Yes image is publicly accessible and ends with .jpg

[Rick_E]

Do the images render properly if you switch the viz type to Table?

[saurabh_d19]

yes. example below

[Looker_Studio_B]

Is this a blended data?!

[saurabh_d19]

no. 

[Rick_E]

Images are only supported in regular tables, not pivot tables (link to documentation). Also, I don't believe Looker Studio can display images hosted in Google Drive, even if they are set to public sharing.

[saurabh_d19]

Thanks for sharing the documentation link.

images hosted on google drive works well for me. I'm using since last two years. never had a problem on normal table its just the pivot table where I'm having a problem.

[lauratilton]

@Rick_E Looker Studio can display Google Drive images in a table, but the URL has to be modified as follows:

ORIGINAL: https://drive.google.com/file/d/XXXXXXX/view?usp=drive_link  
MODIFIED: https://drive.google.com/uc?export=view&id=XXXXXXX

[Looker_Studio_B]

Really nice! I guess it needs to be share to the people accessing the Looker STudio so they can see it?

[Rick_E]

@lauratilton Thanks for sharing that! Do you manually edit the the .../file/d/XXX to create the /uc?export URL? 

[saurabh_d19]

@riri1 @Looker_Studio_B  @lauratilton here is the one of the best example for you guys, where i display the logo/thumbnail for performance on each channel for the campaigns.

its a calculated field.

CASE
WHEN channel = 'Meta' then CONCAT('https://drive.google.com/uc?export=download&id=',REGEXP_EXTRACT('------copy and paste the shareable link of drive file here inside a single quote-----------', "https://drive.google.com/file/d/([^\\/]+)"))

//add more channels if needed else delete this line

ELSE CONCAT('https://drive.google.com/uc?export=download&id=',REGEXP_EXTRACT('------copy and paste the shareable link of drive file here inside a single quote for a any default thumbnail-----------', "https://drive.google.com/file/d/([^\\/]+)"))
END

output.

[lauratilton]

This was a while ago but I just went on a hunt to remember how I did this. I did not manually edit it...the data source was a Sheet where the Google Drive images were the result of a form, so I created a calculated field in the Sheet to do the transformation (using ARRAYFORMULA in order for it to update every time a new record was submitted). It looked like this:

={"ExportURL"; ARRAYFORMULA((IF(ISBLANK(G2:G), "" ,ARRAYFORMULA(Concat("https://drive.google.com/uc?export=view&id=", REGEXEXTRACT($F$2:$F,"id=([^&]+)"))))))}

(here is a link to the example Sheet and Report)