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.

Introducing list and record objects

Introducing list and record objects

From the course: Power BI Data Methods (2019)

Start my 1-month free trial

Introducing list and record objects

“

- [Narrator] If we think of Table objects as objects with rows and columns we can visualize List objects as a single column in a table. Lists do not have a data type nor do they have an explicit column name except the name of the List. If we visualize Lists as columns in a table then Record objects are its' row counterpart. Like Table objects we can drill into and expand List and Record objects in queries. In the Power BI file NOAA station list let's select the NOAA API connection. Remember that the NOAA API connection return results for the API query in a List object. We know that because we see here in this little table we have a List hyperlink that we can click on. To drill down into it we simply click on the List object. We can also tell this is a List object because we see the List icon next to the query name. If we click on one of these Record hyperlinks let's see where it takes us. We drill into…

Contents