topic Re: Paginated Report Subscription failed in Report Server

Paginated Report Subscription failed

BishwaR — Mon, 04 Jul 2022 22:46:19 GMT

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

Re: Paginated Report Subscription failed

v-henryk-mstf — Thu, 07 Jul 2022 07:19:40 GMT

Hi BishwaR ,

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

Report parameters
Recipients list
Email subject
Report file name
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.

Re: Paginated Report Subscription failed

BishwaR — Sun, 10 Jul 2022 19:52:21 GMT

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