Forum Discussion
Streaming datasets and report visual aggregations
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
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
- 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.
