Forum Discussion
Parsing JSON data into PowerBI table
You didn't post the whole JSON. According to the description, suppose that you have a json file as below,
[ { "project id":"123", "value":"2000", "trans":[ { "date":"2016-07-31T22:00:00.000Z", "startTime":"07:00", "endTime":"16:00", "painters":[ "John", "Pete" ] }, { "date":"2016-08-01T22:00:00.000Z", "startTime":"07:00", "endTime":"16:00", "painters":[ "John", "Pete" ] }, { "date":"2016-08-02T22:00:00.000Z", "startTime":"07:00", "endTime":"16:00", "painters":[ "John", "Pete" ] } ] } ]to get an expected output, you can reference the pbix attached.
To apply the demo to your case, replace the embeded JSON with file.content("yourJSONpath") in advanced editor.
You didn't post the whole JSON. According to the description, suppose that you have a json file as below,
[
{
"project id":"123",
"value":"2000",
"trans":[
{
"date":"2016-07-31T22:00:00.000Z",
"startTime":"07:00",
"endTime":"16:00",
"painters":[
"John",
"Pete"
]
},
{
"date":"2016-08-01T22:00:00.000Z",
"startTime":"07:00",
"endTime":"16:00",
"painters":[
"John",
"Pete"
]
},
{
"date":"2016-08-02T22:00:00.000Z",
"startTime":"07:00",
"endTime":"16:00",
"painters":[
"John",
"Pete"
]
}
]
}
]
to get an expected output, you can reference the pbix attached.
To apply the demo to your case, replace the embeded JSON with file.content("yourJSONpath") in advanced editor.
Thanks guys - will check it out today and let you know if it works out :-)
Hello, how can i split the result into 3 diferent tables? I need for it, but i don't know the best way for it.
