This week’s Friday challenge is to make multiple API calls on Power BI. I’ve decided to play around with one of my favourite things in the world – Nintendo’s Animal Crossing New Horizons (ACNH)! This is the first part of the revenue tracking project.
1. Read API documentation
Just like making calls to any other API, the first step is to read the documentation. In this case, there are no refresh limit or pagination, but an Access Key is required. After submitting the application, I only received a reply the next day. Should you also be interested in the same API, head over to Nookipedia’s website – they seem to have everything that ever existed in ACNH.
2. Home > Get Data > Web
3. Configure Web Data Source
Configure the Parameters by adding the key and the UUID access key granted to you. Then click OK.
4. Start transforming data
Voila! Your table is ready for transformation!
