topic PowerBI streaming analytics or Streaming Dataflows from Azure Percept : Query language question in Developer

PowerBI streaming analytics or Streaming Dataflows from Azure Percept : Query language question

Celwood — Sun, 01 Aug 2021 13:58:45 GMT

I have an Azure Percept with data feeding IoT Hub and then through Stream Analytics into PowerBI.

See below screenshot. My issue :
I am trying to parse out the nested JSON array inside the JSON message coming from the Azure Percept.
I am able to see the "new" field in the test results but want to isolate the bbox and label from the JSON array.

SELECT

DATEPART (year, EventProcessedUtcTime) as Year,

DATEPART (day, EventProcessedUtcTime) as day,

DATEPART (month, EventProcessedUtcTime) as month,

event.Neural_Network as new

INTO

pbiwindowingtest

FROM

Perceptinput as event

TIMESTAMP BY EventProcessedUtcTime

Also tried using Streaming Dataflows in Premium Per User Capacity but seeing the data come in as blobs called [object]

Re: PowerBI streaming analytics or Streaming Dataflows from Azure Percept : Query language question

V-lianl-msft — Tue, 03 Aug 2021 08:00:28 GMT

Hi @Celwood ,

The blog once helped me solve similar problems.

Please refer to this blog:

https://www.cloudsma.com/2020/01/extracting-nested-fields-kusto/

Best Regards,
Liang
If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.

Re: PowerBI streaming analytics or Streaming Dataflows from Azure Percept : Query language question

Celwood — Fri, 06 Aug 2021 23:24:21 GMT

@V-lianl-msft Thanks for the link, that led me to search the web some more and I stumbled on https://docs.microsoft.com/en-us/azure/stream-analytics/stream-analytics-parsing-json which I then used to parse everything out with dot notation and GetArray functions. I still can't get the streaming dataflows to parse JSON so I have reposted that question in the PowerBI Desktop community forum.

Re: PowerBI streaming analytics or Streaming Dataflows from Azure Percept : Query language question

MrKrukauskas — Mon, 27 Jun 2022 15:41:02 GMT

Hi @Celwood , may I ask about your first posted screenshot? Where is it from and how to get to the screen?

I'm working with streaming dataflows, but I don't remember coming across that screen view.

Thanks!