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

Calling all Data Engineers! Fabric Data Engineer (Exam DP-700) live sessions are back! Starting October 16th. Sign up.

Reply
jgarciabu
Advocate I
Advocate I

Real Time Data From Event Hub

As far as I can tell, you can only push data from an event hub to power bi through a streaming analytics query that uses a windowing grouping (tumbling, hopping, and sliding windows). Even if you set a window to 1 second refresh, the possibility always exists that more than 1 event can be grouped into that window. When that has happened to me, I'm not able to get specific data on either of the events that come through that window. Data comes through, but I don't know what event it refers to because it only creates one row of data for all events. For example, my count field will show that >1 events took place, but there aren't specific details for each event. There is just one row of data that corresponds to both events. I'm happy to provide further clarification if needed. Ultimately, I'd like for data that enters my event hub to be sent through the streaming analytics job to Power BI in real time and each data point given its own unique row.

1 REPLY 1
jgarciabu
Advocate I
Advocate I

I was able to figure this out. When creating queries with aggregate functions, the streaming analytics job needs a window of time to do the aggregating. That's not to say that a non-aggregating query cannot be used, which is what I was able to create. Now events are pushed to PBI from the Event Hub as they come in. I did this by removing my aggregate functions. Hope this helps.

Helpful resources

Announcements
FabCon Global Hackathon Carousel

FabCon Global Hackathon

Join the Fabric FabCon Global Hackathon—running virtually through Nov 3. Open to all skill levels. $10,000 in prizes!

October Power BI Update Carousel

Power BI Monthly Update - October 2025

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

FabCon Atlanta 2026 carousel

FabCon Atlanta 2026

Join us at FabCon Atlanta, March 16-20, for the ultimate Fabric, Power BI, AI and SQL community-led event. Save $200 with code FABCOMM.

Top Solution Authors
Top Kudoed Authors