Skip to main content
cancel
Showing results for 
Search instead for 
Did you mean: 

Find everything you need to get certified on Fabric—skills challenges, live sessions, exam prep, role guidance, and more. Get started

Reply
Chip_Chipperson
Frequent Visitor

Streaming datasets and report visual aggregations

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?
1 ACCEPTED SOLUTION
jppp
MVP

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

View solution in original post

2 REPLIES 2
jppp
MVP

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.

Helpful resources

Announcements
Europe Fabric Conference

Europe’s largest Microsoft Fabric Community Conference

Join the community in Stockholm for expert Microsoft Fabric learning including a very exciting keynote from Arun Ulag, Corporate Vice President, Azure Data.

Power BI Carousel June 2024

Power BI Monthly Update - June 2024

Check out the June 2024 Power BI update to learn about new features.

RTI Forums Carousel3

New forum boards available in Real-Time Intelligence.

Ask questions in Eventhouse and KQL, Eventstream, and Reflex.