Forum Discussion

venkatakrish_01's avatar
9 months ago
Solved

Power bi report schedule

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. 

  • v-achippa's avatar
    v-achippa
    9 months ago

    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

7 Replies

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

  • 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's avatar
      v-achippa
      Community Support

      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's avatar
        v-achippa
        Community Support

        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