topic Re: Reports - Export To File API (Dynamic Binding and Paginated) in Developer

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

coffey88 — Tue, 07 May 2024 22:10:07 GMT

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": "userEmail@xyz.com" } ] }, "powerBIReportConfiguration": { "settings": { "locale": "en-US", "excludeHiddenPages": "false" }, "datasetToBind": "xxxx-9d66-4a43-8e75-ac43fc9c5656", "identities": [ { "username": "userEmail@xyz.com" } ] } }

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.

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

AmosHersch — Wed, 08 May 2024 05:50:52 GMT

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.

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

coffey88 — Wed, 08 May 2024 13:27:20 GMT

@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.