Forum Discussion
Multiple Reports from a single Template (Power Bi Report Builder)
Create single paginated report, with input parameter "Client", which filter data only to selected client.
Create three scheduleds of this report, in each schedule you can specify Clinet parameter value.
Additional option (more flexibile) is use Data driven subcriptions, but i'm not sure if are avaliable on PBIRS (i'm using on dedicated SSRS for paginated reports)
Super Usergritman , the ideal would have RLS and let customers configure scheduler.
You can try the API route and filter bypassing the parameters. There some info here, see if that can help
Thanks for the reply amitchandak . I'll check the video at the link you posted.
josef78Memorable Member
Create single paginated report, with input parameter "Client", which filter data only to selected client.
Create three scheduleds of this report, in each schedule you can specify Clinet parameter value.
Additional option (more flexibile) is use Data driven subcriptions, but i'm not sure if are avaliable on PBIRS (i'm using on dedicated SSRS for paginated reports)
Thanks for the reply josef78. I set the report with the parameter and set schedules to run the report and send via email.
I also managed to call the report via an api. So can do 3 api calls to get the results I need two. so I have a few ways now!
Cheers