Azure Stream Analytics
An Azure real-time analytics service designed for mission-critical workloads.
333 questions
1 answer
Azure Stream Analytics reference data input suddenly getting truncated to first 50 records after upgrade to V2 plan
An existing Stream Analytics job which has not been changes for a couple of years and working happily It supports a few hundred IoT devices "in the wild" As part of the job it relies on several (4x) reference data inputs All inputs are…
asked 2023-07-04T10:09:10.76+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, 72%, 39%)' cx='32' cy='32' r='32' /%3E%3Ctext x='50%25' y='55%25' dominant-baseline='middle' text-anchor='middle' fill='%23FFF' %3E7%3C/text%3E%3C/svg%3E)
79848876
11
Reputation points
commented 2023-07-31T21:30:30.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(54.400000000000006, 38%, 15%)' cx='32' cy='32' r='32' /%3E%3Ctext x='50%25' y='55%25' dominant-baseline='middle' text-anchor='middle' fill='%23FFF' %3EQ%3C/text%3E%3C/svg%3E)
QuantumCache
20,031
Reputation points
1 answer
One of the answers was accepted by the question author.
Struggling with Event Hub Errors: Unable to Trigger Functions After Changing Partition Count
I have built a system where I send messages from devices to IoT Hub, pass them through Stream Analytics, and trigger Functions from Event Hub. I conducted a series of tests at this point and confirmed that Functions were triggered successfully. Later, I…
asked 2023-07-24T10:03:34.3733333+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, 91%, 30%)' cx='32' cy='32' r='32' /%3E%3Ctext x='50%25' y='55%25' dominant-baseline='middle' text-anchor='middle' fill='%23FFF' %3EK3%3C/text%3E%3C/svg%3E)
KURAMOTOAHUJATAIRA-3118
250
Reputation points
commented 2023-07-28T01:34:07.0666667+00:00
KURAMOTOAHUJATAIRA-3118
250
Reputation points
1 answer
Azure Event Hub receiving JSON with extraneous outer array bracket into Stream Analytics
As you can see below my events are being received with an outer array bracket, however they only ever contain 1 actual record (this is desired). I understand that this is probably how the source data comes in, and if were receiving as an actual JSON…
asked 2023-07-25T16:46:20.2966667+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(217.60000000000002, 16%, 31%)' cx='32' cy='32' r='32' /%3E%3Ctext x='50%25' y='55%25' dominant-baseline='middle' text-anchor='middle' fill='%23FFF' %3ENW%3C/text%3E%3C/svg%3E)
Nathaniel Wolf
0
Reputation points
commented 2023-07-26T06:00:45.1566667+00:00
Wilko van de Velde
2,226
Reputation points
1 answer
One of the answers was accepted by the question author.
Issue with Verifying Execution Count of Functions in Azure Functions
I'm experiencing a problem with verifying the execution count of a function in Azure Functions. I have configured the function to be triggered by data input to Stream Analytics. The number of data inputs and outputs to Stream Analytics is 594, as…
asked 2023-06-22T01:01:58.8733333+00:00
KURAMOTOAHUJATAIRA-3118
250
Reputation points
accepted 2023-07-24T02:07:32.58+00:00
KURAMOTOAHUJATAIRA-3118
250
Reputation points
1 answer
Azure Video Analyzer
Hello Microsoft Community, I've been looking at an outdated use case that leverages Azure Video Analyzer Edge. Since this service is retired and no longer in use, does anyone have an alternative solution/service that will allow me to leverage the same…
![](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(54.400000000000006, 68%, 15%)' cx='32' cy='32' r='32' /%3E%3Ctext x='50%25' y='55%25' dominant-baseline='middle' text-anchor='middle' fill='%23FFF' %3EJV%3C/text%3E%3C/svg%3E)
1 answer
Azure Stream Analytics on Edge output to blob on the Edge
I'm trying to configure Azure Stream Analytics(ASA) on Edge output to blob in one the same edge device. Is it supported? When ASA is configured to output to EdgeHub it forks fine. Likewise, the blob storage module is working fine when I'm saving it from…
asked 2023-06-28T12:43:27.5066667+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(262.40000000000003, 82%, 35%)' cx='32' cy='32' r='32' /%3E%3Ctext x='50%25' y='55%25' dominant-baseline='middle' text-anchor='middle' fill='%23FFF' %3EGM%3C/text%3E%3C/svg%3E)
Grzegorz Mroz
0
Reputation points
commented 2023-07-05T21:04:24.71+00:00
LeelaRajeshSayana-MSFT
13,621
Reputation points
1 answer
One of the answers was accepted by the question author.
Error creating a Stream Analytics job into IoT edge
Good evening, First of all thank you for your support. I'm tying to create a Stream Analytics Job (selected Hosting environment: Edge) through the azure portal but it doesn work. When I press on the "Create" button it goes to the overview…
asked 2023-06-22T15:58:02.7766667+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, 84%, 18%)' cx='32' cy='32' r='32' /%3E%3Ctext x='50%25' y='55%25' dominant-baseline='middle' text-anchor='middle' fill='%23FFF' %3EJA%3C/text%3E%3C/svg%3E)
julio antonio carbonero reina
20
Reputation points
commented 2023-06-30T17:24:25.7833333+00:00
julio antonio carbonero reina
20
Reputation points
1 answer
Working with Bits in Stream Analytics
I'm hoping someone can help. I have a Byte coming into Azure Stream Analytics. This has a label "Status1" and a value 128 at present, this is RAW data coming from Azure IOT Hub. I need to to split each individual bit out of this Byte and store…
asked 2023-06-26T18:53:46.3566667+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(0, 25%, 10%)' cx='32' cy='32' r='32' /%3E%3Ctext x='50%25' y='55%25' dominant-baseline='middle' text-anchor='middle' fill='%23FFF' %3EHS%3C/text%3E%3C/svg%3E)
Howes, Stephen
0
Reputation points
answered 2023-06-27T15:47:40.43+00:00
QuantumCache
20,031
Reputation points
1 answer
Azure streaming analytics not outputting to PowerBI
Hey there, Im a student using Azure for a project Im working on. I am having an issue with the output on my Stream Analytics Job. When trying to change the output from "Provide Power BI settings manually" to "Select Power BI from your…
asked 2023-06-20T12:26:21.68+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(140.8, 98%, 23%)' cx='32' cy='32' r='32' /%3E%3Ctext x='50%25' y='55%25' dominant-baseline='middle' text-anchor='middle' fill='%23FFF' %3EMM%3C/text%3E%3C/svg%3E)
Meer, Miguel van der
5
Reputation points
commented 2023-06-26T06:28:08.32+00:00
PRADEEPCHEEKATLA-MSFT
78,576
Reputation points Microsoft Employee
1 answer
How to cast DATETIME from UTC to GMT Standard Time on Azure Steam Analytics query?
I'm trying to use the below function in an Azure Stream Analytics query to convert DATETIME values from UTC to the London timezone. However, this doesn't work on Azure Stream Analytics, however, it does on Azure dedicated SQL pools. Works on Synapse…
asked 2023-05-15T10:20:26.7566667+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(278.4, 53%, 36%)' 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)
Vivek Komarla Bhaskar
911
Reputation points
commented 2023-06-26T04:43:51.7566667+00:00
PRADEEPCHEEKATLA-MSFT
78,576
Reputation points Microsoft Employee
0 answers
Connecting Streamanalytics to IoTHub
Hi all, We're facing the issue that since 2 days ag We're getting the problem that "Stream Analytics job has validation errors: Unable to connect to IoT Hub using connection string. Please make sure you have configured the IoT Hub input correctly. …
asked 2023-06-19T14:55:11.37+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(0, 81%, 10%)' cx='32' cy='32' r='32' /%3E%3Ctext x='50%25' y='55%25' dominant-baseline='middle' text-anchor='middle' fill='%23FFF' %3EGQ%3C/text%3E%3C/svg%3E)
Georgios - QU
0
Reputation points
edited a comment 2023-06-20T11:39:45.5233333+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, 74%, 30%)' cx='32' cy='32' r='32' /%3E%3Ctext x='50%25' y='55%25' dominant-baseline='middle' text-anchor='middle' fill='%23FFF' %3EAM%3C/text%3E%3C/svg%3E)
AshokPeddakotla-MSFT
27,976
Reputation points
asked 2023-06-11T02:59:15.39+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, 89%, 39%)' cx='32' cy='32' r='32' /%3E%3Ctext x='50%25' y='55%25' dominant-baseline='middle' text-anchor='middle' fill='%23FFF' %3EAH%3C/text%3E%3C/svg%3E)
alvaro herraez martinez
0
Reputation points
edited an answer 2023-06-13T21:23:00.92+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)
BhargavaGunnam-MSFT
26,496
Reputation points Microsoft Employee
1 answer
How to setup diagnostic settings (continuous export) for PME based App Insights to Event Hub (in corp tenant)
I have workspace-based Application Insights instance in pme tenant and I want to setup continuous export of logs to Kusto (in corp tenant). How to achieve this? We had powershell continuous export for classic version on App Inights but new version…
asked 2023-06-02T22:09:09.35+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(44.800000000000004, 60%, 14%)' cx='32' cy='32' r='32' /%3E%3Ctext x='50%25' y='55%25' dominant-baseline='middle' text-anchor='middle' fill='%23FFF' %3ERM%3C/text%3E%3C/svg%3E)
Roshani Mangalore
0
Reputation points Microsoft Employee
commented 2023-06-06T22:32:39.8666667+00:00
BhargavaGunnam-MSFT
26,496
Reputation points Microsoft Employee
1 answer
Stream Analytics + ADLS output: Please ensure that blob file is not being modified by another process at the same time. Error: InvalidBlockList
Suddenly, the Stream Analytics Job stopped writing to ADLS Storage I have an Event Hub Namespace which connects to a Stream Analytics Job, which finally writes to an ADLS Storage. Then, the data is queried in SQL Synapse (Serverless) Everything was fine…
asked 2023-05-28T19:59:06.5933333+00:00
Jona
375
Reputation points
commented 2023-06-05T04:39:46.45+00:00
PRADEEPCHEEKATLA-MSFT
78,576
Reputation points Microsoft Employee
1 answer
Streaming analytics job - Workspace outside my organization
Hello! I have a stream analytic job created by publishing data into a Power BI Workspace in my organization. It works perfectly. Now, I need to include a second Output for a Workspace that is outside my organization. To do this, I manually include the…
asked 2023-06-01T09:17:23.2666667+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(73.60000000000001, 93%, 17%)' cx='32' cy='32' r='32' /%3E%3Ctext x='50%25' y='55%25' dominant-baseline='middle' text-anchor='middle' fill='%23FFF' %3EPZ%3C/text%3E%3C/svg%3E)
Pablo Zornoff
0
Reputation points
answered 2023-06-01T17:31:19.7+00:00
QuantumCache
20,031
Reputation points
2 answers
DB2 real time streaming tables data
Hello All: I have a typical requirements where I have to replicate hundreds of SAP tables which is hosted in DB2 database to Azure cloud. Azure Data Factory is out of equation and SAP SLT is not an option and it has its own challenges from CDC…
asked 2022-04-16T23:42:26.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(150.4, 98%, 24%)' cx='32' cy='32' r='32' /%3E%3Ctext x='50%25' y='55%25' dominant-baseline='middle' text-anchor='middle' fill='%23FFF' %3ESS%3C/text%3E%3C/svg%3E)
Sun Shine
296
Reputation points
answered 2023-05-28T13:40:54.35+00:00
Gabriel Castro
0
Reputation points
1 answer
How to configure a SQL database as an output of Stream Analytics
I tried the tutorial of blob storage and I adapt it with sql database but I didn´t get it
asked 2023-05-10T13:29:05.2133333+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(124.80000000000001, 11%, 22%)' cx='32' cy='32' r='32' /%3E%3Ctext x='50%25' y='55%25' dominant-baseline='middle' text-anchor='middle' fill='%23FFF' %3EJF%3C/text%3E%3C/svg%3E)
Javier Familiar Gijon
40
Reputation points
commented 2023-05-15T08:17:39.7433333+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(220.8, 4%, 31%)' 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)
ShaktiSingh-MSFT
13,751
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
11
Reputation points
edited the question 2023-05-15T05:08:41.8633333+00:00
PRADEEPCHEEKATLA-MSFT
78,576
Reputation points Microsoft Employee
1 answer
I never expected that Azure Stream Analytics will keep charging me money
I never expected the Azure Stream Analytics will accurately charge money from me with no alter. Could I ask for refunding for that?
asked 2023-05-08T20:52:41.4066667+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(169.60000000000002, 66%, 26%)' cx='32' cy='32' r='32' /%3E%3Ctext x='50%25' y='55%25' dominant-baseline='middle' text-anchor='middle' fill='%23FFF' %3EPX%3C/text%3E%3C/svg%3E)
PENG XIA
0
Reputation points
commented 2023-05-11T06:28:43.76+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(134.4, 9%, 23%)' cx='32' cy='32' r='32' /%3E%3Ctext x='50%25' y='55%25' dominant-baseline='middle' text-anchor='middle' fill='%23FFF' %3EKM%3C/text%3E%3C/svg%3E)
KranthiPakala-MSFT
46,422
Reputation points Microsoft Employee
1 answer
One of the answers was accepted by the question author.
How to create an output in stream analytics of SQL Database with powershell
I want to know how to create an azure SQL Database and an output SQL Database in Stream Analytics using powershell Thanks
asked 2023-03-01T15:59:29.6933333+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(48, 5%, 14%)' cx='32' cy='32' r='32' /%3E%3Ctext x='50%25' y='55%25' dominant-baseline='middle' text-anchor='middle' fill='%23FFF' %3EJF%3C/text%3E%3C/svg%3E)
Javier Familiar Gijón
20
Reputation points
accepted 2023-05-10T13:25:55.3633333+00:00
Javier Familiar Gijón
20
Reputation points