Forum Discussion

Chetcork's avatar
Chetcork
Frequent Visitor
3 years ago

Combine lists to one table

Hello,

 

I'm working with connecting API to Power BI link to api documentation https://www.zabbix.com/documentation/current/en/manual/api/reference/sla/getsli After running query the result is 3 separate rows "periods", "serviceids","sli"  that looks like this in power bi

periodslist
servicesidslist
slilist

I would like to convert those 3 lists to one table. I cannot share the data with you.

The end result that i would like to achive is one table that will like like the one below

service idsli listsli listsli listperiods list fromperiods list to
xxxxxx
xxxxxx
xxxxxx

 

Unfortunately merging won't work because non of list has coresponding values that i can combine.

Is there a way to connect as shown?

Need Help

1 Reply

  • ImkeF's avatar
    ImkeF
    Community Champion
    3 years ago

    Hi Chetcork ,
    there is a function Table.FromColumns that allows you to do something like that.
    However, I would expect a table with 3 columns from your example, as you have three rows with lists (that should become columns) in them.
    However, you can start with the following:
    Table.FromColumns(TableName[ListColumnName])