topic Re: Spotify Podcast Data Ingestion in Data Engineering

Spotify Podcast Data Ingestion

jvenegas20003 — Thu, 07 Aug 2025 14:40:54 GMT

My team is trying to ingest Spotify Podcast data and there doesn't seem to be a good way to ingest. Has anybody ingested data from Spotify already and have recommendations? Thank you so much for your help!

Re: Spotify Podcast Data Ingestion

wardy912 — Thu, 07 Aug 2025 15:03:26 GMT

Hi jvenegas20003

I haven't used this so wouldn't be able to answer any further questions, but it seems to solve your issue

GitHub - openpodcast/pipelines: Podcast Analytics Data collected from Spotify and stored in Open Podcast API

I hope this helps, please give a thumbs up and mark as solved if it does, thanks!

Re: Spotify Podcast Data Ingestion

v-veshwara-msft — Mon, 11 Aug 2025 06:42:14 GMT

Hi jvenegas20003 ,

Thanks for posting in the Microsoft Fabric Community.

Spotify does not have a direct connector in Fabric or Power BI, so the first step is to retrieve the data from Spotify. For podcast metadata such as shows and episodes, you can use the Spotify Web API by registering an application in the Spotify Developer Dashboard and authenticating using the client credentials or OAuth flow. More Details here: Spotify API

Web API | Spotify for Developers

Also, as pointed out by wardy912 , the openpodcast/pipelines project could help set up an ingestion pipeline for Spotify podcast data. Once the data is available, it can be ingested into Fabric using:

1. Dataflow Gen2 to connect to the API or process exported files

2. Fabric Notebooks to fetch, transform, and store the data in a Lakehouse or Warehouse

3. Export data from Spotify as CSV/JSON, drop it into OneLake via the Lakehouse Files area, and use shortcuts or pipelines to process it.

For more detailed guidance on extracting podcast data from Spotify, you may want to post in the Spotify Developer Community.
A similar query is already posted there: Pulling podcast data from API - The Spotify Community

Hope this helps. Please reach out for further assistance.

Thank you.

Re: Spotify Podcast Data Ingestion

v-veshwara-msft — Mon, 18 Aug 2025 06:29:48 GMT

Hi jvenegas20003 ,

Just checking in to see if you query is resolved and if any responses were helpful.
Otherwise, feel free to reach out for further assistance.

Thank you.

Re: Spotify Podcast Data Ingestion

v-veshwara-msft — Fri, 22 Aug 2025 04:57:54 GMT

Hi jvenegas20003 ,
We wanted to kindly follow up regarding your query. If you need any further assistance, please reach out.
Thank you.

Re: Spotify Podcast Data Ingestion

v-veshwara-msft — Tue, 26 Aug 2025 06:07:31 GMT

Hi jvenegas20003 ,
Just wanted to check if the responses provided were helpful. If further assistance is needed, please reach out.
Thank you.