From the course: Power BI Data Methods (2019)

Unlock the full course today

Join today to access over 22,600 courses taught by industry experts or purchase this course individually.

Combining list objects

Combining list objects

From the course: Power BI Data Methods (2019)

Start my 1-month free trial

Combining list objects

“

- [Instructor] In the NOAA station list Power BI file, let's go back to our original NOAA API connection which extracted API data originally as a list object. The NOAA rest API query we set up returned the data in a JSON format as a list object, which had API query limitations of 1000 records and one year of data. So now what if we put several API queries into one Power BI query and join together the list objects? To do this, let's first duplicate the NOAA API connection. Let's duplicate this again, and I'm going to rename this NOAA API 2018 and the next one, NOAA API 2019. So then I'm going to remove all the steps after the navigation. So convert it to table, I right click and say delete until the end, confirm, and I do the same for the 2019 data. Right click, delete until the end. We see now that both the NOAA API connections for 2018 and 2019 are list objects. So to create a combined query, let's…

Contents