Azure Time Series Insights

Azure Time Series Insights is an end-to-end Platform-As-A-Service offering to ingest, process, store, and query highly contextualized, time-series-optimized IoT-scale data that’s ideal for ad-hoc data exploration, as well as operational analysis. Azure TSI is a uniquely extensible and customized service offering that meets the broad needs of industrial IoT deployments.

More details about the service are available Time Series Insights documentation.

  • Hot ideas
  • Top ideas
  • New ideas
  • My feedback
  1. Add data de-duplication and upsert

    Time Series Insights doesn't have a de-duplication feature. Today duplicates are just stored in TSI and that makes the query results wrong. We have the need for de-duplication and also upsert to replace or enrich existing time series.

    2 votes
    Sign in
    (thinking…)
    Sign in with: Microsoft
    Signed in as (Sign out)

    We’ll send you updates on this idea

    0 comments  ·  Data ingestion  ·  Flag idea as inappropriate…  ·  Admin →
  2. Fix search span and interval misalignment issue in AggregateSeries queries

    When aggregating data in TSI, you must provide an interval and a search span.

    Sometimes the intervals start before the search span instead of at the specified "from" time. This also results in inconsistent number of intervals being returned.

    e.g.

    "aggregateSeries": {

        "interval": "P1M",
    
    "searchSpan": {
    "from": "2020-11-01T00:00:00Z",
    "to": "2020-12-31T23:59:59.999Z"
    },
    ....

    }

    TSI returned 3 intervals with timestamps:

    - "2020-10-03T00:00:00Z"
    - "2020-11-02T00:00:00Z"
    - "2020-12-02T00:00:00Z"

    We expect 2 intervals with timestamps:
    - "2020-11-01T00:00:00Z"
    - "2020-12-01T00:00:00Z"
    | |

    2 votes
    Sign in
    (thinking…)
    Sign in with: Microsoft
    Signed in as (Sign out)

    We’ll send you updates on this idea

    0 comments  ·  Time series query API  ·  Flag idea as inappropriate…  ·  Admin →
  3. Add ability to create "default" hierarchy and to populate new instances with dynamic values with formula

    Give ability to select a hierarchy by default and to specify a dynamic value to populate the instance on creation. ($event.client for example)

    When TSI receive a new message with unknown time-series id, the new instance use the default hierarchy, search the values with formulas and set the values

    1 vote
    Sign in
    (thinking…)
    Sign in with: Microsoft
    Signed in as (Sign out)

    We’ll send you updates on this idea

    0 comments  ·  Time series model  ·  Flag idea as inappropriate…  ·  Admin →
  4. 5 votes
    Sign in
    (thinking…)
    Sign in with: Microsoft
    Signed in as (Sign out)

    We’ll send you updates on this idea

    2 comments  ·  Time series query API  ·  Flag idea as inappropriate…  ·  Admin →
  5. The median aggregate returns null-aggregates when using "value": {"tsx": 'coalesce(toDouble($event.value.Long), $event.value.Double)'}

    See two examples of the payload when querying for a median aggregate below.

    Median2 works fine if Median1 is not in the payload. However if you try querying both (or only Median1) only null values are returned. I believe there is a problem using the coalesce function. This is not a problem if other aggregates are queried, such as min, avg, last, etc.

    "inlineVariables": {

            "Median1": {
    
    "kind": "numeric",
    "value": {"tsx": 'coalesce(toDouble($event.value.Long), $event.value.Double)'},
    "filter": null,
    "aggregation": {
    "tsx": "median($value)"
    },
    },
    "Median2": {
    "kind": "numeric",
    "value": {"tsx": '$event.value.Double'},
    "filter": null,
    "aggregation": {
    "tsx": "median($value)"
    },
    },
    },

    1 vote
    Sign in
    (thinking…)
    Sign in with: Microsoft
    Signed in as (Sign out)

    We’ll send you updates on this idea

    0 comments  ·  Bugs  ·  Flag idea as inappropriate…  ·  Admin →
  6. Increase the number of variables that are possible per type

    Currently we have a customer with devices that have 260+ variables. When configuring these types i encoutered the problem that this can only be 50 variables per type. i would request that this number will be raised to 500 or more.

    1 vote
    Sign in
    (thinking…)
    Sign in with: Microsoft
    Signed in as (Sign out)

    We’ll send you updates on this idea

    0 comments  ·  Time Series Explorer UX - Model management  ·  Flag idea as inappropriate…  ·  Admin →
  7. Retrieve markers added by users on charts

    It could be greate to be able to retrieve via API markers that analysts have spotted using Azure TSI, in order to persist and use those markers elsewhere.

    7 votes
    Sign in
    (thinking…)
    Sign in with: Microsoft
    Signed in as (Sign out)

    We’ll send you updates on this idea

    0 comments  ·  Time series query API  ·  Flag idea as inappropriate…  ·  Admin →
  8. Apache Kafka as an event source to Time Series Insights

    I would like to use an existing Kafka stream to get data into Azure Time Series Insights, but the only event sources are Event Hubs or IoT Hub. Adding support for open-source such as Apache Kafka, Rabbit MQ, Active MQ, etc. would enable a lot of different scenarios.

    1 vote
    Sign in
    (thinking…)
    Sign in with: Microsoft
    Signed in as (Sign out)

    We’ll send you updates on this idea

    0 comments  ·  Data ingestion  ·  Flag idea as inappropriate…  ·  Admin →
  9. Historical Hierarchy Membership

    Historical Hierarchy Membership

    Say;

    I have a device D1 which is part of plant (hierarchy) P1 with measurement M1 on time T1 and M2 on time T2 .

    and device D2 which is part of plant P2 with measurement M3 on time T1 and M4 on time T2.

    So at first on time T1:

    P1 has D1 with measurement M1 and

    P2 has D2 with measurement M3.

    Between time T1 and T2 a field engineer switches D1 to P2 and D2 to P1.

    But now we have the inconsistency that looking in the TSI Explorer on time T1:

    P1 has…

    1 vote
    Sign in
    (thinking…)
    Sign in with: Microsoft
    Signed in as (Sign out)

    We’ll send you updates on this idea

    0 comments  ·  Time series model  ·  Flag idea as inappropriate…  ·  Admin →
  10. DayOfWeek in DateTime Functions

    You can get the monthOfYear and the dayOfMonth but not the dayOfWeek. For our requirements it would be very helpful to have this possibility.

    Example
    We need only the days from monday to friday, within a daterange greater than x months.

    4 votes
    Sign in
    (thinking…)
    Sign in with: Microsoft
    Signed in as (Sign out)

    We’ll send you updates on this idea

    0 comments  ·  Time series query API  ·  Flag idea as inappropriate…  ·  Admin →
  11. Mode Aggregate function with Time Series Insights

    We have a requirement to aggregate data using MODE function ( returns the most occurring value from the given time range. Does Azure TSI supports this? Please suggest.

    4 votes
    Sign in
    (thinking…)
    Sign in with: Microsoft
    Signed in as (Sign out)

    We’ll send you updates on this idea

    0 comments  ·  Time series query API  ·  Flag idea as inappropriate…  ·  Admin →
  12. Calculate values (booleans?) for formulas

    In the Time Series Model, I'd love to create a new variable in a Type that is a categorical value, but based on thresholds of a calculation or a variable. Now the categorical values are just translations of lists, but I would love to be able to create a new variable like this:

    Good: temperature < 23
    Warn: temperature > 23 and temperature < 24
    Alert: temperature > 24

    I don't see that possible in the time series model ?

    1 vote
    Sign in
    (thinking…)
    Sign in with: Microsoft
    Signed in as (Sign out)

    We’ll send you updates on this idea

    0 comments  ·  Time series model  ·  Flag idea as inappropriate…  ·  Admin →
  13. Increase maximum number of concurrent connections per environment

    Currently, only 20 concurrent connections are allowed which limits usage of the API heavily. Would be great if this was increased to a larger amount per environment.

    7 votes
    Sign in
    (thinking…)
    Sign in with: Microsoft
    Signed in as (Sign out)

    We’ll send you updates on this idea

    0 comments  ·  Time series query API  ·  Flag idea as inappropriate…  ·  Admin →
  14. Create an Angular typescript package for TSI

    Create a TypeScript package for use with Angular to easily integrate TSI into Angular SPA applications rather than forcing developers to adapt the existing JavaScript SDK.

    1 vote
    Sign in
    (thinking…)
    Sign in with: Microsoft
    Signed in as (Sign out)

    We’ll send you updates on this idea

    0 comments  ·  JavaScript SDK  ·  Flag idea as inappropriate…  ·  Admin →
  15. Use instance fields for calculations

    Can we use the instance fields to calculate variables for a given type? And if so, how?
    So far I only see event data being used ($event.[value].double), but what if I need a static value?
    Something like $instance.[fieldname].Double would help but it doesn't seem to work like that...

    Git issue: https://github.com/MicrosoftDocs/azure-docs/issues/49367

    4 votes
    Sign in
    (thinking…)
    Sign in with: Microsoft
    Signed in as (Sign out)

    We’ll send you updates on this idea

    0 comments  ·  General  ·  Flag idea as inappropriate…  ·  Admin →
  16. no 'raw' data can be viewed in PowerBI when using the TSI connector

    We used the accelerator to generate IOT data and then can view the data in TSI. However when we try to view the data view PowerBI , no 'raw' data can be viewed in PowerBI when using the TSI connector to PowerBI approach.

    Here is a link to the details on how I am trying to view TSI data in PowerBI:

    https://docs.microsoft.com/en-us/azure/time-series-insights/how-to-connect-power-bi

    2 votes
    Sign in
    (thinking…)
    Sign in with: Microsoft
    Signed in as (Sign out)

    We’ll send you updates on this idea

    0 comments  ·  Bugs  ·  Flag idea as inappropriate…  ·  Admin →
  17. Batch upload existing data

    We should need a feature that upload existing data to coldstorage .

    3 votes
    Sign in
    (thinking…)
    Sign in with: Microsoft
    Signed in as (Sign out)

    We’ll send you updates on this idea

    0 comments  ·  General  ·  Flag idea as inappropriate…  ·  Admin →
  18. Better Documentation needed

    As of now current documentation looks quite isolated. It would be better to have a doc starting from posting json

    {

        &quot;deviceId&quot;: &quot;FYYY&quot;,
    
    &quot;timestamp&quot;: &quot;2018-01-17T01:18:00Z&quot;,
    &quot;series&quot;: [
    {
    &quot;tagId&quot;: &quot;pumpRate&quot;,
    &quot;value&quot;: 0.58015072345733643
    },
    {
    &quot;tagId&quot;: &quot;oilPressure&quot;,
    &quot;value&quot;: 22.2
    }
    ]
    }

    to how to model this json for better visualization. to a new comer modeling and hierarchy concepts are kind of still isolated. It might just be the missing piece.

    5 votes
    Sign in
    (thinking…)
    Sign in with: Microsoft
    Signed in as (Sign out)

    We’ll send you updates on this idea

  19. 12 votes
    Sign in
    (thinking…)
    Sign in with: Microsoft
    Signed in as (Sign out)

    We’ll send you updates on this idea

    1 comment  ·  Time series query API  ·  Flag idea as inappropriate…  ·  Admin →
  20. Timestamp documentation

    The timestamp is an important factor in the Azure Time Series Insights. But there is no proper documentation regarding the format, the best practices to send timestamp in UTC (or in any other format) from the IoT device. It will be extremely helpful if there is proper documentation for this scenario.

    4 votes
    Sign in
    (thinking…)
    Sign in with: Microsoft
    Signed in as (Sign out)

    We’ll send you updates on this idea

    0 comments  ·  Time series query API  ·  Flag idea as inappropriate…  ·  Admin →
← Previous 1
  • Don't see your idea?

Feedback and Knowledge Base