Reports - Export To File API (Dynamic Binding and Paginated)

[coffey88]

I can't find any documentation except for the make up of body for the request. Basically we have a paginated report and several datasets we want to bind to when exporting a PDF. 

POST to https://api.powerbi.com/v1.0/myorg/groups/*workspaceId*/reports/*reportId*/ExportTo

{
  "format": "PDF",
  "paginatedReportConfiguration": {
      "formatSetting": {
          "useReportPageSize": true
      },
    "parameterValues": [
      {
        "name": "Date",
        "value": "2/28/2023 12:00:00 AM"
      }
    ],
    "identities": [
      {
        "username": "[email protected]"
      }
    ]
  },
  "powerBIReportConfiguration": {
"settings": {
            "locale": "en-US",
            "excludeHiddenPages": "false"
        },
        
"datasetToBind": "xxxx-9d66-4a43-8e75-ac43fc9c5656",
"identities": [
      {
        "username": "[email protected]"
      }
    ]
}
}

I'm trying a request with the body above but I keep recieving "Invalid Request" - "

Export report was called with invalid configuration type". I recieve this even with an empty "

powerBIReportConfiguration" object.

It all looks valid unless their some sort of combination I'm not allowed to do.

[AmosHersch]

Hi @coffey88 ,

I believe paginatedReportConfiguration and powerBIReportConfiguration are mutually exclusive, you cannot provide both. If you are exporting a paginated report then you should only provide paginatedReportConfiguration.

I don't think you can dynamically bind a dataset to the paginated report just for the export operation. It is supported when exporting PowerBI (PBIX) reports.

[coffey88]

@AmosHersch Is there any alternative to facilitate what I'm trying to do? I'm not apart of our PBI team, but this seems like it would be pretty painful for them to have to build/setup all of our tenants Paginated reports individually.