330 questions with Azure Stream Analytics tags

Sort by: Updated
1 answer

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 [ { …

Azure IoT Edge
Azure IoT Edge
An Azure service that is used to deploy cloud workloads to run on internet of things (IoT) edge devices via standard containers.
536 questions
Azure IoT Hub
Azure IoT Hub
An Azure service that enables bidirectional communication between internet of things (IoT) devices and applications.
1,117 questions
Azure Stream Analytics
Azure Stream Analytics
An Azure real-time analytics service designed for mission-critical workloads.
330 questions
asked 2024-01-12T08:22:59.1733333+00:00
Novin George Thomas 0 Reputation points
answered 2024-01-12T09:46:15.4133333+00:00
Novin George Thomas 0 Reputation points
1 answer

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 …

Azure AI Speech
Azure AI Speech
An Azure service that integrates speech processing into apps and services.
1,393 questions
Azure Stream Analytics
Azure Stream Analytics
An Azure real-time analytics service designed for mission-critical workloads.
330 questions
Azure IoT SDK
Azure IoT SDK
An Azure software development kit that facilitates building applications that connect to Azure IoT services.
208 questions
C#
C#
An object-oriented and type-safe programming language that has its roots in the C family of languages and includes support for component-oriented programming.
10,251 questions
Azure AI services
Azure AI services
A group of Azure services, SDKs, and APIs designed to make apps more intelligent, engaging, and discoverable.
2,375 questions
asked 2024-01-09T18:58:32.7433333+00:00
Juan Morales Marañon 0 Reputation points Microsoft Employee
answered 2024-01-10T05:53:58.05+00:00
navba-MSFT 17,110 Reputation points Microsoft Employee
2 answers

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.

Microsoft Graph
Microsoft Graph
A Microsoft programmability model that exposes REST APIs and client libraries to access data on Microsoft 365 services.
10,593 questions
Azure Stream Analytics
Azure Stream Analytics
An Azure real-time analytics service designed for mission-critical workloads.
330 questions
Microsoft Intune Security
Microsoft Intune Security
Microsoft Intune: A Microsoft cloud-based management solution that offers mobile device management, mobile application management, and PC management capabilities.Security: The precautions taken to guard against crime, attack, sabotage, espionage, or another threat.
333 questions
Microsoft Entra ID
Microsoft Entra ID
A Microsoft Entra identity service that provides identity management and access control capabilities. Replaces Azure Active Directory.
19,474 questions
asked 2023-12-07T14:30:00.8666667+00:00
EnterpriseArchitect 4,741 Reputation points
commented 2024-01-03T16:01:15.8+00:00
Givary-MSFT 27,966 Reputation points Microsoft Employee
0 answers

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…

Azure SQL Database
Azure Functions
Azure Functions
An Azure service that provides an event-driven serverless compute platform.
4,266 questions
Azure Stream Analytics
Azure Stream Analytics
An Azure real-time analytics service designed for mission-critical workloads.
330 questions
asked 2023-12-22T10:35:13.3066667+00:00
Rafay Khan 20 Reputation points
commented 2024-01-02T11:37:44.65+00:00
Rafay Khan 20 Reputation points
0 answers

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 !=…

Azure Stream Analytics
Azure Stream Analytics
An Azure real-time analytics service designed for mission-critical workloads.
330 questions
asked 2023-12-20T03:39:25.1+00:00
jane 60 Reputation points
commented 2023-12-27T18:11:58.2733333+00:00
BhargavaGunnam-MSFT 26,136 Reputation points Microsoft Employee
1 answer One of the answers was accepted by the question author.

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…

Azure Stream Analytics
Azure Stream Analytics
An Azure real-time analytics service designed for mission-critical workloads.
330 questions
asked 2023-12-18T04:01:05.9233333+00:00
Jona 335 Reputation points
edited the question 2023-12-19T09:19:10.1666667+00:00
PRADEEPCHEEKATLA-MSFT 77,086 Reputation points Microsoft Employee
1 answer

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…

Azure Stream Analytics
Azure Stream Analytics
An Azure real-time analytics service designed for mission-critical workloads.
330 questions
SharePoint
SharePoint
A group of Microsoft Products and technologies used for sharing and managing content, knowledge, and applications.
9,629 questions
asked 2023-12-12T14:42:35.42+00:00
Bill Howard 0 Reputation points
commented 2023-12-18T21:02:47.6+00:00
BhargavaGunnam-MSFT 26,136 Reputation points Microsoft Employee
1 answer One of the answers was accepted by the question author.

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…

Azure Stream Analytics
Azure Stream Analytics
An Azure real-time analytics service designed for mission-critical workloads.
330 questions
asked 2023-11-23T10:54:56.5733333+00:00
Rafay Khan 20 Reputation points
accepted 2023-12-13T14:02:04.1666667+00:00
Rafay Khan 20 Reputation points
1 answer

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?

Azure Stream Analytics
Azure Stream Analytics
An Azure real-time analytics service designed for mission-critical workloads.
330 questions
asked 2023-12-11T14:00:43.32+00:00
Anonymous
answered 2023-12-11T18:31:15.6666667+00:00
KranthiPakala-MSFT 46,422 Reputation points Microsoft Employee
0 answers

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…

Azure Stream Analytics
Azure Stream Analytics
An Azure real-time analytics service designed for mission-critical workloads.
330 questions
asked 2023-11-29T11:07:26.6166667+00:00
Tornikoski, Veli-Matti 0 Reputation points
commented 2023-12-08T10:59:55.67+00:00
Tornikoski, Veli-Matti 0 Reputation points
1 answer

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…

Azure Stream Analytics
Azure Stream Analytics
An Azure real-time analytics service designed for mission-critical workloads.
330 questions
asked 2023-11-20T07:27:16.89+00:00
jane 60 Reputation points
commented 2023-12-01T06:31:41.2+00:00
PRADEEPCHEEKATLA-MSFT 77,086 Reputation points Microsoft Employee
1 answer

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…

Azure Stream Analytics
Azure Stream Analytics
An Azure real-time analytics service designed for mission-critical workloads.
330 questions
asked 2023-11-13T12:59:08.3233333+00:00
Sutheswaran, Suwhathi 70 Reputation points
commented 2023-11-28T01:20:43.7066667+00:00
KranthiPakala-MSFT 46,422 Reputation points Microsoft Employee
1 answer

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.

Azure Stream Analytics
Azure Stream Analytics
An Azure real-time analytics service designed for mission-critical workloads.
330 questions
asked 2023-11-25T05:33:16.8333333+00:00
c.mavi01 0 Reputation points
answered 2023-11-25T13:10:29.3266667+00:00
Sander van de Velde 28,386 Reputation points MVP
1 answer

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.

Azure Stream Analytics
Azure Stream Analytics
An Azure real-time analytics service designed for mission-critical workloads.
330 questions
asked 2023-11-25T05:32:07.5366667+00:00
c.mavi01 0 Reputation points
answered 2023-11-25T13:07:29.99+00:00
Sander van de Velde 28,386 Reputation points MVP
2 answers

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…

Azure Stream Analytics
Azure Stream Analytics
An Azure real-time analytics service designed for mission-critical workloads.
330 questions
asked 2023-11-08T11:25:52.9533333+00:00
Sutheswaran, Suwhathi 70 Reputation points
commented 2023-11-20T08:46:46.2633333+00:00
PRADEEPCHEEKATLA-MSFT 77,086 Reputation points Microsoft Employee
0 answers

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
Azure Stream Analytics
An Azure real-time analytics service designed for mission-critical workloads.
330 questions
asked 2023-11-17T15:41:25.22+00:00
WAQAR MEHDI 5 Reputation points
commented 2023-11-17T17:31:42.76+00:00
Sander van de Velde 28,386 Reputation points MVP
0 answers

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…

Azure Service Bus
Azure Service Bus
An Azure service that provides cloud messaging as a service and hybrid integration.
545 questions
Azure Stream Analytics
Azure Stream Analytics
An Azure real-time analytics service designed for mission-critical workloads.
330 questions
asked 2023-11-15T18:56:35.8133333+00:00
Wilson, Chris 0 Reputation points
commented 2023-11-16T18:02:46.5933333+00:00
QuantumCache 20,031 Reputation points
1 answer One of the answers was accepted by the question author.

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…

Azure Data Lake Storage
Azure Data Lake Storage
An Azure service that provides an enterprise-wide hyper-scale repository for big data analytic workloads and is integrated with Azure Blob Storage.
1,343 questions
Azure Service Bus
Azure Service Bus
An Azure service that provides cloud messaging as a service and hybrid integration.
545 questions
Azure Synapse Analytics
Azure Synapse Analytics
An Azure analytics service that brings together data integration, enterprise data warehousing, and big data analytics. Previously known as Azure SQL Data Warehouse.
4,372 questions
Azure Stream Analytics
Azure Stream Analytics
An Azure real-time analytics service designed for mission-critical workloads.
330 questions
asked 2023-11-02T14:10:45.32+00:00
Jeff Born (J&CLT-ATL) 96 Reputation points
accepted 2023-11-13T17:15:05.34+00:00
Jeff Born (J&CLT-ATL) 96 Reputation points
3 answers One of the answers was accepted by the question author.

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…

Azure Event Hubs
Azure Event Hubs
An Azure real-time data ingestion service.
557 questions
Azure Stream Analytics
Azure Stream Analytics
An Azure real-time analytics service designed for mission-critical workloads.
330 questions
asked 2023-02-26T03:27:04.21+00:00
Bill LaLonde 50 Reputation points
answered 2023-11-09T07:01:27.02+00:00
Mariyam Thomas 20 Reputation points
2 answers One of the answers was accepted by the question author.

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…

Azure Stream Analytics
Azure Stream Analytics
An Azure real-time analytics service designed for mission-critical workloads.
330 questions
SQL Server
SQL Server
A family of Microsoft relational database management and analysis systems for e-commerce, line-of-business, and data warehousing solutions.
12,718 questions
asked 2023-11-01T18:52:40.7266667+00:00
Sutheswaran, Suwhathi 70 Reputation points
commented 2023-11-08T12:03:44.4766667+00:00
Sutheswaran, Suwhathi 70 Reputation points