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…
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…
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…
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
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?
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…
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…
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…
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…
Partition Key in Azure Event Hub and Stream Analytics
Hello, I am reading about Azure Event Hub with the ability to use a partition key to map incoming event data into specific partitions: https://learn.microsoft.com/en-us/azure/event-hubs/event-hubs-scalability#mapping-of-events-to-partitions I am…
Problem with parsing data from a JSON field
I'm trying to process the log files with the following structure per…
How does session window max duration check work in Stream Analytics ?
Hi, I have a question regarding the Session Window function in Stream Analytics. According to documentation I found, "If events keep occurring within the specified timeout, the session window will keep extending until maximum duration is reached.…
Why 'Custom App' option is not shown under 'Add Source' in event stream of Microsoft Fabric.
We are trying to consume messages from Kafka. Created a new event stream in Microsoft Fabric. 'Custom App' option is not shown under 'Add Source' or 'New Source' in event stream of Microsoft Fabric real-time analytics
Error encountered while storing reference data snapshot into the storage account
Error encountered while storing reference data snapshot into the storage account
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. …
Unable to update Cosmos DB documents with Hierarchical partition keys using Azure Stream Analytics job
I have document in Cosmos DB with Hierarchical partition keys. I want to patch certain property value. But while running the job I am getting this error👇 The streaming job failed: Stream Analytics job has validation errors: Error connecting to…
How to ingest CDC data from SQL DATA SYNC to Event hub?
Hi we have a scenario to implement real-time CDC from SQL DATA SYNC to Azure SQL DB. Which tools are good for near real-time processes and prices as well. By using data bricks we can merge stream data into delta lake. But How to ingest real-time…
Azure Stream Analytics Jobs - Alert Creation for "Diagnostic: Diagnostic Error"
I have multiple Azure stream Analytics Jobs (more than 50 Azure Stream Analytics Jobs) in my subscription. One of the requirement we have is to create an Alert whenever there is a activity logged in Azure Portal --> Stream Analytics Job -->…
Im trying to send Data from my IoTHub Input to my Sql Database output, but tables stay empty?
Hello everyone, Im currently working on a university-project and I'm connecting my Raspberry Pi Pico with Azure. The Pico is sending temperature data, which is recieved in the IoTHub Input im my analytics stream, but when I'm trying to send the data to…
Data sync issue in Stream Analytics job to Azure SQL database
I am using the Raspberry Pi Azure IoT Online Simulator to push the data (in the interval of every 500 milli seconds) to Azure IoT hub (Basic Tier) using this link https://azure-samples.github.io/raspberry-pi-web-simulator/ I have configured Stream…