Forum Discussion
Solved
Paginated Export
I have a big paginated report which is more than 250MB when exported to CSV. is there away that I can export the on schedule? the subcription to sharepoint and onedrive is limited to 250MB.
To export large paginated reports over 250MB on a schedule, use Power BI REST API or Power Automate:
Option 1: Power BI REST API
- Use the Export-To-File API for Paginated Reports. API: POST https://api.powerbi.com/v1.0/myorg/reports/{reportId}/ExportTo Save the export to an external storage location (e.g., Azure Blob Storage).
Option 2: Power Automate
- Create a flow to export the paginated report using the Power BI Export to File action.
- Save the file to a location like SharePoint or OneDrive.
Workaround: Split the report into smaller sections using filters or parameters to reduce the file size.
Hi drkusnadi,
I wanted to check if you had the opportunity to review the information provided. Please feel free to contact us if you have any further questions. If my response has addressed your query, please Accept it as a solution and give a 'Kudos' so other members can easily find it.
Thank you.