Forum Discussion
Solved
Parsing JSON data into PowerBI table
Hello PowerBI team/community, I am new to PowerBI and setting up preliminary dashboards for our company. We're building a tech-driven large scale painting company. We use Pipedrive (CRM SaaS) to ...
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 :-)