Power bi report schedule

[venkatakrish_01]

Hi 

I have created one paginated report recently and when I subscribed it with the help of subscription option I'm getting error that data is more then 23 MB which can not be transferred in email so what is the best solution for this issue. 

[venkatakrish_01]

The issue is organizationally they use Google platform they don't have power automate same time I can share the link only issue is exactly this report should be sent on 12 AM so if I send the link and ask them to download it they may be delayed with the report numbers. 

[v-achippa · Accepted solution]

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

[v-achippa]

Hi @venkatakrish_01,

As we haven’t heard back from you, we wanted to kindly follow up to check if the solution I have provided for the issue worked? or let us know if you need any further assistance.

Thanks and regards,

Anjan Kumar Chippa

[v-achippa]

Hi @venkatakrish_01,

We wanted to kindly follow up to check if the solution I have provided for the issue worked? or let us know if you need any further assistance.

Thanks and regards,

Anjan Kumar Chippa

[venkatakrish_01]

Hi @v-achippa @to use api we don't use power automation at our office 

[v-achippa]

Hi @venkatakrish_01,

Power BI email subscriptions cannot send attachments larger than 25 MB and this limit cannot be increased. That is why the paginated report subscription is failing.

Since your organisation does not use Power Automate, the best supported way is to export the report using the Power BI Export API and save it to a shared location (google drive).

A small scheduled script can run the export and place the file in drive, and the users can access it through a link. This avoids the 25 mb email limit completely.

Thanks and regards,

Anjan Kumar Chippa

[Zanqueta]

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:

1. 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.

2. 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.

3. 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.