2022 Week 52 | Power BI: Image Carousel

Introduction

“Hot days, warm nights, beaches, backyard cricket and Christmas¬†celebrations are all part of summer in the Southern Hemisphere.”

This week we will be connecting to a public flickr photo gallery from the State Library of South Australia, to create an image carousel using a custom visual from AppSource.

Requirements

Power Query
  1. Connect to the Flickr photo album using Developer API or public feed (see Dataset information below)
  2. If using public feed, use query string parameters id=32600408@N06; tags=australiansummer,australiansummerchristmas ; tagmode=any

  3. or connect to another public album of your choosing

    (HINT: Learn more about URL Query Parameters <here>)

  4. Obtain the picture URLs and descriptions
  5. Load
Power BI Desktop
  1. Import Image Carousel Custom Visual found in AppSource
  2. Place the Image URL field in the visual field well
  3. Format as desired.

Dataset

The dataset this week can be viewed here: https://data.sa.gov.au/data/dataset/summer-under-southern-skies.

Use in conjunction with the Flickr API https://www.flickr.com/services/api/ or Public Feed https://www.flickr.com/services/feeds/docs/photos_public/

Share

After you finish your workout, share on Twitter using the hashtags #WOW2022 and #PowerBI, and tag @JSBaucke@MMarie, @shan_gsd, @KerryKolosko@NerdyWithData. Also make sure to fill out the Submission Tracker so that we can count you as a participant this week in order to track our participation throughout the year.

Solution

Leave a Comment

Your email address will not be published. Required fields are marked *

Scroll to Top