Update: Microsoft will be moving away from UserVoice sites on a product-by-product basis throughout the 2021 calendar year. We will leverage 1st party solutions for customer feedback. Learn more here.

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. 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

    We're glad you're here

    Please sign in to leave feedback

    Signed in as (Sign out)

    We’ll send you updates on this idea

    0 comments  ·  Bugs  ·  Flag idea as inappropriate…  ·  Admin →
  2. 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

    We're glad you're here

    Please sign in to leave feedback

    Signed in as (Sign out)

    We’ll send you updates on this idea

    0 comments  ·  Bugs  ·  Flag idea as inappropriate…  ·  Admin →
  • Don't see your idea?

Feedback and Knowledge Base