Earn a 50% discount on the DP-600 certification exam by completing the Fabric 30 Days to Learn It challenge.
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
periods | list |
servicesids | list |
sli | list |
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 id | sli list | sli list | sli list | periods list from | periods list to |
x | x | x | x | x | x |
x | x | x | x | x | x |
x | x | x | x | x | x |
Unfortunately merging won't work because non of list has coresponding values that i can combine.
Is there a way to connect as shown?
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])
Imke Feldmann (The BIccountant)
If you liked my solution, please give it a thumbs up. And if I did answer your question, please mark this post as a solution. Thanks!
How to integrate M-code into your solution -- How to get your questions answered quickly -- How to provide sample data -- Check out more PBI- learning resources here -- Performance Tipps for M-queries