MIP Logo

API calls on Power BI

This post was originally published on The Data School blog between 2018 and July 2025, before our program was renamed to MIP’s Analytics Career Accelerator. References throughout this article to “The Data School” or “DS” all refer to what is now MIP’s Analytics Career Accelerator. The program, its people, and its commitment to launching outstanding analytics careers remain the same – just under a new name.

If you are having trouble viewing this article, please report it here. 

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!

 

Share this post