How to download the report as an excel in the PowerBI. Currently, I have embedded the report in the SharePoint page using the PowerBi web part, would need to download the report using a download button.
I have used PowerBI API - POST https://api.powerbi.com/v1.0/myorg/reports/{reportId}/ExportTo
Response - { "error": { "code": "InvalidRequest", "message": "Report requested for export is not on dedicated capacity" } }
Export to excel file is supported only for Paginated reports.Error seems to be workspace is not on Capacity. Update your with workspace with any Premium Gen Capacity
References:
https://learn.microsoft.com/rest/api/power-bi/reports/export-to-file#fileformat