You’re offline. This is a read only version of the page.
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.
Share
Report
All responses (
Answers (
474
