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 v-yulgu-msft,
Sorry for not responding!
I re-created the report with data imported from an Excel sheet. If I have data from an Excel sheet I have no issues with the date slicer, everything works fine.
So I think that Azure Stream Analytics outputs a wrong type of date to the dataset in PowerBI because the date filter with the dataset form Azure Stream Analytics won't work.
Thanx for the help!
Kind regards,
Vincent
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
