Creating a new table with data from multiple data sets

(0) Share

Report

Posted on by Jalberto

Hello everyone,

I have loaded multiple data sets through a web API and I want to convert them into a single table, so I can use them effectively in Power BI. Each row in the following screenshot respesents a different data set.

The structure looks like this:
Each list in the "intervals" column has a set of records.

Each of the above records looks like this inside:

All data is segmented by equal timestamps.
My goal is to create a new table that consists of columns that list the values("V") of each data set in addition to an extra column for the datetime("T_ISO"). Since there are 16 different data sources, this should result in a table with 17 columns.

I've been thinking of iterating through all data sources with something like List.Generate(), but I'm having a hard time grasping how to do that(and looping in general) in power query.

Can you guys give me some general guidance on how to accomplish this?

Thank you.