Calling PBI Report Builder from Azure Data Factory (ADF)

Hi SreeSri3010 ,

Thank you for reaching out to the Microsoft Fabric Community forum.

Power BI Paginated Reports cannot be triggered directly from Azure Data Factory (ADF). However, this functionality can be achieved by utilizing the Power BI REST API, particularly the ExportToFile API, which allows you to export paginated reports in formats such as PDF, Excel, and CSV.

To proceed, ensure your paginated report is published to a Power BI workspace with Premium capacity, Fabric workspace, or a PPU license. Additionally, register an Azure AD application and grant it the necessary Power BI API permissions, such as Report.Read.All or Report.ReadWrite.All.

Next, use the Power BI REST API endpoint https://api.powerbi.com/v1.0/myorg/groups/{groupId}/reports/{reportId}/ExportTo to start exporting the report, you need to make an API call. This process is asynchronous, so after initiating the export, use the GetExportToFileStatus API to check when it's finished and get the download link once the file is ready.

Azure Data Factory doesn't have built-in support for Power BI integration. The recommended approach is to use an Azure Function or Logic App to manage authentication, API requests, status checks, and saving the exported file (such as to Azure Blob Storage). You can then trigger this function or app from ADF using a Web activity or Azure Function activity.

For reference, the official Microsoft documentation includes:

• Power BI REST API: ExportToFile
• Export paginated reports in Power BI
• Registering an Azure AD app and setting API permissions

This approach is fully supported and allows you to programmatically export and use Power BI paginated reports within your ADF workflows.

Hope this helps. Please reach out for further assistance.

If this post helps, then please consider to Accept as the solution to help the other members find it more quickly and a kudos would be appreciated.

Thank you.