Show the Latest Data from Streaming Dataset in Matrix

[Anonymous]

Hi,

I have a created a report from a streaming dataset in Power BI. I would like to show the latest data for each category but fail to do so. I have tried to use the filter function by using Top N in realtime to get the only latest datetime value. However, it fails as not all the values are continuous.

The dataset looks like this,

08:00:00 -> 10
08:00:30 -> 
08:01:00 -> 12

08:01:30 -> 13

08:02:00 -> 

So, if I try to obtain the values at 08:02:00 as it is the latest datetime, it shows nothing.

Thank you in advance for any help!

[v-xicai · Accepted solution]

Hi @Anonymous ,

With a streaming dataset, there is no underlying database, so you cannot build report visuals using the data that flows in from the stream. As such, you cannot make use of report functionality such as filtering, Power BI visuals, and other report functions.

The only way to visualize a streaming dataset is to add a tile and use the streaming dataset as a custom streaming data data source. The custom streaming tiles that are based on a streaming dataset are optimized for quickly displaying real-time data. There is very little latency between when the data is pushed into the Power BI service and when the visual is updated, since there's no need for the data to be entered into or read from a database.

For reference:

Real-time streaming in Power BI

Best Regards,

Amy 

Community Support Team _ Amy

If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.