'How to download the report as an excel in the PowerBI
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" } }
Solution 1:[1]
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://docs.microsoft.com/rest/api/power-bi/reports/export-to-file#fileformat
Sources
This article follows the attribution requirements of Stack Overflow and is licensed under CC BY-SA 3.0.
Source: Stack Overflow
| Solution | Source |
|---|---|
| Solution 1 | Kotana Sai |