I’ve imported data from an API using the Power BI web connector. In the Query Editor I see that most of the data in the table consists of regular data types (text, dates, numericals, etc), but a few columns have lists.
In general, would these lists be a part of the table and therefore should be expanded, or would they likely be other tables that have a relationship with this main table?
The reason I ask is because some of these lists add to the rows in this main table and in some cases create duplicate rows. When expanded, they also add to the number of columns.
I don’t have a sample for this and simply need to know how to treat these lists.