How to connect Power BI to the Spotify API - Tutorial
A step-by-step tutorial on how to connect to the Spotify API in Power BI and collect data for a list of your favorite artists: artist data, albums, tracks and track features.
Principles that can be applied on other Spotify endpoints as well.
Please find the M code shown in the tutorial here: https://tinyurl.com/2uv65cys
Connect with Jonathan van der Waard via / jonathan-van-der-waard
VIDEO CHAPTERS
----------------------------------------------------------------------
00:00 – Introduction and what to expect
03:00 – Explore the Spotify API Console
08:42 – Make our first Spotify API call in Power BI
14:55 – Create a function to call Spotify API for a list
21:57 – Cleaning and structure
31:19 – Collect the first 50 albums of each artist + Privacy Settings
42:46 – Collect all albums of each artist (Offset function)
56:59 – Review, comments on Audio Features and some code for next steps