Forum Discussion
Paginated Report Subscription failed
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.
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