Forum Discussion
Microsoft Fabric Operations Agent not triggering Power Automate flow on KQL ingestion-worked earlier
Hi Team,
I’m facing an issue with Fabric Operations Agent where it is no longer triggering actions, even though the same setup was working earlier.
Use case:
Trigger a Power Automate flow whenever new data is inserted into a KQL table.
Setup details:
Table: OpportunityEvents (KQL DB)
Agent: Opportunity Events API Trigger
Action: TriggerOpportunityAPI (connected to Power Automate flow)
Flow Trigger: “When an activator rule is triggered”
Flow Action: HTTP POST
No parameters passed from agent
Agent Instructions:
Operational Instructions
Trigger the action TriggerOpportunityAPI when Opportunity_ID is not empty.
Semantic Instructions
OpportunityEvents table contains incoming opportunity event data.
Each record represents a new event.
Opportunity_ID uniquely identifies each event.
Action Instructions
Trigger TriggerOpportunityAPI without passing any parameters.
Generated Playbook:
Condition: isRecentlyAdded = True
Uses: ingestion_time() >= ago(5m)
Issue:
Agent is in Running state
Flow is correctly connected (connection string configured)
Data is inserted using .ingest inline
Data is visible and recent (within 5 minutes)
But:
❌ No trigger
❌ No Teams approval
❌ Flow not executing
Important Context:
This same setup was working about 1 month ago
No major changes were made to:
Agent configuration
Flow
Table schema
What I verified:
Inserted fresh records after starting agent
Used new Opportunity_ID values
Verified ingestion_time()
Reinstalled Fabric Operations Agent in Teams
Recreated connection and flow
Questions:
Has there been any recent change or limitation affecting Operations Agent triggers?
Does inline ingestion (.ingest inline) still support triggering, or is streaming ingestion required?
Are there known delays/issues with activator-based triggers recently?
Is there any way to debug why the rule is not firing?
Any help or insights would be greatly appreciated.
Thanks!
5 Replies
Hi Karunasree_0 ,
Thank you for the details.
As you mentioned you are using .ingest inline, please try switching to streaming ingestion, then insert new test data and monitor the agent and Power Automate run history.Please refer to this for more details:
https://learn.microsoft.com/en-us/azure/data-explorer/ingest-data-streaming?tabs=azure-portal%2CcsharpIf the issue persists, please let us know.
Thank you.Hi Karunasree_0 ,
Could you please confirm if your query has been resolved by the provided solutions? This would be helpful for other members who may encounter similar issues.
Thank you.
Hi v-anbandari The issue has not resolved even after enabling streaming ingestion. Created Event stream to dump data to KQL. This also didn't trigger the Operations Agent
Hi Karunasree_0 ,
Since the issue persists even after validating ingestion methods (inline, streaming, and Eventstream) and confirming the setup, this may require deeper investigation.Please consider raising a Microsoft support ticket for further investigation. You can include all the troubleshooting steps you have performed to help the support team better understand the issue.
You can create a support ticket using the link below:
https://learn.microsoft.com/en-us/power-bi/support/create-support-ticket
Thank You.Hi Karunasree_0 ,
Could you please confirm if the issue has been resolved after raising a support case? If a solution has been found, it would be greatly appreciated if you could share your insights with the community. This would be helpful for other members who may encounter similar issues.Thank you for your understanding and assistance.
