Azure Stream Analytics
An Azure real-time analytics service designed for mission-critical workloads.
352 questions
1 answer
One of the answers was accepted by the question author.
Bulk Inserts in Stream Analytic Jobs
Hi Microsoft Team, I have a stream analytics job which is using an event hub as an input and dedicated SQL pool (previously SQL DW) as an output. In the query activity of this dedicated SQL pool, I Can see multiple queries are running which is suing bulk…
![](data:image/svg+xml, %3Csvg xmlns='http://www.w3.org/2000/svg' height='64' class='font-weight-bold' style='font: 600 30.11764705882353px "SegoeUI", Arial' width='64'%3E%3Ccircle fill='hsl(134.4, 93%, 23%)' cx='32' cy='32' r='32' /%3E%3Ctext x='50%25' y='55%25' dominant-baseline='middle' text-anchor='middle' fill='%23FFF' %3ERB%3C/text%3E%3C/svg%3E)
1 answer
Code error in "Return the last event in a window" example
In the example given at https://learn.microsoft.com/en-us/azure/stream-analytics/stream-analytics-stream-analytics-query-patterns#return-the-last-event-in-a-window it seems to me that the JOIN condition: ON DATEDIFF(minute, Input.Time,…
asked 2024-08-31T13:00:34.9166667+00:00
David M. Rosenblum
5
Reputation points
commented 2024-09-14T17:26:12.2533333+00:00
![](data:image/svg+xml, %3Csvg xmlns='http://www.w3.org/2000/svg' height='64' class='font-weight-bold' style='font: 600 30.11764705882353px "SegoeUI", Arial' width='64'%3E%3Ccircle fill='hsl(227.2, 46%, 32%)' cx='32' cy='32' r='32' /%3E%3Ctext x='50%25' y='55%25' dominant-baseline='middle' text-anchor='middle' fill='%23FFF' %3ENN%3C/text%3E%3C/svg%3E)
NIKHILA NETHIKUNTA
1,920
Reputation points Microsoft Vendor
4 answers
Send data to disable public access Azure SQL Database
Hi What i want to accomplish: Send data through azure with a refresh rate of 2 seconds too a power bi report. Java script sending on prem data via event hubs using stream analytics collected in an azure sql database in an azure sql server, all with…
asked 2024-09-03T05:47:24.46+00:00
![](data:image/svg+xml, %3Csvg xmlns='http://www.w3.org/2000/svg' height='64' class='font-weight-bold' style='font: 600 30.11764705882353px "SegoeUI", Arial' width='64'%3E%3Ccircle fill='hsl(115.19999999999999, 18%, 21%)' cx='32' cy='32' r='32' /%3E%3Ctext x='50%25' y='55%25' dominant-baseline='middle' text-anchor='middle' fill='%23FFF' %3EPC%3C/text%3E%3C/svg%3E)
Petter Cavallin
0
Reputation points
answered 2024-09-13T09:05:47.2933333+00:00
Petter Cavallin
0
Reputation points
1 answer
Send an alert email upon a new event in the Azure Auth Methods | Registration and Reset log
Hi folks, I'd like to send an email to my admin team when a user in my org adds a new authentication method. These events appear in the Azure portal in: Azure Active Directory > Security > Authentication Methods > Registration & reset…
asked 2023-08-14T21:58:52.21+00:00
![](data:image/svg+xml, %3Csvg xmlns='http://www.w3.org/2000/svg' height='64' class='font-weight-bold' style='font: 600 30.11764705882353px "SegoeUI", Arial' width='64'%3E%3Ccircle fill='hsl(176, 25%, 27%)' cx='32' cy='32' r='32' /%3E%3Ctext x='50%25' y='55%25' dominant-baseline='middle' text-anchor='middle' fill='%23FFF' %3EIC%3C/text%3E%3C/svg%3E)
Ian Campbell
0
Reputation points
commented 2024-09-12T15:35:53.8+00:00
![](data:image/svg+xml, %3Csvg xmlns='http://www.w3.org/2000/svg' height='64' class='font-weight-bold' style='font: 600 30.11764705882353px "SegoeUI", Arial' width='64'%3E%3Ccircle fill='hsl(179.20000000000002, 45%, 27%)' cx='32' cy='32' r='32' /%3E%3Ctext x='50%25' y='55%25' dominant-baseline='middle' text-anchor='middle' fill='%23FFF' %3EJM%3C/text%3E%3C/svg%3E)
Jean-Marc Bonenfant
0
Reputation points
2 answers
Always got same 'OutputDataConversionError.TypeConversionError' , even I remove the datetime column in output in the Synapse DW sql pool, and got same error after delete and recreated stream analystic.
Always got same 'OutputDataConversionError.TypeConversionError' , even I remove the datetime column in output in Synapse DW sql pool, and got same error after delete and recreated stream analystic. Stream Input is event hub, get dignostic log from azure…
asked 2021-11-12T10:31:09.177+00:00
![](data:image/svg+xml, %3Csvg xmlns='http://www.w3.org/2000/svg' height='64' class='font-weight-bold' style='font: 600 30.11764705882353px "SegoeUI", Arial' width='64'%3E%3Ccircle fill='hsl(137.6, 52%, 23%)' cx='32' cy='32' r='32' /%3E%3Ctext x='50%25' y='55%25' dominant-baseline='middle' text-anchor='middle' fill='%23FFF' %3EW%3C/text%3E%3C/svg%3E)
woodymoo
261
Reputation points
commented 2024-09-03T13:54:27.8766667+00:00
![](data:image/svg+xml, %3Csvg xmlns='http://www.w3.org/2000/svg' height='64' class='font-weight-bold' style='font: 600 30.11764705882353px "SegoeUI", Arial' width='64'%3E%3Ccircle fill='hsl(300.8, 25%, 39%)' cx='32' cy='32' r='32' /%3E%3Ctext x='50%25' y='55%25' dominant-baseline='middle' text-anchor='middle' fill='%23FFF' %3EFR%3C/text%3E%3C/svg%3E)
Frank Rasche
0
Reputation points
3 answers
One of the answers was accepted by the question author.
'Microsoft.Streaming.Adapters.Exceptions.EventHubAdapterException' thrown when fetching AVRO events from eventhub
We have setup a client in our app that is pushing AVRO encoded events to Azure Eventhub. We are using Schema Registry to encode the events. To use the events in power BI we would like to process incoming events into JSON format and save into blob…
asked 2024-08-30T10:38:20.8766667+00:00
![](data:image/svg+xml, %3Csvg xmlns='http://www.w3.org/2000/svg' height='64' class='font-weight-bold' style='font: 600 30.11764705882353px "SegoeUI", Arial' width='64'%3E%3Ccircle fill='hsl(108.80000000000001, 79%, 20%)' cx='32' cy='32' r='32' /%3E%3Ctext x='50%25' y='55%25' dominant-baseline='middle' text-anchor='middle' fill='%23FFF' %3ER%3C/text%3E%3C/svg%3E)
ronnyBravo
20
Reputation points
accepted 2024-09-03T06:12:48.14+00:00
ronnyBravo
20
Reputation points
1 answer
What roles do I need to assign to a user to allow him configure my Stream Analytics Job?
I want to allow Azure user to modify Stream Analytics Jobs - define input, set queries etc. I need to do so without giving them full control over the associated resource group. Is there a pre-build role for this in Azure? Or do I need to create a custom…
asked 2024-08-29T07:53:10.2+00:00
![](data:image/svg+xml, %3Csvg xmlns='http://www.w3.org/2000/svg' height='64' class='font-weight-bold' style='font: 600 30.11764705882353px "SegoeUI", Arial' width='64'%3E%3Ccircle fill='hsl(105.60000000000001, 5%, 20%)' cx='32' cy='32' r='32' /%3E%3Ctext x='50%25' y='55%25' dominant-baseline='middle' text-anchor='middle' fill='%23FFF' %3EMF%3C/text%3E%3C/svg%3E)
Majda, Filip
0
Reputation points
commented 2024-09-02T16:25:53.9966667+00:00
![](data:image/svg+xml, %3Csvg xmlns='http://www.w3.org/2000/svg' height='64' class='font-weight-bold' style='font: 600 30.11764705882353px "SegoeUI", Arial' width='64'%3E%3Ccircle fill='hsl(288, 61%, 37%)' cx='32' cy='32' r='32' /%3E%3Ctext x='50%25' y='55%25' dominant-baseline='middle' text-anchor='middle' fill='%23FFF' %3EP%3C/text%3E%3C/svg%3E)
phemanth
10,250
Reputation points Microsoft Vendor
1 answer
Can Rest Get API be used in Azure Stream Analytics Job ?
Hello, I want to know the usage of REST API in Azure Stream Analytics Job. Maybe, the operation is such as below. Call REST Get API Process REST Get API response. Thanks
asked 2024-08-21T10:12:19.5333333+00:00
![](data:image/svg+xml, %3Csvg xmlns='http://www.w3.org/2000/svg' height='64' class='font-weight-bold' style='font: 600 30.11764705882353px "SegoeUI", Arial' width='64'%3E%3Ccircle fill='hsl(313.6, 31%, 40%)' cx='32' cy='32' r='32' /%3E%3Ctext x='50%25' y='55%25' dominant-baseline='middle' text-anchor='middle' fill='%23FFF' %3EA%3C/text%3E%3C/svg%3E)
시남 우
0
Reputation points
commented 2024-08-28T11:05:48.5366667+00:00
PRADEEPCHEEKATLA-MSFT
88,876
Reputation points Microsoft Employee
1 answer
One of the answers was accepted by the question author.
Azure Event Hubs Authentication Issue with Status Code 401 for Specific Customer Credentials
I am reaching out regarding an issue encountered with Azure Event Hubs authentication for one of our customers. Despite successfully authenticating for most users, we are facing a peculiar problem with a specific customer's credentials, resulting in a…
asked 2024-08-19T11:10:19.6166667+00:00
![](data:image/svg+xml, %3Csvg xmlns='http://www.w3.org/2000/svg' height='64' class='font-weight-bold' style='font: 600 30.11764705882353px "SegoeUI", Arial' width='64'%3E%3Ccircle fill='hsl(291.2, 75%, 38%)' cx='32' cy='32' r='32' /%3E%3Ctext x='50%25' y='55%25' dominant-baseline='middle' text-anchor='middle' fill='%23FFF' %3ESM%3C/text%3E%3C/svg%3E)
Sanjay M Santhosh
20
Reputation points
accepted 2024-08-27T08:50:04.1+00:00
Sanjay M Santhosh
20
Reputation points
2 answers
One of the answers was accepted by the question author.
PartitionKey in Stream Analytics and Event Hubs
Hello, I'm trying to learn more about event hub partitions. I'm running a simple .Net program to send 20 events to an Event Hub with 3 partitions. I then query the events with the input preview in stream analytics. The simple .Net program is…
asked 2024-07-29T01:01:07.6533333+00:00
![](data:image/svg+xml, %3Csvg xmlns='http://www.w3.org/2000/svg' height='64' class='font-weight-bold' style='font: 600 30.11764705882353px "SegoeUI", Arial' width='64'%3E%3Ccircle fill='hsl(25.6, 61%, 12%)' cx='32' cy='32' r='32' /%3E%3Ctext x='50%25' y='55%25' dominant-baseline='middle' text-anchor='middle' fill='%23FFF' %3EKG%3C/text%3E%3C/svg%3E)
Karl Gardner
165
Reputation points
accepted 2024-08-22T13:51:54.9666667+00:00
Karl Gardner
165
Reputation points
1 answer
One of the answers was accepted by the question author.
How can I stop an Azure Stream Analytics job if it shows an internal server error when I try to stop it?
Error Message: "Failed to stop Stream Analytics job 'transport-stream-analytics'. The service returned an internal server error. Please try again. [SessionID: 34fe3fab609d4862a51836c9c777bd52]" Attached is a screenshot, I have been trying to…
asked 2024-07-29T22:49:40.2733333+00:00
![](data:image/svg+xml, %3Csvg xmlns='http://www.w3.org/2000/svg' height='64' class='font-weight-bold' style='font: 600 30.11764705882353px "SegoeUI", Arial' width='64'%3E%3Ccircle fill='hsl(172.8, 9%, 26%)' cx='32' cy='32' r='32' /%3E%3Ctext x='50%25' y='55%25' dominant-baseline='middle' text-anchor='middle' fill='%23FFF' %3EDS%3C/text%3E%3C/svg%3E)
Dwij Siyal
20
Reputation points
accepted 2024-07-29T23:05:20.54+00:00
Dwij Siyal
20
Reputation points
1 answer
Job doesn't start (Used output doesn't exist)
I created a simple job to stream data from Event Hub to PowerBi (Pro license). Data preview shows the events. Testing the output connection to PowerBi is successfull. The system assigned managed identity has a contributor role in the PowerBI…
asked 2024-07-16T06:42:50.9233333+00:00
![](data:image/svg+xml, %3Csvg xmlns='http://www.w3.org/2000/svg' height='64' class='font-weight-bold' style='font: 600 30.11764705882353px "SegoeUI", Arial' width='64'%3E%3Ccircle fill='hsl(214.4, 83%, 30%)' cx='32' cy='32' r='32' /%3E%3Ctext x='50%25' y='55%25' dominant-baseline='middle' text-anchor='middle' fill='%23FFF' %3EVK%3C/text%3E%3C/svg%3E)
Verschaetse Kristof
25
Reputation points
commented 2024-07-22T05:08:43.66+00:00
PRADEEPCHEEKATLA-MSFT
88,876
Reputation points Microsoft Employee
1 answer
One of the answers was accepted by the question author.
Watermark Delay Issues + Streaming Ingestion
Hello, I'm using the azure stream analytics to filter the devices in the event hub and output them in different tables. The issue I'm having is that it's not streaming the data on dashboards that it's getting. For example, it should show (stream) new…
asked 2024-06-26T21:19:25.6033333+00:00
![](data:image/svg+xml, %3Csvg xmlns='http://www.w3.org/2000/svg' height='64' class='font-weight-bold' style='font: 600 30.11764705882353px "SegoeUI", Arial' width='64'%3E%3Ccircle fill='hsl(35.2, 89%, 13%)' cx='32' cy='32' r='32' /%3E%3Ctext x='50%25' y='55%25' dominant-baseline='middle' text-anchor='middle' fill='%23FFF' %3ENS%3C/text%3E%3C/svg%3E)
Nathan Sommer
40
Reputation points
commented 2024-07-05T13:18:43.4366667+00:00
Nathan Sommer
40
Reputation points
0 answers
Cannot select other SU value for minimum/maximum other than the defult in Stream Anaylitcs jobs autoscale
We have an Azure Stream Analytics job where we should set up autoscale as the input events have a peak within a day regularly and rest of day would need less streaming units with lower workload. When set up a rule in the custom scale, the only selectable…
asked 2024-07-02T12:42:43.88+00:00
Barnabas Nagy
0
Reputation points
edited a comment 2024-07-04T15:14:16.8066667+00:00
Sander van de Velde | MVP
32,086
Reputation points MVP
0 answers
Custom power bi chart is not refreshing to visualize a streaming data, i have to refresh it manually to see the changes
I developed custom power bi chart & created an event hub data streaming but it is not refreshing to visualize a streaming data automatically, i have to refresh it manually to see the changes
asked 2024-06-21T14:23:28.84+00:00
![](data:image/svg+xml, %3Csvg xmlns='http://www.w3.org/2000/svg' height='64' class='font-weight-bold' style='font: 600 30.11764705882353px "SegoeUI", Arial' width='64'%3E%3Ccircle fill='hsl(12.8, 81%, 11%)' cx='32' cy='32' r='32' /%3E%3Ctext x='50%25' y='55%25' dominant-baseline='middle' text-anchor='middle' fill='%23FFF' %3EK%3C/text%3E%3C/svg%3E)
Kelele
0
Reputation points
commented 2024-06-24T18:45:32.5833333+00:00
![](data:image/svg+xml, %3Csvg xmlns='http://www.w3.org/2000/svg' height='64' class='font-weight-bold' style='font: 600 30.11764705882353px "SegoeUI", Arial' width='64'%3E%3Ccircle fill='hsl(86.4, 36%, 18%)' cx='32' cy='32' r='32' /%3E%3Ctext x='50%25' y='55%25' dominant-baseline='middle' text-anchor='middle' fill='%23FFF' %3EBM%3C/text%3E%3C/svg%3E)
Bhargava-MSFT
30,891
Reputation points Microsoft Employee
3 answers
How can I get a report of who created resources in Azure Analytics?
Hello, I'm trying to get reports of who creates resources in Azure, for example, I have analytic workspaces created but would like to see who created?
asked 2022-03-04T14:40:28.227+00:00
![](data:image/svg+xml, %3Csvg xmlns='http://www.w3.org/2000/svg' height='64' class='font-weight-bold' style='font: 600 30.11764705882353px "SegoeUI", Arial' width='64'%3E%3Ccircle fill='hsl(192, 34%, 28%)' cx='32' cy='32' r='32' /%3E%3Ctext x='50%25' y='55%25' dominant-baseline='middle' text-anchor='middle' fill='%23FFF' %3ELP%3C/text%3E%3C/svg%3E)
Lou Pereira
16
Reputation points
commented 2024-06-21T05:59:07.3+00:00
Sander van de Velde | MVP
32,086
Reputation points MVP
1 answer
Azure stream analytics streaming job failed
Hi everyone, My ASA failed in the middle of the night with the following error: The input and output connectors also did not work the following day. Without doing anything, the connections re-established themselves after a day and I can start the ASA…
asked 2024-06-14T09:28:24.2933333+00:00
![](data:image/svg+xml, %3Csvg xmlns='http://www.w3.org/2000/svg' height='64' class='font-weight-bold' style='font: 600 30.11764705882353px "SegoeUI", Arial' width='64'%3E%3Ccircle fill='hsl(233.6, 35%, 32%)' cx='32' cy='32' r='32' /%3E%3Ctext x='50%25' y='55%25' dominant-baseline='middle' text-anchor='middle' fill='%23FFF' %3ETV%3C/text%3E%3C/svg%3E)
Tiemen Vanderstraeten
0
Reputation points
commented 2024-06-19T04:23:37.72+00:00
PRADEEPCHEEKATLA-MSFT
88,876
Reputation points Microsoft Employee
2 answers
One of the answers was accepted by the question author.
The WHERE clause in Azure Stream Analytics is unable to perform conditional filtering
My metadata is in JSON format, and I'm attempting to utilize the WHERE clause to filter out data where the property name is 'type', but the filter condition is not working effectively. Could you advise on how to achieve this? Looking forward to your…
asked 2024-06-13T06:20:28.4866667+00:00
![](data:image/svg+xml, %3Csvg xmlns='http://www.w3.org/2000/svg' height='64' class='font-weight-bold' style='font: 600 30.11764705882353px "SegoeUI", Arial' width='64'%3E%3Ccircle fill='hsl(172.8, 95%, 26%)' cx='32' cy='32' r='32' /%3E%3Ctext x='50%25' y='55%25' dominant-baseline='middle' text-anchor='middle' fill='%23FFF' %3EKJ%3C/text%3E%3C/svg%3E)
kunming jian
60
Reputation points
edited a comment 2024-06-18T06:26:35.5766667+00:00
Sander van de Velde | MVP
32,086
Reputation points MVP
0 answers
Stream Analytics does not refresh the input reference blob data when it is updated on the blob storage account
Hi Colleagues; I'm dealing with a problem with Stream Analytics jobs and their corresponding input reference blob data. Basically Stream Analytics is not refreshing the input reference snapshot when a new blob file has been created within the storage…
asked 2024-06-12T13:59:16.8033333+00:00
![](data:image/svg+xml, %3Csvg xmlns='http://www.w3.org/2000/svg' height='64' class='font-weight-bold' style='font: 600 30.11764705882353px "SegoeUI", Arial' width='64'%3E%3Ccircle fill='hsl(268.8, 43%, 36%)' cx='32' cy='32' r='32' /%3E%3Ctext x='50%25' y='55%25' dominant-baseline='middle' text-anchor='middle' fill='%23FFF' %3EZ%3C/text%3E%3C/svg%3E)
zarcap
0
Reputation points
commented 2024-06-18T05:47:23.18+00:00
PRADEEPCHEEKATLA-MSFT
88,876
Reputation points Microsoft Employee
1 answer
How to fix this while integrating Machine Learning UDF function to Azure Stream Analytics
Hi, I am trying to integrate my ML endpoint with Azure Stream Analytics, but failing to do so as I cannot save the below details: Here is my scoring script for the endpoint: import os import logging import json import joblib from azureml.core.model…
asked 2024-06-04T15:28:29.2+00:00
![](data:image/svg+xml, %3Csvg xmlns='http://www.w3.org/2000/svg' height='64' class='font-weight-bold' style='font: 600 30.11764705882353px "SegoeUI", Arial' width='64'%3E%3Ccircle fill='hsl(185.6, 30%, 27%)' cx='32' cy='32' r='32' /%3E%3Ctext x='50%25' y='55%25' dominant-baseline='middle' text-anchor='middle' fill='%23FFF' %3EPJ%3C/text%3E%3C/svg%3E)
Pradyumn Joshi
40
Reputation points
commented 2024-06-11T07:03:29.2833333+00:00
Sander van de Velde | MVP
32,086
Reputation points MVP