I have a column with Time as Data type in my SQL Server table which is being used as a reference data in Azure Stream Analytics. What I'm doing is cast the values in the same data type which they belong to before using them as a look up data and pass on to Power BI datasets, but it seems SQL reference input does not support TimeSpan. For a work around, as of now I'm casting it to varchar but I believe reference input should support TimeSpan soon.
@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.