Forum Discussion

Anonymous's avatar
Anonymous
Not applicable
7 years ago

Publishing Automation Help

I've searched for a few days and found nothing that would help this specific scenario.

 

I've built a standard report. Everything on the report is data driven and our clients have separate databases with the same schema. We have 12 clients now, but that could easily turn into 100 soon. This standard report requires me to open it in PowerBI desktop, change the name and data source, save it, and then publish.

 

I'd like to be able to publish my standard report 1 time (or in some automated fashion) to many PowerBI Premium report locations with 

1. Different Names (based on the client report name)

2. Different Datasets (basically pointing to a different client azure server/database)

 

So when I go to the service, I would see the following reports:

Client1

Client2

Client3

n number of reports...

and each of the separate reports (even though they are technically showing the same standard report) looks for it's data at a separate server/db to pull the unqiue clients dataset.

 

Any ideas on how best to achieve this? 

 

Thanks in advance for the help.