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

The ultimate Microsoft Fabric, Power BI, Azure AI & SQL learning event! Join us in Las Vegas from March 26-28, 2024. Use code MSCUST for a $100 discount. Register Now

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
Fabric Community Conference

Microsoft Fabric Community Conference

Join us at our first-ever Microsoft Fabric Community Conference, March 26-28, 2024 in Las Vegas with 100+ sessions by community experts and Microsoft engineering.

February 2024 Update Carousel

Power BI Monthly Update - February 2024

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

Fabric Career Hub

Microsoft Fabric Career Hub

Explore career paths and learn resources in Fabric.

Fabric Partner Community

Microsoft Fabric Partner Community

Engage with the Fabric engineering team, hear of product updates, business opportunities, and resources in the Fabric Partner Community.