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,
May I ask if you have resolved this issue? If so, please mark the helpful reply and accept it as the solution. This will be helpful for other community members who have similar problems to solve it faster.
Thank you.