Working with JSON Data in Power BI
In this article I’ll give a brief overview of how you can easily work with JSON formatted data in Power BI. To keep things interesting, we’ll create a simple listening history report from our JSON formatted Spotify data.
The first step in our example will source your personal data from Spotify. To do this, log onto www.spotify.com, click on “Account”, and then go to your privacy settings:
Next, scroll down to your personal data.