topic Re: Anyone able to run data pipeline with Power Automate successfully? in Pipelines

Anyone able to run data pipeline with Power Automate successfully?

arpost — Mon, 14 Apr 2025 23:02:58 GMT

Greetings, all. I am wanting to use Power Automate to run Fabric pipelines and get info about a pipeline run. I have successfully used other Fabric REST APIs, but when I try to use the Run on-demand item job API, I can never access the header response and instead get an error.

However, the pipeline runs behind the scenes as expected and includes the input parameter I send.

Does anyone have suggestions or know how to get this working? I found an article indicating this may have to do with the fact that this call doesn't return a response (article here), but it seems to me like there HAS to be a way to get this working. I can do this easily with the Try it! feature in the MS docs related to this API (doc link)

Anyone have ideas/suggestions?

Re: Anyone able to run data pipeline with Power Automate successfully?

lbendlin — Sat, 05 Apr 2025 12:36:03 GMT

Write your own custom connector until they fix the incomplete response.

Re: Anyone able to run data pipeline with Power Automate successfully?

v-achippa — Tue, 08 Apr 2025 12:11:44 GMT

Hi arpost,

Thank you for reaching out to Microsoft Fabric Community.

Thank you lbendlin for the prompt response.

As we haven’t heard back from you, we wanted to kindly follow up to check if the solution provided by the super user resolved your issue? or let us know if you need any further assistance.
If our super user response resolved your issue, please mark it as "Accept as solution" and click "Yes" if you found it helpful.

Thanks and regards,

Anjan Kumar Chippa

Re: Anyone able to run data pipeline with Power Automate successfully?

arpost — Tue, 08 Apr 2025 21:03:42 GMT

Thanks for the response, lbendlin. I did start down that path but am running into issues getting the custom connector working. Do you (or anyone else in the community) have resources specifically related to creating a custom Power Platform connector to use with Fabric?

Re: Anyone able to run data pipeline with Power Automate successfully?

lbendlin — Tue, 08 Apr 2025 22:17:15 GMT

should be straightforward. What are your issues? Make sure to turn asynchronous mode off.

Re: Anyone able to run data pipeline with Power Automate successfully?

arpost — Thu, 10 Apr 2025 13:54:10 GMT

Appreciate the help. It probably is, and I'm overlooking something obvious. 🙂 Here's my current connector and app reg configuration:

I wasn't certain that I'm including all of the required URLs for Fabric access. I had trouble authenticating previously until I used the graph.microsoft.com URL to authenticate my user. However, when I try to use a basic form of the List Pipelines API, I get this error (added a fake RequestID):

{ "requestId": "111111-1111-1111-1111-11111", "errorCode": "RequestFailed", "message": "Unable to process the request" }

Re: Anyone able to run data pipeline with Power Automate successfully?

lbendlin — Sat, 12 Apr 2025 17:27:36 GMT

no real need for an app registration if you use HTTP with Entra pre-authorized.

Re: Anyone able to run data pipeline with Power Automate successfully?

v-achippa — Mon, 14 Apr 2025 10:59:25 GMT

Hi @arpost,

We wanted to kindly follow up to check if the solution provided by the super user resolved your issue.
If our super user response resolved your issue, please mark it as "Accept as solution" and click "Yes" if you found it helpful.

Thanks and regards,

Anjan Kumar Chippa

Re: Anyone able to run data pipeline with Power Automate successfully?

arpost — Mon, 14 Apr 2025 23:05:13 GMT

lbendlin, are you saying use HTTP with Entra in a Power Automate custom connector? Or natively in Power Automate?

If you're referencing the native connector in Power Automate, there is a need for custom connector when trying to work with APIs such as the Run On Demand API (see initial post with error examples when calling via Power Automate). The HTTP with Pre-Auth apparently can't read API responses that do not have a response body and throws errors.

That API returns the unique ID for an object run in the header (see this example) :

Re: Anyone able to run data pipeline with Power Automate successfully?

v-achippa — Tue, 22 Apr 2025 11:13:52 GMT

Hi arpost,

Since the Run on-demand item job API returns only a 202 response with no body, power automate's standard HTTP action does not handle it well.

Create a custom connector, use https://api.fabric.microsoft.com as the base URL and authenticate using OAuth 2.0 (Azure AD) with the proper scope.
In the action settings, turn off asynchronous mode.
Even though the body is empty, the location header contains the runId. So in your response section define the location header so you can extract the pipeline run ID from it in your flow.

If this post helps, then please consider Accepting as solution to help the other members find it more quickly, don't forget to give a "Kudos" – I’d truly appreciate it!

Thanks and regards,

Anjan Kumar Chippa

Re: Anyone able to run data pipeline with Power Automate successfully?

v-achippa — Mon, 28 Apr 2025 12:30:54 GMT

Hi arpost,

As we haven’t heard back from you, we wanted to kindly follow up to check if the solution I have provided, resolved your issue.
If my response resolved your issue, please mark it as "Accept as solution" and click "Yes" if you found it helpful.

Thanks and regards,

Anjan Kumar Chippa

Re: Anyone able to run data pipeline with Power Automate successfully?

arpost — Tue, 20 May 2025 19:34:41 GMT

Any idea what the resource URL is supposed to be?