Forum Discussion

mfureyAVPT's avatar
mfureyAVPT
Regular Visitor
2 years ago

Event Stream Data to OneLake

As reflexes are taking periodic snapshots of powerbi data, we're seeing a use case where we could add properties and measures to a certain level of granularity and change that into a trending table. ...
General Comment
General Question
Reflex
WillT's avatar
WillT
Community Admin
2 years ago

Hi - thanks for your comment. At first look, I'd say the process you use to load to Power BI would be the best place to do that aggregation and load into OneLake as well (and then you could run PBI in DirectLake mode on top of the data). If you want to record the times when Data Activator triggers fire/conditions are met, then that is something on our roadmap - we want to push that into OneLake to build up the history of the higher-order events.

 

We are also looking at dashboarding on top of the 'real-time' data that DA is evaluating. We're prioritizing operational state-of-the-business views rather than historical trending views, but I'd welcome your feedback on that!

mfureyAVPT's avatar
mfureyAVPT
Regular Visitor
2 years ago

yes, i'm almost thinking of a "push this data into a view" in OneLake. I use dax queries and power automate to run summarized timestamp views in the interim