Forum Discussion
Date filter doesn't work properly
I have found the sollution!
My date field in the dataset had also milliseconds...
So when filtering on a specific date only hour:minute:second is checked so no records are found because all the records have a date field with milliseconds in it and differ from the hour:minute:second date filter.
Thanx for the respons v-yulgu-msft!
Hi vincent_janssen,
Have you tried to format these date fields using Azure Stream Analytics Date and Time Functions?
Regards,
Yuliana Gu
Hi v-yulgu-msft,
I have used the CAST() function to cast my date to datetime in Azure Stream Analytics. But unfortunately this did not work.
I can try and use another Azure Stream Analytics Date and Time Function but the only one returing a datetime is DATETIMEFROMPARTS() and this will be very complex to create and the output will be a datetime again so I think the result will be the same...
Kind Regards,
Vincent
I have found the sollution!
My date field in the dataset had also milliseconds...
So when filtering on a specific date only hour:minute:second is checked so no records are found because all the records have a date field with milliseconds in it and differ from the hour:minute:second date filter.
Thanx for the respons v-yulgu-msft!
what is the solution for this ,As for me also Filters are not working on data coming from Stream Analytics to PowerBI
I a trying to put filter on column date1 and now but no output,Even now doesn't show time value
As you can see first 3 fields are coming from SA to PowerBI ,but rest no output as Filter is not working
