Forum Discussion

gritman's avatar
gritman
Frequent Visitor
6 years ago
Solved

Multiple Reports from a single Template (Power Bi Report Builder)

Hello all,    I've started using the "Power Bi Report Builder" for Pagenated Reports.  Not sure if this is the correct location to ask but here goes: -   I have a data source which contains multi...
report builder
  • josef78's avatar
    josef78
    6 years ago

    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)

Greg_Deckler's avatar
Greg_Deckler
Icon for Community Champion rankCommunity Champion
6 years ago

gritman - You could use RLS but this will disable subscriptions. Are you wanting to send emails of the reports to people or are you just wanting them to connect and view the report?

gritman's avatar
gritman
Frequent Visitor
6 years ago

Hi Greg_Deckler, 

 

The ultimate goal is to send emails to clients with the the reports as attachments.

 

However my company is developing an in house tool for distribution - so what I ideally need to do is save the reports somewhere with a format like the below; the distribution tool will pick those files up, look-up the email addresses for each client, and send the emails.

 

So for Power Bi Report Builder - what I need, in this example, is 3 seperate reports each with a different names.

ClientA_Oct.xls

ClientB_Oct.xls

ClientC_Oct.xls

 

Thanks