Easiest ways to get from Dynatrace Timeseries with REST API in json format file to Power BI graphing

Hi runatyr 

According to the guide document, I can get data from json format with Power BI.

But since your code is of format

"HOST-ABCD1234, NETWORK_INTERFACE-ABCD1234": [
        [
          1566323040000,
          263687.34375
        ]

not

HOST-ABCD1234:****,

NETWORK_INTERFACE-ABCD1234: ****

Finally, i get all number values in one column.

A workaround is :

1. add an index from 1, then add a custom column

Custom=Number.Mod([Index],2)

2. select "custom" column, pivot column

3.

fill down for column "1",

fill up for column "2",

then remove the "index" column,

then remove duplicates rows

Finally, change the column name to expected ones.

Best Regards
Maggie

Community Support Team _ Maggie Li
If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.