Forum Discussion

Anonymous's avatar
Anonymous
Not applicable
3 years ago

Export Paginated Report in Group to Excel

Hi,   I am trying to export a report to an Excel file. When using Reports - Export To File In Group  I get an error "Export report was called with invalid configuration type".   I used the follo...
Need Help
Show and Tell
Adamboer's avatar
Adamboer
Icon for Responsive Resident rankResponsive Resident
3 years ago

There are a few potential issues that could be causing this error message.

Firstly, make sure that you are using the correct API endpoint for exporting reports to a file. It should be something like: https://api.powerbi.com/v1.0/myorg/groups/{groupId}/reports/{reportId}/ExportTo.

Secondly, ensure that the parameter values you are passing in the request body match the names and values of the parameters in your report. Make sure that you have also selected the correct report ID and group ID.

Another potential issue could be related to the permissions of the app you are using to authenticate. Make sure that the app has the necessary permissions to export reports to a file. You can check this in the Azure portal under App registrations > Your App Name > API permissions.

Lastly, make sure that the format you are requesting the export in (in this case, XLSX) is supported by the Power BI API.

If none of these solutions work, try reaching out to the Power BI support team for further assistance.