Power BI Header Auth icon

Power BI Header Auth

Work with the Power BI API using header authentication

Report → Export To File

AI-generated

Summary

Export a Power BI report or paginated report to a specified file format, optionally waiting for the export to complete and downloading the file content.

Inputs

  • Authentication Token (required) — Bearer token for authentication without the "Bearer" prefix.
  • Workspace Name or ID (required) — ID of the workspace (group) containing the report; selectable from available groups or defined via expression.
  • Report Name or ID (required) — ID of the report to export; filtered by selected workspace, selectable from available reports or defined via expression.
  • Report Type (required) — Specify whether the report is a 'Power BI Report' or a 'Paginated Report'.
  • Export Format (required) — File format to export the report to, with allowed formats depending on the report type (e.g., PDF, PNG, PPTX for Power BI Reports; PDF, CSV, IMAGE, XLSX, DOCX, XML, etc. for Paginated Reports).
  • Wait For Completion — Boolean flag indicating whether to wait until the export operation completes before returning the result; defaults to true.
  • Download File — If waiting for completion, boolean flag to return the exported file as binary data and base64 encoded in the output for direct use or download; defaults to false.
  • Additional Fields — Optional parameters including maximum wait time in seconds and polling interval between status checks.
  • Power BI Report Configuration — Additional configuration options specific to Power BI Reports, such as dataset binding, bookmarks, page filtering, Row-Level Security identities, locale, and inclusion of hidden pages.
  • Paginated Report Configuration — Additional configuration options specific to Paginated Reports, including format-specific settings, parameters, Row-Level Security identities, and locale.

Output shape

a single JSON object representing export status and, if requested, the exported file as binary and base64 encoded data

If 'Wait For Completion' is true and 'Download File' is enabled, the exported file is returned as a binary file in the n8n workflow with base64 available in 'fileBase64' for easier integration with other services. The operation may poll until export completion or timeout based on the maximum wait time and polling interval settings. If 'Wait For Completion' is false, export initiation response is returned without file data.

Examples

Example 1: Export a Power BI report as PDF, wait for export completion, and download the resulting file.

Provide 'Authentication Token', select workspace and report, set 'Report Type' to 'Power BI Report', 'Export Format' to 'PDF', enable 'Wait For Completion' and 'Download File'.

Discussion