Trigger On Demand Pipeline via Fabric API

[drabba]

Hello Team , 

Currently, triggering on-demand pipelines via the Fabric API using a service principal is not supported. While it is possible to use user identity for this purpose, this approach is not feasible for automated workflows.

We have a PowerShell script that utilizes user identity for authentication. When executed on our local system, it prompts for authentication, allowing us to proceed. However, in an automated flow where the PowerShell script runs on a remote system, interactive authentication is not possible, causing the script to halt. How to handle this situation  ? 

[nilendraFabric · Accepted solution]

Hello @drabba 

Azure Logic Apps can be configured to authenticate requests using Microsoft Entra ID. You can register an app in Azure AD, generate a client secret, and use the `client_credentials` flow to obtain a token for API calls.

this can act as a proxy, obtaining and caching the token and then triggering the Fabric API call on your behalf

Other option could be azure function to do the same stuff

Hope this helps

[V-yubandi-msft]

Hi @drabba ,

As we haven’t heard back from you, we wanted to kindly follow up to check if the solution we provided for your issue worked for you  or let us know if you need any further assistance?

Your feedback is important to us, Looking forward to your response. 

Thank You.

[V-yubandi-msft]

Hi @drabba ,

We noticed we haven't received a response from you yet, so we wanted to follow up and ensure the solution we provided addressed your issue. If you require any further assistance or have additional questions, please let us know.

Your feedback is valuable to us, and we look forward to hearing from you soon.

Thank You.

[V-yubandi-msft]

Hi @drabba ,

We noticed we haven't received a response from you yet, so we wanted to follow up and ensure the solution we provided addressed your issue. If you require any further assistance or have additional questions, please let us know.

Your feedback is valuable to us, and we look forward to hearing from you soon.

Thank You.

[V-yubandi-msft · Accepted solution]

Hi @drabba ,

Thank you for reaching out to the Microsoft Fabric Community.  @nilendraFabric , gave a one workaround using Azure Logic Apps to trigger Fabric pipelines. Thanks @nilendraFabric , for your input.  

Along with @nilendraFabric solution, we also recommend Power Automate as another effective option. Power Automate supports service principal authentication, making it a reliable choice for automating pipeline triggers without needing interactive authentication. This might be more suitable depending on your use case.

Another good workaround is to use Power Automate.

1. Create a Power Automate flow that triggers your Fabric pipeline.

2. Call the Power Automate API from your script using a service principal (which is supported).

3. This method allows you to fully automate the pipeline trigger without interactive authentication.

If my response solved your query, please mark it as the Accepted solution to help others find it easily!

And if my answer was helpful, I'd really appreciate a 'Kudos'.

[nilendraFabric · Accepted solution]

Hello @drabba 

Azure Logic Apps can be configured to authenticate requests using Microsoft Entra ID. You can register an app in Azure AD, generate a client secret, and use the `client_credentials` flow to obtain a token for API calls.

this can act as a proxy, obtaining and caching the token and then triggering the Fabric API call on your behalf

Other option could be azure function to do the same stuff

Hope this helps