How to handle UNIX timestamp inside Timeseries insights in AZURE

Category: azure time series insights

Question

BI Automation AG on Fri, 12 Jul 2019 10:30:32


We have a device that can send data only with UNIX timestamp (no ISO date). Is it possible to handle UNIX timestamp as timestamp field in Timeseries insights. With ISO timestamp it's working fine, but with UNIX timestamp it seems not working. Is there a way to handle UNIX timestamps in timeseries Insights?


Replies

AshokPeddakotla-MSFT on Tue, 16 Jul 2019 16:13:35


@BI Automation AG

We are checking on this internally and will get back to you as earliest.

AshokPeddakotla-MSFT on Wed, 31 Jul 2019 05:52:59


@BI Automation AG

Unix format is not supported at ingress or query in Time Series Insights. We support only ISO format, You can find more details on this page. You can try the conversion at the source location before the message is sent to Hub, again it depends on how much customization can be done on the device.

I suggest you, please create a feedback item on the UserVoice and upvote. All the feedback you share in these forums will be monitored and reviewed by the Microsoft engineering teams responsible for building Azure.