Spotify Podcast Data Ingestion

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.