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
Anonymous's avatar
Anonymous
Not applicable
3 years ago
AmosHersch wrote:

AFAIK this error indicates that you are trying to export a report which is not a paginated report, but you are sending paginatedReportConfiguration in the request.

Are you sure that your report is a paginated (AKA RDL) report?

AmosHersch, I think it isn't. Earlier errors and documentation suggested Excel exports are only possible when I add this parameter. Since the web interface has an Export Data option, where I can only pick .xlsx. My understanding is that this is the only method to do the same using the API.

AmosHersch's avatar
AmosHersch
Microsoft Employee
3 years ago

There's a list of supported types when exporting a paginated report, and a list of types when exporting a Power BI report. You can export a Power BI report to a type which is only supported for a paginated report.

I don't think there's an API for exporting a Power BI report to XLSX. Indeed ou can export a visual data to XLSX, but not the entire report AFAIK.

  • Anonymous's avatar
    Anonymous
    Not applicable
    3 years ago

    The confusion for me is that there is an "Export Data" option, which does produce a .xlsx file.