topic Re: [URGENT] Run DataPipeline via API using Power Automate and get status in Pipelines

[URGENT] Run DataPipeline via API using Power Automate and get status

JatinSaini — Mon, 23 Dec 2024 10:19:12 GMT

Hi Developers,
Am new to the Fabric Platform and recently I have create a Data Pipeline. But I want to find a method to run that data pipeline not directyl from the fabric but via API method.
Since power automate can help us to use the http request connector, can we run the data pipeline using the api via power automate?
Can someone please brief me on the same and what will be the required authorization and authentication.

Thanks in advance.

Re: [URGENT] Run DataPipeline via API using Power Automate and get status

NandanHegde — Mon, 23 Dec 2024 10:52:22 GMT

plz refer the below link:

https://hatfullofdata.blog/trigger-microsoft-fabric-data-pipeline-using-power-automate/

Re: [URGENT] Run DataPipeline via API using Power Automate and get status

JatinSaini — Mon, 23 Dec 2024 12:15:42 GMT

Hi NandanHegde ,
THanks for the response and I have followed the steps but getting below error:

Re: [URGENT] Run DataPipeline via API using Power Automate and get status

JatinSaini — Tue, 24 Dec 2024 09:41:32 GMT

Hi NandanHegde and other Developers,
I was able to fix the issue and run the flow successfully.
The only missing part was to add below Headers to the API:
Content-Type: application/json
Authorization: Bearer <access token>

The Access Token can be copied from below step:

Sign in into the Fabric Portal for the Tenant you want to test on, and press F12 to enter the browser's developer mode. In the console there, run:

powerBIAccessToken

Copy the token and paste it for the ClientId variable.

Re: [URGENT] Run DataPipeline via API using Power Automate and get status

v-pnaroju-msft — Tue, 24 Dec 2024 17:16:25 GMT

Hi JatinSaini,

We are happy to learn that your issue has been resolved.

For any further assistance or questions, please continue to engage with the Fabric Community.

Best regards,
Pavan