Re: SQL reference data in Azure Stream Analytics

AndyZ_ASA I think the best solution should be to support TimeSpan data type in Azure Stream Analytics, so that the Power BI reports can be created without altering or converting the field to the desired output.

As of now rather than converting it to a DateTime, I have converted it to a nvarchar(max). The fields are dynamic so I don't want any individual manipulations to happen.