Stream Analytics query giving Null while filtering Modbus module payload from azure iotedge
Hi Team, I'm getting invalid syntax error while trying to extract the "Values" Array. I have tried multiple query patterns to list all displayNames and its corresponding Value in columns, please find sample input json below [ { …
I am passing a Stream to the service but never return the text
speech-sdk-log.txt I am trying to convert live stream to text , this works fine with microphone , but when i send the Stram it was not recognized I already try same stremresult file and works fine from file but not for live stream …
How to configure Azure and Entra ID logs into Log Analytics for Kusto Query?
Hi All, I need some help and suggestions to configure Azure and Entra ID logs into Log Analytics for Kusto Query. What are the procedures and what is the cost involved? Thanks.
Azure Function concurrency issues
I have multiple azure functions running at the same time and creating multiple instances of each.The parameters are also passed in parallel that means at one time all the azure function urls will be hit at once.Below is an example of how I am…
ASA run same code with different result?
The following 2 codes get different result: FROM IotBaseInput as event CROSS APPLY GetArrayElements(event.monoEvent) AS arrayElement CROSS APPLY GetRecordProperties(arrayElement.arrayvalue) AS recordProperty Where recordProperty.PropertyName !=…
About Power BI regreshing dataset on scheduled
Hi, I've been looking for an individual plan to be able to publish, share and auto refresh dashboards and datasets. I don't belong to any organization ... ¿are there personal/individual/developer plans? Sorry the wrong tagging, but I needed to ask the…
Finding out viewers of shared videos
We record videos on Teams and share them with our staff. I want to find out the identity of the viewers, not just the number of unique viewers and video views. The videos are recorded by a "user" level user and are part of that user's…
How to fix this error "The streaming job failed: Stream Analytics job is only able to use up to 50 Streaming Units based on the provided query".Please adjust the number of Streaming Units or check the number of input partitions and update your query.
I have been experiencing this when I try to run Azure Stream Analytics v2 with 6 SUs or above .Below 6 SU it works fine. I have a simple query which only has CROSS APPLY and GET ARRAY ELEMENTS in it.I am fetching telemetry data arrays and converting them…
Decimal data type in Azure Stream Analytics
How can be managed a decimal data type with 20 as scale in Azure Stream Analytics without any aproximation?
Using multiple, mixed length Windows in Stream analytics query results in high (100%) SU memory utlization
I want to use Windows to collect both 3-hour and 1 day max, min, average and count of certain device messages arriving to iot hub. If I use both windows, as in code snippet, SU memory usage goes to 100%. If I use only one Window (does not matter which…
Can Azure stream analytics lose data?
~~ I have encountered two instances recently where data was lost in Azure Stream Analytics (ASA). The first instance occurred when I was using ASA to store data in Parquet format, which was sourced from IoT Hub. I had set the minimum batch count to…
Error when sampling data: no data received from 1 partition
Hi, I'm working with ASA and using Blob Container as input. The data is present in the container. However, when I run the query, I get the following error: While sampling data, no data was received from '1' partitions. The path…
Chaining Queries in Stream Analytics
How can I write multiple SQL queries where the output of one query serves as the input to the next query, and this process repeats for several levels? I am working with around 3 or more levels of queries.
ONE QUERY OUTPUT AS INPUT TO ANOTHER QUERY
HI, I want to write three or more queries where-in one query output is served as input two next query and subsequently it should go to some around 3 or more levels.
Stream Analytics - Possible to Change/Convert miliseconds to seconds ?
Hi, i wrote for ASA a query and i am facing with one colum here. But the time output is wrong i think and in my RDL Report Server i am also getting no correct results I need to convert somehow but not sure if this is correct way. SELECT Name as…
Facing error while creating Azure Stream Analytics job service
Hi Team, I am getting error while deploying an Azure Stream Analytics instance from UI. I am not using any ARM template. It says "Your deployment failed" and throws the below error. { "code": "NotFound", …
Azure Stream Analytics output config json as managed identity to service bus queue
Hello I have an ASA job that is using managed identity to send messages to a service bus queue (this is working) however when trying to deploy changes the template that is generated expects parameters for SharedAccessPolicyName, which to my understanding…
Looking for real-time data ingestion pattern with examples
My company is in the process of converting a monolithic application into microservices. We've decided that the data lake will be the Source of Truth. A consulting company got us started, but processing messages to the Silver layer in the data lake is…
How to fix azure.eventhub.exceptions.AuthenticationError: CBS Token authentication failed
I'm attempting to run a sample event generator to familiarize myself with Azure Event Hubs and Azure Stream Analytics. import asyncio from azure.eventhub.aio import EventHubProducerClient from azure.eventhub import EventData import json import…
Stream Analytics Job - no output in SQL
Hello Team, i am facing with Stream Analytics Job with Output for SQL. I wrote a query and the output showing me the results which I expects. But somehow the results is not showing in my SQL table. I am running out of ideas. Not sure why it’s not…