How to deal with missing events in streaming data?

Streaming data is often not perfect – some of the events can be missing and some can be generated or received with delay. At the same time downstream applications may require input data within regular intervals (e.g. every 5 seconds) Some customers asked us – how can Azure Stream Analytics be used to convert a…


Handling Json array in Stream Analytics Query

This week, I am sharing a query question asked in stackoverflow to illustrate how to handle json array in Stream Analytics Query:   Problem   I retrieve some weatherdata from an external API. This is returned as JSON and send to an Azure IoT hub. Stream analytics processes the json into a proper format, but I…


New ASA Features: Service Bus Queues, Topics outputs & Power BI Org Id decoupled from Azure Id

We are pleased to announce the following new features added to Azure Stream Analytics: Built-in Output to Service Bus Queues and Topics In your Azure Stream Analytics job, you now have two additional output options: Service Bus queues and topics. These options enable you to easily implement many common use cases like integration with your…


Power BI output now a public preview feature

Power BI output has been one of our most popular features, enabling customers to quickly build a live updating dashboard on streaming data without any heavy coding work. Along with many exciting announcements over the last 1 month (General Availability, Build Sessions, Customer and Partner sessions at Build and Ignite), we also recently announced that Power BI…