Nested JSON in streaming datasets

[rodrigolynce]

Is possible to use a nested JSON in streaming datasets?

I didn't see a way to do that in power bi service site.

Example:

[
{
"TeradataTime":"00:00:11",
"SQL_PLAYTime":"00:00:00",
"SQL_SACAMPTime":"00:00:04",
"SASCreateTimeINT":35,
"SASExecTimeINT":1200,
"TeradataSizeDT":"2018-02-22 13:15:12",
"TeradataSize":425000,
"SqlPLAYDT":"2018-02-21 10:41:54",
"SQLPLAYSize":100000,
"SqlSizeDTCamp":"2018-02-21 10:41:59",
"SQLSACAMPSize":102000,
"PlayTotals":14,
"TotalLogPlay":3,
"MediaTempoLog":4,
"RobotJrDT":"00:00:03",
"RobotJrINT":14,
"RobotBIADT":"00:00:06",
"RobotBIAINT":80,
"TeradataTimeINT":75,
"TeradataSizeMAX":460000,
"SQL_PLAYTimeINT":3,
"SQL_SACAMPTimeINT":7,
"getdate":"2018-02-28 08:25:49",
"TelasPlay":{"StartDT":"2018-02-28 08:25:49", "vcLogin":"A0069975", "Tipo":"Close", "vcFullName":"Jonas Correa", "vcDescription":"Close Wizard Briefing", "Duracao": 660}
}
]

[Myriam]

Hi all!

Does anybody know if this is still not possible?

I am streaming data in JSON format via Azure Stream Analytics into a normal Power BI workspace. So I have a Streaming Dataset and can create tiles in a Dashboard or create a report. But in the nested fields I only get the string "Record". How can I expand this in Power BI Service?

Would a Streaming Dataflow help me with this (can't try because I do not have Power BI Premium)?

[v-shex-msft · Accepted solution]

HI @rodrigolynce,

As you said, current streaming dataset api not support nested json format.
I'd like to suggest you submit an idea for this requirement.

Regards,

Xiaoxin Sheng