Forum Discussion

BishwaR's avatar
BishwaR
Helper V
4 years ago

Paginated Report Subscription failed

I have created a paginated report with multiple parameters.

When the users subscribe to it and hit the button Run Now then it works but the next day at the scheduled time it fails to run automatically.

 

Please help how to set it up for an automatic schedule.

 

Thanks

NEED HELP Paginated Report

2 Replies

  • v-henryk-mstf's avatar
    v-henryk-mstf
    Community Support
    4 years ago

    Hi BishwaR ,

     

    First, please check if you have subscribed to the paging report correctly by following the steps below:

    1. Report parameters
    2. Recipients list
    3. Email subject
    4. Report file name
    5. Delivery schedule

     

    It is also possible that the subscription is not working due to the following reasons, please check.

    Frequently asked questions about Troubleshooting Power BI subscriptions

     

    If the problem is still not resolved, please provide detailed error information and your related steps screenshoots. Looking forward to your reply.


    Best Regards,
    Henry


    If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.

    • BishwaR's avatar
      BishwaR
      Helper V
      4 years ago

      Thank you for your kind response.

       

      I found out the problem yet don't know how to fix it.

       

      My dataset it dynamic it changes daily.

       

      For eaxmple if I have selected the following parameter Customer Name = ABC for subscription today :

       

      Date            Customer Name  Sales

      5/5/2022      ABC                      $10

       

      If I do run now it sends an email with the subscription and store the given parameter in the memory for next day.

       

      But next day I will have the following Data

      Date            Customer Name  Sales

      5/6/2022      XYZ                      $15

       

      Customer Name = ABC  will not be avaialbe in the dataset because he did not make any sales for 5/6/2022.

      My Dataset is live it changes daily depending upon the Customer performance. If the Customer ABC has some sales on 5/6/2022 then the parameter that I had set yesterday works but if that customer ABC did not male sales next day then the subscription based on parameter Customer Name = ABC fails.

       

      So I may have to create a dimension table with all the Customer Names and create a parameter based on that able so that even if that particular customer did not make any sales the parameter will work and send the subscription

       

      Thank you