How to run Power Automate Flow Using ADF Pipeline or Active Batch

[Gopal_PV]

Hi Friends,

I have created manual trigger flow in power automate . i am executing a power bi report and exporting it pdf.

Everything working fine here.

Now my requirement is i want to run this flow from Active Batch or ADF Pipeline.

How to run this.

Can you please help me on this.

Regards,

[v-yueyunzh-msft]

Hi , @Gopal_PV 

My knowledge of some of the third-party software used in Power BI is limited to functionality and not very in-depth, but in the official feature offering of Power BI, there is a way to export reports to PDF using the Rest API, which you can consider using if it suits your business scenario:

Here are the steps to export a file to PDF using the rest API:

First you can use this rest API to start the export process, in the request body you can define the type of export file:

Reports - Export To File In Group - REST API (Power BI Power BI REST APIs) | Microsoft Learn

Then you can use the report ID and export ID to fill in the parameters into the URL of this rest API to get the status of the export task:

Reports - Get Export To File Status In Group - REST API (Power BI Power BI REST APIs) | Microsoft Le...

Finally, if the status gets "Succeeded", you can use this rest API to get the output file of the export task:

Reports - Get File Of Export To File In Group - REST API (Power BI Power BI REST APIs) | Microsoft L...

Thank you for your time and sharing, and thank you for your support and understanding of PowerBI! 

Best Regards,

Aniya Zhang

If this post helps, then please consider Accept it as the solution to help the other members find it more quickly