Use this tag for questions related to programmatic usage of Azure Time Series Insights.
A cloud service from Microsoft, offering ingestion, storage, analysis and visualization of large sets of event data.
Questions tagged [azure-timeseries-insights]
97 questions
0
votes
1 answer
Trying to fix missing data on Azure Timeseries Insight
I am trying to insert some missing data on my azure time series inside due to the several microservices failure. So between 20 Nov 2022 5pm to 9pm there were missing data and i had tried to fill those gaps by resubmitting the data that belongs to…
John Hadikusumo
- 1,317
- 2
- 11
- 20
0
votes
1 answer
Is there any function to get multiple timeseries with .get and create a dataframe in Pandas?
I get multiple time series data in series format with datetimeindex, which I want to resample and convert to a dataframe with multiple columns with each column representing each time series. I am using separate functions to create the dataframe, for…
trsen
- 13
- 2
0
votes
1 answer
Get difference between two dates in seconds using Time Series Expression Syntax in Azure Time Series Insights Explorer
I have an Event Hub that sends data to Time Series Insights, with the following message format:
{
"deviceId" : "Device1",
"time" : "2022-03-30T21:27:29Z"
}
I want to calculate the difference in seconds between the Event Hub EnqueuedTimeUtc…
Alejandro Alvarez
- 131
- 1
- 3
- 9
0
votes
1 answer
How to type and model telemetry from IOT Central data export, routed through Event Hub and consumed in TSI?
When using IOT Central data export to Event Hub, you have a message format which is:
{
"applicationId": "A-GUID",
"component": null,
"deviceId": "AN-ID",
"enqueuedTime": "2022-02-23T20:34:11.0400000Z",
"enrichments": {},
"messageProperties":…
Patrick
- 2,044
- 1
- 25
- 44
0
votes
0 answers
Avoid duplicate data on Time Series Insight / EventHub
I'm using Time Series Insight that is consuming events from EventHub. I just saw that we have some duplicated data. Is there a way to avoid the store of duplicate data on TSI or even on EventHub?
rfc
- 21
- 3
0
votes
0 answers
Not able to filter out required property in Azure TSI Gen1 Get Events API response
I am using the below request body to fetch only the required property values.
"searchSpan": {
"from": {
"dateTime": "2021-11-20T00:00:00.000Z"
},
"to": {
"dateTime": "2021-11-20T23:00:00.000Z"
}
},
…
kingvittu
- 47
- 8
0
votes
1 answer
How to bring data from multiple Azure IoT devices with different timestamp properties into same Azure Time Series Insights environment?
I have multiple Azure IoT devices sending telemetry messages to a single IoT hub.
Each device has its own timestamp property name. How can I make the data from all these devices go into same TSI environment?
I tried creating multiple event sources…
kingvittu
- 47
- 8
0
votes
1 answer
How to calculate downtime report using TSI Gen2 Rest APIs (Azure)
We are working with Azure IoT Hub which sends the data to Azure TSI, and we're utilizing the TSI Rest APIs to get the data from it.
Format of data-
Raw telemetry looks like -
{"status":0, "timestamp":123456, plc_id:1}
{"status":0,…
Indrajeet Singh
- 470
- 1
- 6
- 21
0
votes
1 answer
how to create simple model for Time Series Insight to separate sensors by devices
I am ingesting TSI with the following sample data:
[{
"deviceId": "testDevice1",
"eventOriginTime": "2021-07-30T21:00:34.754Z",
"x1": 24.270660400390625,
"y1": 997.2078247070312,
"z1": 25.398334503173828
},
{
"deviceId":…
MatnikR
- 181
- 2
- 16
0
votes
1 answer
Azure time series insights Interpolation
I am trying to understand how interpolation option in Azure time series insights is going to re construct signal if it has any missing values. I have sent time series data with some null values to event hub which then reflected in azure time series…
Pavan Satya
- 1
- 1
0
votes
1 answer
Why does Azure Time Series Insights GET availability response distribution have entry with Datetime.MinValue?
I have currently an working Azure TSI environment in use.
At the moment environment GET request for both store…
ajr
- 874
- 2
- 13
- 29
0
votes
0 answers
Time Series Insights not showing sub-object properties of a key/value pair
I have an application that is pushing data into IoT Hub which is being used as a data source for TSI. Below is an example message:
{
"EnqueuedTimeUtc": "2021-06-17T22:00:47.2170000Z",
"Properties": {},
"SystemProperties": {
…
Wes
- 1
0
votes
1 answer
Data goes to warm store and cold store simultaneously in Azure time Series Insight
I want to use Azure Time Series insight. I want to know data goes to warm and cold store simultaneously or when warm store rentention expires then it goes to cold store( i.e. Azure Storage).
Please confirm.
Regards,
Amit Agrawal
Amit Agrawal
- 51
- 2
- 16
0
votes
1 answer
Azure Time Series Insights query: how to denote a variable such as 'cpu.thermal.average' in the query?
My series' got the value: cpu.thermal.average. I see the values in the TSI explorer for the given range of time.
By executing the following request, for "temperatures" I only get "null".
I am not sure about how to write $event.cpu.thermal.average…
Stéphane de Luca
- 12,745
- 9
- 57
- 95
0
votes
1 answer
Azure Time Series: json attribute present in raw data but cannot be graphed
I am trying to graph data in Azure Timeseries Insights. For the provided sensor, I can only graph the event count - none of the values provided by the JSON are available. Despite this, the raw data is clearly all present.
I can see the attribute…
Steve Crawford
- 26
- 6