{"id":12420,"date":"2026-08-21T03:28:31","date_gmt":"2026-08-21T03:28:31","guid":{"rendered":"https:\/\/zappysys.com\/blog\/?p=12420"},"modified":"2026-08-21T15:18:47","modified_gmt":"2026-08-21T15:18:47","slug":"how-to-get-data-from-spotify-into-power-bi","status":"publish","type":"post","link":"https:\/\/zappysys.com\/blog\/how-to-get-data-from-spotify-into-power-bi\/","title":{"rendered":"How to get data from Spotify into Power BI"},"content":{"rendered":"<h2>Introduction<\/h2>\n<p><a href=\"https:\/\/zappysys.com\/blog\/wp-content\/uploads\/2026\/08\/Spoify-logo.png\"><img loading=\"lazy\" decoding=\"async\" class=\"wp-image-12416 alignleft\" src=\"https:\/\/zappysys.com\/blog\/wp-content\/uploads\/2026\/08\/Spoify-logo-150x150.png\" alt=\"\" width=\"106\" height=\"106\" srcset=\"https:\/\/zappysys.com\/blog\/wp-content\/uploads\/2026\/08\/Spoify-logo-150x150.png 150w, https:\/\/zappysys.com\/blog\/wp-content\/uploads\/2026\/08\/Spoify-logo-300x300.png 300w, https:\/\/zappysys.com\/blog\/wp-content\/uploads\/2026\/08\/Spoify-logo-768x769.png 768w, https:\/\/zappysys.com\/blog\/wp-content\/uploads\/2026\/08\/Spoify-logo.png 939w\" sizes=\"(max-width: 106px) 100vw, 106px\" \/><\/a>Spotify Web API exposes rich data for artists, albums, tracks, playlists, and categories. If you want to build dashboards from this data, you can connect Spotify to Power BI through an ODBC layer and query API responses using SQL.<\/p>\n<p>In this tutorial, you will learn how to configure the ZappySys ODBC Driver for REST APIs for Spotify, test the connection, and load Spotify data into Power BI.<\/p>\n<div class=\"content_block\" id=\"custom_post_widget-9166\"><h2>Prerequisites<\/h2>\r\nTo access your data in your app using the ODBC Driver, ensure the following requirements are met.\r\n\r\nDownload and install <a href=\"https:\/\/zappysys.com\/products\/odbc-powerpack\/download\/\" rel=\"noopener\">ZappySys ODBC PowerPack<\/a><\/div>\n<h2>Steps<\/h2>\n<h3>Create a Spotify Developer App<\/h3>\n<ol>\n<li>Open the <a href=\"https:\/\/developer.spotify.com\/dashboard\" target=\"_blank\" rel=\"noopener\">Spotify Developer Dashboard<\/a> and sign in with any free or premium Spotify account.<\/li>\n<li>Click <strong>Create app<\/strong>, then enter an app name, description, and a redirect URL (for example: <code>http:\/\/127.0.0.1:3000<\/code>).\n<div id=\"attachment_12414\" style=\"width: 1688px\" class=\"wp-caption alignnone\"><a href=\"https:\/\/zappysys.com\/blog\/wp-content\/uploads\/2026\/08\/Spoify-Create-app.png\"><img loading=\"lazy\" decoding=\"async\" aria-describedby=\"caption-attachment-12414\" class=\"size-full wp-image-12414\" src=\"https:\/\/zappysys.com\/blog\/wp-content\/uploads\/2026\/08\/Spoify-Create-app.png\" alt=\"\" width=\"1678\" height=\"599\" srcset=\"https:\/\/zappysys.com\/blog\/wp-content\/uploads\/2026\/08\/Spoify-Create-app.png 1678w, https:\/\/zappysys.com\/blog\/wp-content\/uploads\/2026\/08\/Spoify-Create-app-300x107.png 300w, https:\/\/zappysys.com\/blog\/wp-content\/uploads\/2026\/08\/Spoify-Create-app-1024x366.png 1024w, https:\/\/zappysys.com\/blog\/wp-content\/uploads\/2026\/08\/Spoify-Create-app-768x274.png 768w, https:\/\/zappysys.com\/blog\/wp-content\/uploads\/2026\/08\/Spoify-Create-app-1536x548.png 1536w\" sizes=\"(max-width: 1678px) 100vw, 1678px\" \/><\/a><p id=\"caption-attachment-12414\" class=\"wp-caption-text\">Spotify &#8211; Create app<\/p><\/div><\/li>\n<li>Open app <strong>Settings<\/strong> and copy your <strong>Client ID<\/strong> and <strong>Client Secret<\/strong>.<\/li>\n<li>Store these credentials securely.<\/li>\n<\/ol>\n<h3>Create a New ODBC DSN Using ZappySys JSON Driver<\/h3>\n<ol>\n<li>Search for <strong>ODBC<\/strong> in the Windows Start menu and open <strong>ODBC Data Source Administrator<\/strong>.<br \/>\n<a href=\"https:\/\/zappysys.com\/blog\/wp-content\/uploads\/2019\/01\/how-to-open-odbc-data-source-administrator-2.png\"><img loading=\"lazy\" decoding=\"async\" class=\"alignnone size-full wp-image-6213\" src=\"https:\/\/zappysys.com\/blog\/wp-content\/uploads\/2019\/01\/how-to-open-odbc-data-source-administrator-2.png\" alt=\"\" width=\"394\" height=\"542\" srcset=\"https:\/\/zappysys.com\/blog\/wp-content\/uploads\/2019\/01\/how-to-open-odbc-data-source-administrator-2.png 394w, https:\/\/zappysys.com\/blog\/wp-content\/uploads\/2019\/01\/how-to-open-odbc-data-source-administrator-2-218x300.png 218w\" sizes=\"(max-width: 394px) 100vw, 394px\" \/><\/a><\/li>\n<li>In <strong>User DSN<\/strong> or <strong>System DSN<\/strong>, click <strong>Add<\/strong>.<\/li>\n<li>Select <strong>ZappySys JSON Driver<\/strong> and click <strong>Continue<\/strong>.<br \/>\n<a href=\"https:\/\/zappysys.com\/blog\/wp-content\/uploads\/2019\/01\/odbc-dsn-admin-create-dsn-based-on-json-driver.png\"><img loading=\"lazy\" decoding=\"async\" class=\"alignnone size-full wp-image-5919\" src=\"https:\/\/zappysys.com\/blog\/wp-content\/uploads\/2019\/01\/odbc-dsn-admin-create-dsn-based-on-json-driver.png\" alt=\"\" width=\"593\" height=\"504\" srcset=\"https:\/\/zappysys.com\/blog\/wp-content\/uploads\/2019\/01\/odbc-dsn-admin-create-dsn-based-on-json-driver.png 593w, https:\/\/zappysys.com\/blog\/wp-content\/uploads\/2019\/01\/odbc-dsn-admin-create-dsn-based-on-json-driver-300x255.png 300w\" sizes=\"(max-width: 593px) 100vw, 593px\" \/><\/a><\/li>\n<\/ol>\n<h3>Configure the Connection and API Settings<\/h3>\n<ol>\n<li>Enter a Spotify endpoint URL. Example:\n<pre class=\"lang:default decode:true\">https:\/\/api.spotify.com\/v1\/search?q=genre:pop&amp;type=artist&amp;limit=50<\/pre>\n<\/li>\n<li>In <strong>Connection Type<\/strong>, select\u00a0<strong>OAuth\u00a0<\/strong>and\u00a0click <strong>Configure<\/strong>.<\/li>\n<li>Set <strong>Credential Type<\/strong> to <strong>OAuth2 \/ Client Credentials Grant<\/strong> and fill in the following values:\n<ul>\n<li><strong>Client ID:<\/strong> Your Spotify Client ID<\/li>\n<li><strong>Client Secret:<\/strong> Your Spotify Client Secret<\/li>\n<li><strong>Access Token URL:<\/strong> <code>https:\/\/accounts.spotify.com\/api\/token<\/code><\/li>\n<li><strong>Scopes\/Permissions:<\/strong> (leave empty)<\/li>\n<\/ul>\n<\/li>\n<li>Click <strong>OK<\/strong> to save HTTP authentication settings.\n<div class=\"mceTemp\"><\/div>\n<div id=\"attachment_12421\" style=\"width: 628px\" class=\"wp-caption alignnone\"><a href=\"https:\/\/zappysys.com\/blog\/wp-content\/uploads\/2026\/08\/Spoify-ODBC-OAuth-connection.png\"><img loading=\"lazy\" decoding=\"async\" aria-describedby=\"caption-attachment-12421\" class=\"size-full wp-image-12421\" src=\"https:\/\/zappysys.com\/blog\/wp-content\/uploads\/2026\/08\/Spoify-ODBC-OAuth-connection.png\" alt=\"\" width=\"618\" height=\"473\" srcset=\"https:\/\/zappysys.com\/blog\/wp-content\/uploads\/2026\/08\/Spoify-ODBC-OAuth-connection.png 618w, https:\/\/zappysys.com\/blog\/wp-content\/uploads\/2026\/08\/Spoify-ODBC-OAuth-connection-300x230.png 300w\" sizes=\"(max-width: 618px) 100vw, 618px\" \/><\/a><p id=\"caption-attachment-12421\" class=\"wp-caption-text\">Spotify ODBC OAuth connection<\/p><\/div><\/li>\n<li>Set <strong>HTTP Request Method<\/strong> to <strong>GET<\/strong>.<\/li>\n<li>Add the following <strong>HTTP Header<\/strong>:\n<ul>\n<li><strong>Accept:<\/strong> application\/json<\/li>\n<\/ul>\n<\/li>\n<li>Set <strong>JSON Path Filter<\/strong> to:\n<pre class=\"lang:default decode:true\">$.artists.items[*]<\/pre>\n<\/li>\n<li>Click <strong>Test Connection<\/strong>, then click <strong>OK<\/strong> to save the DSN.\n<div id=\"attachment_12422\" style=\"width: 814px\" class=\"wp-caption alignnone\"><a href=\"https:\/\/zappysys.com\/blog\/wp-content\/uploads\/2026\/08\/Spoify-ODBC-JSON-driver-configuration.png\"><img loading=\"lazy\" decoding=\"async\" aria-describedby=\"caption-attachment-12422\" class=\"size-full wp-image-12422\" src=\"https:\/\/zappysys.com\/blog\/wp-content\/uploads\/2026\/08\/Spoify-ODBC-JSON-driver-configuration.png\" alt=\"\" width=\"804\" height=\"704\" srcset=\"https:\/\/zappysys.com\/blog\/wp-content\/uploads\/2026\/08\/Spoify-ODBC-JSON-driver-configuration.png 804w, https:\/\/zappysys.com\/blog\/wp-content\/uploads\/2026\/08\/Spoify-ODBC-JSON-driver-configuration-300x263.png 300w, https:\/\/zappysys.com\/blog\/wp-content\/uploads\/2026\/08\/Spoify-ODBC-JSON-driver-configuration-768x672.png 768w\" sizes=\"(max-width: 804px) 100vw, 804px\" \/><\/a><p id=\"caption-attachment-12422\" class=\"wp-caption-text\">Spotify &#8211; ODBC JSON driver configuration<\/p><\/div><\/li>\n<\/ol>\n<h3>Preview Spotify Data in ODBC Driver<\/h3>\n<ol>\n<li>Open the <strong>Preview<\/strong> tab in the DSN configuration window.<\/li>\n<li>Generate a query and click <strong>Preview Data<\/strong>.<\/li>\n<li>Confirm rows are returned. If not, recheck credentials, endpoint URL, and JSON Path Filter.\n<div id=\"attachment_12423\" style=\"width: 814px\" class=\"wp-caption alignnone\"><a href=\"https:\/\/zappysys.com\/blog\/wp-content\/uploads\/2026\/08\/Spoify-ODBC-preview-data.png\"><img loading=\"lazy\" decoding=\"async\" aria-describedby=\"caption-attachment-12423\" class=\"size-full wp-image-12423\" src=\"https:\/\/zappysys.com\/blog\/wp-content\/uploads\/2026\/08\/Spoify-ODBC-preview-data.png\" alt=\"\" width=\"804\" height=\"704\" srcset=\"https:\/\/zappysys.com\/blog\/wp-content\/uploads\/2026\/08\/Spoify-ODBC-preview-data.png 804w, https:\/\/zappysys.com\/blog\/wp-content\/uploads\/2026\/08\/Spoify-ODBC-preview-data-300x263.png 300w, https:\/\/zappysys.com\/blog\/wp-content\/uploads\/2026\/08\/Spoify-ODBC-preview-data-768x672.png 768w\" sizes=\"(max-width: 804px) 100vw, 804px\" \/><\/a><p id=\"caption-attachment-12423\" class=\"wp-caption-text\">Spotify &#8211; ODBC preview data<\/p><\/div><\/li>\n<\/ol>\n<h3>Connect Power BI to Spotify via ODBC<\/h3>\n<ol>\n<li>Open <strong>Power BI Desktop<\/strong>.<\/li>\n<li>Go to <strong>Home<\/strong> &gt; <strong>Get Data<\/strong> &gt; <strong>More&#8230;<\/strong>.<\/li>\n<li>Search for <strong>ODBC<\/strong> and click <strong>Connect<\/strong>.\n<div id=\"attachment_12178\" style=\"width: 1395px\" class=\"wp-caption alignnone\"><a href=\"https:\/\/zappysys.com\/blog\/wp-content\/uploads\/2026\/05\/Power-BI-Get-data-from-ODBC-connection.png\"><img loading=\"lazy\" decoding=\"async\" aria-describedby=\"caption-attachment-12178\" class=\"size-full wp-image-12178\" src=\"https:\/\/zappysys.com\/blog\/wp-content\/uploads\/2026\/05\/Power-BI-Get-data-from-ODBC-connection.png\" alt=\"\" width=\"1385\" height=\"782\" srcset=\"https:\/\/zappysys.com\/blog\/wp-content\/uploads\/2026\/05\/Power-BI-Get-data-from-ODBC-connection.png 1385w, https:\/\/zappysys.com\/blog\/wp-content\/uploads\/2026\/05\/Power-BI-Get-data-from-ODBC-connection-300x169.png 300w, https:\/\/zappysys.com\/blog\/wp-content\/uploads\/2026\/05\/Power-BI-Get-data-from-ODBC-connection-1024x578.png 1024w, https:\/\/zappysys.com\/blog\/wp-content\/uploads\/2026\/05\/Power-BI-Get-data-from-ODBC-connection-768x434.png 768w\" sizes=\"(max-width: 1385px) 100vw, 1385px\" \/><\/a><p id=\"caption-attachment-12178\" class=\"wp-caption-text\">Power BI &#8211; Get data from ODBC connection<\/p><\/div><\/li>\n<li>Select your Spotify DSN from the data source list.<\/li>\n<li>Optionally enter a custom SQL query in <strong>Advanced options<\/strong>.\n<div id=\"attachment_12425\" style=\"width: 712px\" class=\"wp-caption alignnone\"><a href=\"https:\/\/zappysys.com\/blog\/wp-content\/uploads\/2026\/08\/Power-Bi-Enter-query-Spotify.png\"><img loading=\"lazy\" decoding=\"async\" aria-describedby=\"caption-attachment-12425\" class=\"size-full wp-image-12425\" src=\"https:\/\/zappysys.com\/blog\/wp-content\/uploads\/2026\/08\/Power-Bi-Enter-query-Spotify.png\" alt=\"\" width=\"702\" height=\"533\" srcset=\"https:\/\/zappysys.com\/blog\/wp-content\/uploads\/2026\/08\/Power-Bi-Enter-query-Spotify.png 702w, https:\/\/zappysys.com\/blog\/wp-content\/uploads\/2026\/08\/Power-Bi-Enter-query-Spotify-300x228.png 300w\" sizes=\"(max-width: 702px) 100vw, 702px\" \/><\/a><p id=\"caption-attachment-12425\" class=\"wp-caption-text\">Power BI &#8211; Enter query Spotify<\/p><\/div><\/li>\n<li>Click <strong>OK<\/strong>, review the preview, and click <strong>Load<\/strong>.\n<div class=\"mceTemp\"><\/div>\n<div id=\"attachment_12424\" style=\"width: 892px\" class=\"wp-caption alignnone\"><a href=\"https:\/\/zappysys.com\/blog\/wp-content\/uploads\/2026\/08\/Power-Bi-Spotify-Result.png\"><img loading=\"lazy\" decoding=\"async\" aria-describedby=\"caption-attachment-12424\" class=\"size-full wp-image-12424\" src=\"https:\/\/zappysys.com\/blog\/wp-content\/uploads\/2026\/08\/Power-Bi-Spotify-Result.png\" alt=\"\" width=\"882\" height=\"662\" srcset=\"https:\/\/zappysys.com\/blog\/wp-content\/uploads\/2026\/08\/Power-Bi-Spotify-Result.png 882w, https:\/\/zappysys.com\/blog\/wp-content\/uploads\/2026\/08\/Power-Bi-Spotify-Result-300x225.png 300w, https:\/\/zappysys.com\/blog\/wp-content\/uploads\/2026\/08\/Power-Bi-Spotify-Result-768x576.png 768w\" sizes=\"(max-width: 882px) 100vw, 882px\" \/><\/a><p id=\"caption-attachment-12424\" class=\"wp-caption-text\">Power BI &#8211; Spotify Result<\/p><\/div><\/li>\n<li>In the Navigator, select fields or tables you want to import into your model.<\/li>\n<\/ol>\n<h3>Query Spotify Data with SQL<\/h3>\n<p>Use custom SQL queries in the ODBC driver or Power BI to shape data before loading.<\/p>\n<p dir=\"ltr\"><strong>Example 1: List All Artists<\/strong><\/p>\n<div tabindex=\"0\" role=\"group\" aria-label=\"C\u00f3digo en sql\">\n<div>\n<pre><code class=\"language-sql\">SELECT\r\n    id,\r\n    name,\r\n    type,\r\n    popularity,\r\n    followers_total,\r\n    uri\r\nFROM _root_<\/code><\/pre>\n<\/div>\n<\/div>\n<hr \/>\n<p dir=\"ltr\"><strong>Example 2: Filter Highly Popular Artists<\/strong><\/p>\n<div tabindex=\"0\" role=\"group\" aria-label=\"C\u00f3digo en sql\">\n<div>\n<pre><code class=\"language-sql\">SELECT\r\n    id,\r\n    name,\r\n    popularity,\r\n    followers_total\r\nFROM _root_\r\nWHERE popularity &gt;= 80\r\nORDER BY popularity DESC<\/code><\/pre>\n<\/div>\n<\/div>\n<hr \/>\n<p dir=\"ltr\"><strong>Example 3: Artists with Large Followings<\/strong><\/p>\n<div tabindex=\"0\" role=\"group\" aria-label=\"C\u00f3digo en sql\">\n<div>\n<pre><code class=\"language-sql\">SELECT\r\n    id,\r\n    name,\r\n    followers_total,\r\n    popularity\r\nFROM _root_\r\nWHERE followers_total &gt;= 1000000\r\nORDER BY followers_total DESC<\/code><\/pre>\n<\/div>\n<\/div>\n<hr \/>\n<p dir=\"ltr\"><strong>Example 4: Search by Genre<\/strong><\/p>\n<div tabindex=\"0\" role=\"group\" aria-label=\"C\u00f3digo en sql\">\n<div>\n<pre class=\"\"><code class=\"language-sql\">SELECT\r\n    id,\r\n    name,\r\n    genres,\r\n    popularity\r\nFROM _root_\r\nWHERE genres LIKE '%pop%'\r\nORDER BY popularity DESC<\/code><\/pre>\n<\/div>\n<\/div>\n<h2>Conclusion<\/h2>\n<p>Connecting Spotify to Power BI using the ZappySys ODBC Driver gives you a fast way to analyze music catalog trends and artist metrics with SQL and dashboards. Once your DSN is configured, you can reuse the same pattern for tracks, albums, playlists, categories, and market-specific reporting.<\/p>\n<p>Explore more connectors and API integrations with the <a href=\"https:\/\/zappysys.com\/products\/odbc-drivers\/\" target=\"_blank\" rel=\"noopener\">ZappySys ODBC Drivers<\/a>.<\/p>\n<div class=\"content_block\" id=\"custom_post_widget-12354\"><h3>Need Help?<\/h3><p class=\"section-intro\">If you encounter any issues, our support team is here to help:<\/p>\r\n\r\n<ol>\r\n \t<li><strong>Live Chat:<\/strong>\u00a0Open the chat widget\u00a0<em>(bottom right of this page)<\/em><\/li>\r\n \t<li><strong>Email:<\/strong>\u00a0<a href=\"mailto:support@zappysys.com\">support@zappysys.com<\/a><\/li>\r\n \t<li><strong>Support Center:<\/strong>\u00a0<a href=\"https:\/\/zappysys.com\/support\/\">Support | ZappySys<\/a><\/li>\r\n<\/ol><\/div>\n","protected":false},"excerpt":{"rendered":"<p>Introduction Spotify Web API exposes rich data for artists, albums, tracks, playlists, and categories. If you want to build dashboards from this data, you can connect Spotify to Power BI through an ODBC layer and query API responses using SQL. In this tutorial, you will learn how to configure the ZappySys ODBC Driver for REST [&hellip;]<\/p>\n","protected":false},"author":5,"featured_media":12416,"comment_status":"closed","ping_status":"closed","sticky":false,"template":"","format":"standard","meta":{"footnotes":""},"categories":[1],"tags":[],"yoast_head":"<!-- This site is optimized with the Yoast SEO plugin v22.3 - https:\/\/yoast.com\/wordpress\/plugins\/seo\/ -->\r\n<title>How to get data from Spotify into Power BI | ZappySys Blog<\/title>\r\n<meta name=\"description\" content=\"How to get data from Spotify into Power BI - ZappySys Blog\" \/>\r\n<meta name=\"robots\" content=\"index, follow, max-snippet:-1, max-image-preview:large, max-video-preview:-1\" \/>\r\n<link rel=\"canonical\" href=\"https:\/\/zappysys.com\/blog\/how-to-get-data-from-spotify-into-power-bi\/\" \/>\r\n<meta property=\"og:locale\" content=\"en_US\" \/>\r\n<meta property=\"og:type\" content=\"article\" \/>\r\n<meta property=\"og:title\" content=\"How to get data from Spotify into Power BI | ZappySys Blog\" \/>\r\n<meta property=\"og:description\" content=\"How to get data from Spotify into Power BI - ZappySys Blog\" \/>\r\n<meta property=\"og:url\" content=\"https:\/\/zappysys.com\/blog\/how-to-get-data-from-spotify-into-power-bi\/\" \/>\r\n<meta property=\"og:site_name\" content=\"ZappySys Blog\" \/>\r\n<meta property=\"article:published_time\" content=\"2026-08-21T03:28:31+00:00\" \/>\r\n<meta property=\"article:modified_time\" content=\"2026-08-21T15:18:47+00:00\" \/>\r\n<meta property=\"og:image\" content=\"https:\/\/zappysys.com\/blog\/wp-content\/uploads\/2026\/08\/Spoify-logo.png\" \/>\r\n\t<meta property=\"og:image:width\" content=\"939\" \/>\r\n\t<meta property=\"og:image:height\" content=\"940\" \/>\r\n\t<meta property=\"og:image:type\" content=\"image\/png\" \/>\r\n<meta name=\"author\" content=\"ZappySys Team\" \/>\r\n<meta name=\"twitter:card\" content=\"summary_large_image\" \/>\r\n<meta name=\"twitter:label1\" content=\"Written by\" \/>\n\t<meta name=\"twitter:data1\" content=\"ZappySys Team\" \/>\n\t<meta name=\"twitter:label2\" content=\"Est. reading time\" \/>\n\t<meta name=\"twitter:data2\" content=\"5 minutes\" \/>\r\n<script type=\"application\/ld+json\" class=\"yoast-schema-graph\">{\"@context\":\"https:\/\/schema.org\",\"@graph\":[{\"@type\":\"WebPage\",\"@id\":\"https:\/\/zappysys.com\/blog\/how-to-get-data-from-spotify-into-power-bi\/\",\"url\":\"https:\/\/zappysys.com\/blog\/how-to-get-data-from-spotify-into-power-bi\/\",\"name\":\"How to get data from Spotify into Power BI | ZappySys Blog\",\"isPartOf\":{\"@id\":\"https:\/\/zappysys.com\/blog\/#website\"},\"primaryImageOfPage\":{\"@id\":\"https:\/\/zappysys.com\/blog\/how-to-get-data-from-spotify-into-power-bi\/#primaryimage\"},\"image\":{\"@id\":\"https:\/\/zappysys.com\/blog\/how-to-get-data-from-spotify-into-power-bi\/#primaryimage\"},\"thumbnailUrl\":\"https:\/\/zappysys.com\/blog\/wp-content\/uploads\/2026\/08\/Spoify-logo.png\",\"datePublished\":\"2026-08-21T03:28:31+00:00\",\"dateModified\":\"2026-08-21T15:18:47+00:00\",\"author\":{\"@id\":\"https:\/\/zappysys.com\/blog\/#\/schema\/person\/91b041e2dcf7ece5f068893c1a68ac6e\"},\"description\":\"How to get data from Spotify into Power BI - ZappySys Blog\",\"breadcrumb\":{\"@id\":\"https:\/\/zappysys.com\/blog\/how-to-get-data-from-spotify-into-power-bi\/#breadcrumb\"},\"inLanguage\":\"en-US\",\"potentialAction\":[{\"@type\":\"ReadAction\",\"target\":[\"https:\/\/zappysys.com\/blog\/how-to-get-data-from-spotify-into-power-bi\/\"]}]},{\"@type\":\"ImageObject\",\"inLanguage\":\"en-US\",\"@id\":\"https:\/\/zappysys.com\/blog\/how-to-get-data-from-spotify-into-power-bi\/#primaryimage\",\"url\":\"https:\/\/zappysys.com\/blog\/wp-content\/uploads\/2026\/08\/Spoify-logo.png\",\"contentUrl\":\"https:\/\/zappysys.com\/blog\/wp-content\/uploads\/2026\/08\/Spoify-logo.png\",\"width\":939,\"height\":940},{\"@type\":\"BreadcrumbList\",\"@id\":\"https:\/\/zappysys.com\/blog\/how-to-get-data-from-spotify-into-power-bi\/#breadcrumb\",\"itemListElement\":[{\"@type\":\"ListItem\",\"position\":1,\"name\":\"Home\",\"item\":\"https:\/\/zappysys.com\/blog\/\"},{\"@type\":\"ListItem\",\"position\":2,\"name\":\"How to get data from Spotify into Power BI\"}]},{\"@type\":\"WebSite\",\"@id\":\"https:\/\/zappysys.com\/blog\/#website\",\"url\":\"https:\/\/zappysys.com\/blog\/\",\"name\":\"ZappySys Blog\",\"description\":\"SSIS \/ ODBC Drivers \/ API Connectors for JSON, XML, Azure, Amazon AWS, Salesforce, MongoDB and more\",\"potentialAction\":[{\"@type\":\"SearchAction\",\"target\":{\"@type\":\"EntryPoint\",\"urlTemplate\":\"https:\/\/zappysys.com\/blog\/?s={search_term_string}\"},\"query-input\":\"required name=search_term_string\"}],\"inLanguage\":\"en-US\"},{\"@type\":\"Person\",\"@id\":\"https:\/\/zappysys.com\/blog\/#\/schema\/person\/91b041e2dcf7ece5f068893c1a68ac6e\",\"name\":\"ZappySys Team\",\"image\":{\"@type\":\"ImageObject\",\"inLanguage\":\"en-US\",\"@id\":\"https:\/\/zappysys.com\/blog\/#\/schema\/person\/image\/\",\"url\":\"https:\/\/secure.gravatar.com\/avatar\/746bec9c9d27f1b90bb181aa516ee234?s=96&d=mm&r=g\",\"contentUrl\":\"https:\/\/secure.gravatar.com\/avatar\/746bec9c9d27f1b90bb181aa516ee234?s=96&d=mm&r=g\",\"caption\":\"ZappySys Team\"},\"sameAs\":[\"https:\/\/zappysys.com\"],\"url\":\"https:\/\/zappysys.com\/blog\/author\/dcalbimonte\/\"}]}<\/script>\r\n<!-- \/ Yoast SEO plugin. -->","yoast_head_json":{"title":"How to get data from Spotify into Power BI | ZappySys Blog","description":"How to get data from Spotify into Power BI - ZappySys Blog","robots":{"index":"index","follow":"follow","max-snippet":"max-snippet:-1","max-image-preview":"max-image-preview:large","max-video-preview":"max-video-preview:-1"},"canonical":"https:\/\/zappysys.com\/blog\/how-to-get-data-from-spotify-into-power-bi\/","og_locale":"en_US","og_type":"article","og_title":"How to get data from Spotify into Power BI | ZappySys Blog","og_description":"How to get data from Spotify into Power BI - ZappySys Blog","og_url":"https:\/\/zappysys.com\/blog\/how-to-get-data-from-spotify-into-power-bi\/","og_site_name":"ZappySys Blog","article_published_time":"2026-08-21T03:28:31+00:00","article_modified_time":"2026-08-21T15:18:47+00:00","og_image":[{"width":939,"height":940,"url":"https:\/\/zappysys.com\/blog\/wp-content\/uploads\/2026\/08\/Spoify-logo.png","type":"image\/png"}],"author":"ZappySys Team","twitter_card":"summary_large_image","twitter_misc":{"Written by":"ZappySys Team","Est. reading time":"5 minutes"},"schema":{"@context":"https:\/\/schema.org","@graph":[{"@type":"WebPage","@id":"https:\/\/zappysys.com\/blog\/how-to-get-data-from-spotify-into-power-bi\/","url":"https:\/\/zappysys.com\/blog\/how-to-get-data-from-spotify-into-power-bi\/","name":"How to get data from Spotify into Power BI | ZappySys Blog","isPartOf":{"@id":"https:\/\/zappysys.com\/blog\/#website"},"primaryImageOfPage":{"@id":"https:\/\/zappysys.com\/blog\/how-to-get-data-from-spotify-into-power-bi\/#primaryimage"},"image":{"@id":"https:\/\/zappysys.com\/blog\/how-to-get-data-from-spotify-into-power-bi\/#primaryimage"},"thumbnailUrl":"https:\/\/zappysys.com\/blog\/wp-content\/uploads\/2026\/08\/Spoify-logo.png","datePublished":"2026-08-21T03:28:31+00:00","dateModified":"2026-08-21T15:18:47+00:00","author":{"@id":"https:\/\/zappysys.com\/blog\/#\/schema\/person\/91b041e2dcf7ece5f068893c1a68ac6e"},"description":"How to get data from Spotify into Power BI - ZappySys Blog","breadcrumb":{"@id":"https:\/\/zappysys.com\/blog\/how-to-get-data-from-spotify-into-power-bi\/#breadcrumb"},"inLanguage":"en-US","potentialAction":[{"@type":"ReadAction","target":["https:\/\/zappysys.com\/blog\/how-to-get-data-from-spotify-into-power-bi\/"]}]},{"@type":"ImageObject","inLanguage":"en-US","@id":"https:\/\/zappysys.com\/blog\/how-to-get-data-from-spotify-into-power-bi\/#primaryimage","url":"https:\/\/zappysys.com\/blog\/wp-content\/uploads\/2026\/08\/Spoify-logo.png","contentUrl":"https:\/\/zappysys.com\/blog\/wp-content\/uploads\/2026\/08\/Spoify-logo.png","width":939,"height":940},{"@type":"BreadcrumbList","@id":"https:\/\/zappysys.com\/blog\/how-to-get-data-from-spotify-into-power-bi\/#breadcrumb","itemListElement":[{"@type":"ListItem","position":1,"name":"Home","item":"https:\/\/zappysys.com\/blog\/"},{"@type":"ListItem","position":2,"name":"How to get data from Spotify into Power BI"}]},{"@type":"WebSite","@id":"https:\/\/zappysys.com\/blog\/#website","url":"https:\/\/zappysys.com\/blog\/","name":"ZappySys Blog","description":"SSIS \/ ODBC Drivers \/ API Connectors for JSON, XML, Azure, Amazon AWS, Salesforce, MongoDB and more","potentialAction":[{"@type":"SearchAction","target":{"@type":"EntryPoint","urlTemplate":"https:\/\/zappysys.com\/blog\/?s={search_term_string}"},"query-input":"required name=search_term_string"}],"inLanguage":"en-US"},{"@type":"Person","@id":"https:\/\/zappysys.com\/blog\/#\/schema\/person\/91b041e2dcf7ece5f068893c1a68ac6e","name":"ZappySys Team","image":{"@type":"ImageObject","inLanguage":"en-US","@id":"https:\/\/zappysys.com\/blog\/#\/schema\/person\/image\/","url":"https:\/\/secure.gravatar.com\/avatar\/746bec9c9d27f1b90bb181aa516ee234?s=96&d=mm&r=g","contentUrl":"https:\/\/secure.gravatar.com\/avatar\/746bec9c9d27f1b90bb181aa516ee234?s=96&d=mm&r=g","caption":"ZappySys Team"},"sameAs":["https:\/\/zappysys.com"],"url":"https:\/\/zappysys.com\/blog\/author\/dcalbimonte\/"}]}},"_links":{"self":[{"href":"https:\/\/zappysys.com\/blog\/wp-json\/wp\/v2\/posts\/12420"}],"collection":[{"href":"https:\/\/zappysys.com\/blog\/wp-json\/wp\/v2\/posts"}],"about":[{"href":"https:\/\/zappysys.com\/blog\/wp-json\/wp\/v2\/types\/post"}],"author":[{"embeddable":true,"href":"https:\/\/zappysys.com\/blog\/wp-json\/wp\/v2\/users\/5"}],"replies":[{"embeddable":true,"href":"https:\/\/zappysys.com\/blog\/wp-json\/wp\/v2\/comments?post=12420"}],"version-history":[{"count":5,"href":"https:\/\/zappysys.com\/blog\/wp-json\/wp\/v2\/posts\/12420\/revisions"}],"predecessor-version":[{"id":12437,"href":"https:\/\/zappysys.com\/blog\/wp-json\/wp\/v2\/posts\/12420\/revisions\/12437"}],"wp:featuredmedia":[{"embeddable":true,"href":"https:\/\/zappysys.com\/blog\/wp-json\/wp\/v2\/media\/12416"}],"wp:attachment":[{"href":"https:\/\/zappysys.com\/blog\/wp-json\/wp\/v2\/media?parent=12420"}],"wp:term":[{"taxonomy":"category","embeddable":true,"href":"https:\/\/zappysys.com\/blog\/wp-json\/wp\/v2\/categories?post=12420"},{"taxonomy":"post_tag","embeddable":true,"href":"https:\/\/zappysys.com\/blog\/wp-json\/wp\/v2\/tags?post=12420"}],"curies":[{"name":"wp","href":"https:\/\/api.w.org\/{rel}","templated":true}]}}