Forum Discussion

acanom's avatar
acanom
Regular Visitor
4 years ago

Issues with 'datetime' filter for streaming dataset

I'm completely new to Power BI Desktop/Service/etc. Trying to create my very first report in Power BI Service from a Streaming Dataset (generated and updated by Azure Stream Analytics job).

 

Have a Streaming Dataset with a few fields. Two important for this question are:

'cpuload' as Number
'Timestamp' as DateTime

 

When looking at the table all fields are correct. I need to show the very latest value of 'cpuload' for the latest 'Timestamp'. I've got a card and when I'm applying 'Top 1' filter for 'Timestamp' it should show the corresponding value of 'cpuload'. But when applying a filter for 'Timestamp' it doesn't always show correct values for 'cpuload' for the latest date/time. Sometimes it shows correct values and sometimes it shows blank. All date/times are correct.

 

See the screenshots. For '04/04/22 12:20:01 AM' it shows the 'cpuload' value (first screenshot), but for '04/04/22 12:15:02 AM' it shows blank while it still has the value (second screenshot).

 

 

 

 

Any idea why it does that and fails to show values? I cannot figure out the correlation why sometimes it's failing to properly apply filter.

 

Same behaviour in Power BI Desktop - no difference.

Need Help

5 Replies

  • Tutu_in_YYC's avatar
    Tutu_in_YYC
    Super User
    4 years ago

    Can you hover over this? And see if there are any other filters acting on the visual.

     

  • acanom's avatar
    acanom
    Regular Visitor
    4 years ago

    I think there is something wrong with the timestamp that Azure Streaming Analytics job is sending to Power BI. Because a card for Earliest (or Latest - doesn't really matter) Timestamp doesn't show value for some items. But these timestamps are sent by ASA and for each there is a correspoding value. They all look correct.

     

    Card configuration:

     

    Working one:

    Not working one.

  • acanom's avatar
    acanom
    Regular Visitor
    4 years ago

    Here is the ASA query. Very simple. And by testing it it sends correct data.

     

    SELECT
    temperature,
    cpuload,
    sensorName,
    System.Timestamp AS Timestamp
INTO
    [VirtualSensorBI]
FROM
    [DeviceInputStream]

     

  • Tutu_in_YYC's avatar
    Tutu_in_YYC
    Super User
    4 years ago

    There no visual indication that anything is wrong. I tried to recreate the issue, but not able to reproduce it. I hope the other members in the community may be able to chime in.