Streaming datasets and report visual aggregations

[Chip_Chipperson]

Curious to know what the window or dataset that would be aggregated in a report visual when using a streaming dataset from Azure Stream Analytics?

Let’s say I have a number that’s being sent to PBI every 10 seconds with the average value for the past 10 seconds using a tumbling window. Seeing as how “do not summarize” does not exist for report visuals in this case, if I selected “average” as the aggregation for the field, would it be the average of the event (every time the dataset is pushed from ASA? Would it be the average of the historical dataset if historical analysis is on which I think is 200k rows, or if historical analysis was turned off, roughly an hours worth of cached data?

[jppp · Accepted solution]

From a visualizing perspective: streaming (with history) datasets are just like normal datasets. You if you add a card visual containing an average of the column, it will show an average of all the records in the dataset. You can add filters to the visual/page/report to alter the calculation.

Usually by adding an timestamp to the dataset you can easily filter based on time, e.g. last hour. Another option is to add the time/date as an increasing number to the dataset as you can use the 'Top N' visual as filter to achieve a visual containing only the last event without a relative filter based on time.

-JP

[Chip_Chipperson]

Great - that answers my questions. And I will follow your advice on filtering. Thanks!

Have you ever tried using rest calls to cosmos db as a data source in PBI? I was curious about seeing that as an alternative to ASA.

Edit: more specifically using a sql query using web call.