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

Join us for an expert-led overview of the tools and concepts you'll need to become a Certified Power BI Data Analyst and pass exam PL-300. Register now.

Reply
cdupland
Frequent Visitor

Stream Analytics - Update row in dataset

Hello,

 

I am using an Azure architecture to have a real-time Dashboard Power BI about Twitter post.

 

Architecture is like this : Event Hub -> Streaming Analytics -> Power BI

This works fine and I can show Tweets and statistics moce in real-time.

 

My problem is that Stream Analytics can only add row in my Dataset and it's possible to receive same tweet from my Event Hub.

So I potentially add several times the same Tweet in my Dataset and distort data statistics.

 

I would like to know if it's possible to do an update with Stream Analytics in the Dataset, or if there is a trick to get the most recent post when there is a duplication ?

 

 

Thanks.

Cyril

5 REPLIES 5
v-jiascu-msft
Microsoft Employee
Microsoft Employee

Hi Cyril,

 

If they are duplicates, they all could be the most recent. Maybe you can filter them in the beginning. Which visual did you use in the Power BI? Maybe we can filter them using a slicer. About filtering push dataset, please refer to service-real-time-streaming#can-i-use-filters-on-push-dataset-how-about-streaming-dataset.

 

Best Regards,

Dale

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

Hi Dale,

 

Main visual in Power BI are counting rows (distcint), list, bargraph with date, circular, etc..

I don"t know how to get the most recent row between 2.

 

Thanks

Cyril

Hi Cyril,

 

How can we identify the "2"? By date?

Do you mean this scenario below?

 

row1  news1  date1

row2  news1  date1

row3  news2  date2

 

Since the row1 and row2 are the same, you need to show up the row1 and row3.

 

Best Regards,

Dale

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

Hi Dale,

 

My scenario is below :

 

row1 news1 date1

row2 news1 date2

row3 news2 date1

 

Row1 and row2 are the same, with date2 > date1.

So, I would like to show row2 and row3.

 

Thanks

Best Regards

 

Cyril

Hi @cdupland 

Did you solve this issue, I'm struggling with the exact same..

 

BR

Roberto

Helpful resources

Announcements
Join our Fabric User Panel

Join our Fabric User Panel

This is your chance to engage directly with the engineering team behind Fabric and Power BI. Share your experiences and shape the future.

June 2025 Power BI Update Carousel

Power BI Monthly Update - June 2025

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

June 2025 community update carousel

Fabric Community Update - June 2025

Find out what's new and trending in the Fabric community.