Export Embedded Report to API that will export the binary stream

[Don-Bot]

We would like to setup an email export of power bi embedded but use your application to do it.  Can someone tell me if we can use these api's to export the binary stream of the report?

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

[v-veshwara-msft · Accepted solution]

Hi @Don-Bot ,
Thanks for asking the question in Microsoft Fabric Community,

Yes, you can use the Power BI REST API, specifically the Export To File endpoint to export an embedded report as a binary stream (such as PDF, PPTX, or PNG). This allows your application to generate the report file programmatically and then use that file stream for purposes like sending via email.

To achieve this, you can follow these steps:

1. Call the Export To File API with the report ID and desired export format.

2. Use the Get Export To File Status API to poll until the export job completes.

3. Once completed, the API provides a download URL where you can fetch the file (binary stream).

Requirements:

• The workspace must be hosted in a Premium (P), Embedded (A SKU), or Fabric capacity.
• API authentication must be done using a service principal or master user with access to the report.
• The download URL returned by the API is valid for 24 hours.
• Exporting to PNG will return a ZIP file containing one image per page.

Here’s the official documentation for reference:
Export Power BI embedded analytics reports API - Power BI | Microsoft Learn
Reports - Export To File - REST API (Power BI Power BI REST APIs) | Microsoft Learn

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.