topic Re: Can Reflex trigger an event in a Fabric warehouse table in Activator

Can Reflex trigger an event in a Fabric warehouse table

nhniniras — Thu, 31 Oct 2024 11:02:23 GMT

Case:

Our RPA department wants to see if we can use Data Activator or Reflex to trigger an event in Power Automate, where the Managers' email is written into a Microsoft Entra ID security group.

Therefore, I plan to create a Type2 history Manager table in a Fabric WH table, and the hope was that we could create a Reflex that could capture changes in this table.

However, here is where I encounter problems. I can't seem to get Reflex to communicate with a regular Fabric WH table. It seems that Reflex can only work with EventStreams (in JSON format) or perhaps an Azure SQL CDC database. I had the impression that Reflex could use all kinds of Fabric items as a source, but maybe I misunderstood (which certainly wouldn't be the first time in history).

Is this a "Mission Impossible" I'm dealing with, or can you guide me in another direction?

Re: Can Reflex trigger an event in a Fabric warehouse table

lbendlin — Thu, 31 Oct 2024 12:02:41 GMT

As I understand it Reflexes need a "change" or "trigger". Of course much like Power Automate this is all smoke and mirror and it is ~~turtles~~ polling all the way down. But it still needs something to measure to decide if a reflex should be initiated.

So - Reflexes don't work against data, they work against measures. Not sure if you can implement something like that in a data warehouse.

Re: Can Reflex trigger an event in a Fabric warehouse table

jameshutton — Thu, 31 Oct 2024 12:40:18 GMT

nhniniras , here's one way you could do it:
1) Point Power BI at your table and make a visualisation from your table

2) Create a Data Activator trigger from your Power BI visualisation, using the "Set Alert" feature

3) Edit your alert in Data Activator and change the action type to a Power Automate trigger.

Re: Can Reflex trigger an event in a Fabric warehouse table

nhniniras — Fri, 01 Nov 2024 06:50:25 GMT

Hi and thank you for taking your time to give me an answar.

Even though it might work creating the trigger "Set Alert" from Power BI - I was originally hoping that I could do it a little bit more upstream in the process, like eg. in a lakehouse or warehouse table. But I was send into another direction where the process should be turned around, so that I will be Power Automate that "Query or ping" my WH table and check if there is changes to my data (instead of the other way around) 🙂