Forum Discussion

venkatakrish_01's avatar
venkatakrish_01
Helper I
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...
Need Help
Show and Tell
Tips and Tricks
  • 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

v-achippa's avatar
v-achippa
Community Support
9 months ago

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

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's avatar
    venkatakrish_01
    Helper I
    8 months ago

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

    • v-achippa's avatar
      v-achippa
      Community Support
      8 months ago

      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