Skip to main content
cancel
Showing results for 
Search instead for 
Did you mean: 

Earn a 50% discount on the DP-600 certification exam by completing the Fabric 30 Days to Learn It challenge.

Reply
BishwaR
Helper V
Helper V

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

2 REPLIES 2
v-henryk-mstf
Community Support
Community Support

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.

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

Helpful resources

Announcements
RTI Forums Carousel3

New forum boards available in Real-Time Intelligence.

Ask questions in Eventhouse and KQL, Eventstream, and Reflex.

MayPowerBICarousel

Power BI Monthly Update - May 2024

Check out the May 2024 Power BI update to learn about new features.

LearnSurvey

Fabric certifications survey

Certification feedback opportunity for the community.

Top Kudoed Authors