Automating Fabric Pipeline Execution with Logic Apps (Consumption Model)

In this blog, you'll learn how to trigger a Microsoft Fabric Pipeline using Azure Logic Apps, step-by-step. This integration can help automate data workflows and schedule tasks easily. For this walkthrough, I’ve used:

• Fabric Trial Workspace

• Azure Logic Apps (Consumption model)

⚡ Important Prerequisite: Enable Fabric API Access

Before you start, ensure that Service principals can use Fabric APIs is enabled in your Fabric Admin Portal.

• Navigate to Fabric Admin Portal → Tenant Settings.

• Find and enable the option: Service principals can use Fabric APIs.

Without enabling this setting, the Logic App will not be able to trigger the Fabric Pipeline.

🛠️ Step 1: Create a Fabric Pipeline

First, create a simple Fabric Data Factory Pipeline. Add a Wait activity to the pipeline and introduce a parameter named WaitTimeInSecs.

⚙️ Step 2: Set Up Azure Logic App

1. Navigate to Logic Apps in the Azure portal.

2. Open the Identity section and enable System-assigned managed identity.

3. 

   ⏰ Step 3: Add a Schedule Trigger

   In the Logic App designer, add a Recurrence trigger to control when your pipeline should be triggered (e.g., every day at a specific time).

4. 

   🌐 Step 4: Add HTTP Action

   Next, add an HTTP action to call the Fabric REST API.

   ➡️ API Endpoint: POST https://api.fabric.microsoft.com/v1/workspaces//items//jobs/instances?jobType=Pipeline

   Replace <your WS Id> with your Workspace ID

   Replace <pipeline id> with your Pipeline ID

   💡 Tip: You can find both values in the URL of your Fabric pipeline editor.

   

5. 📝 Request Body:

   Add the following JSON to the Body of the HTTP action to pass parameters:

   { "executionData": { "parameters": { "WaitTimeInSecs": 5 } } }

   

6. 🚀 Step 6: Save and Trigger the Logic App

   Save the Logic App.

   Run it manually (or wait for the scheduled time).

7. 📊 Step 7: Monitor the Pipeline Run in Fabric

   Navigate back to your Fabric Workspace and go to Pipeline Run History to confirm the pipeline executed successfully.

8. ✅ Conclusion

   By integrating Logic Apps with Microsoft Fabric Pipelines, you can automate data processing workflows with precision and flexibility. This is especially useful for scheduled tasks or event-driven scenarios.

Thanks for reading.