Even though I’ve tested it, I don’t really know if this will work as hoped for you and I’m probably not going to provide any timely support if it doesn’t work.
Cross your fingers, because I’ve never created a PBIT template before. When prompted, enter the path to the folder containing your Spotify JSON data. Open the PBIT file in Power BI Desktop. The other files probably contain other interesting data – who knows? This report uses only the “endsong*.json” files that contain your listening history. Locate the folder that contains JSON files. Extract the zip file to a folder on your PC. Download the zip file prepared by Spotify. Request a copy of your Spotify listening history by emailing Wait approximately 30 days for Spotify to prepare your data. If you’re interested in using my report as-is or as a starting point for your own analysis, I’ve shared a PBIT file here: It takes about a month to get your data, so if you want to report on your own listening history, you should probably email them today. Spotify doesn’t have a viable API for this type of analysis, but you can request a copy of your listening history and other account data by emailing. How do I know this? I know because for the past few years I’ve been reporting on my Spotify listening data. The song I’ve listened to the most is “O Father O Satan O Sun!” by Behemoth – Since March 2017 I’ve listened to it 620 times, for a total time of 69 hours, 15 minutes. I’ve listened to more Amon Amarth than I’ve listened to my next three top bands combined, but the album I’ve spent the most time listening to is “The Black Parade” by My Chemical Romance. 
I listen the most in the early morning when I’m at the gym and before my morning meetings begin. I’ve listened to music on Spotify for over 5,000 hours since I subscribed to their service.
0 kommentar(er)
