Forum Discussion
Power bi report schedule
Hi venkatakrish_01,
Thank you for reaching out to Microsoft Fabric Community.
Thank you Zanqueta for the prompt response.
Here the issue is because the power bi subscriptions cannot send attachments larger than 25 MB. When the exported paginated report exceeds this limit the subscription fails and this attachment size limit cannot be increased.
Since your organization uses google so the best solution is to automate the export outside of email and then deliver the report at 12 AM without requiring manual download. Please follow below steps:
- Automate a nightly export using the Power BI REST export API
- Save the file to Google Drive
- Send your users an email with the Google Drive link at 12 AM.
Please refer this below document:
https://learn.microsoft.com/en-us/power-bi/developer/embedded/export-paginated-report
Thanks and regards,
Anjan Kumar Chippa
Hi venkatakrish_01,
Its hard without a error code, or a print but, let my try help:
The error occurs because email providers limit attachment sizes. Here are the best ways to solve it:
Best Solution (Power Automate): Create a Power Automate flow that exports the report, saves it to SharePoint or OneDrive, and then emails users a link to that file. This completely bypasses the 25 MB attachment limit and is the most scalable solution.
Simple Solution (Link Only): In the Power BI subscription settings, change the subscription to send only a link to the report (untick the "attach file" option). Users can then access the report in the service and export it themselves.
Workaround (Reduce Size): If you must send an attachment, try to reduce the file size by filtering the report (e.g., create separate, smaller subscriptions per region) or changing the export format (e.g., PDF is often smaller than Excel).
Reference: Create a dynamic subscription for a paginated report - Power BI | Microsoft Learn
✅ If this response solved your problem, please mark it as correct to help other community members.