Connect with Dynamic Data source

[Anonymous]

I have a report which is shared with different clients. For all clients, the table schema is the same but the table is stored on different servers. I want to use Roles Security for the data source. So instead of creating different reports for every source, I can use a single report for all clients.
For a client with @abc.com will get the report which shows data from its respective server.

Is there is a way to use RLS to provide Dynamic Data source, with the help of parameters? 

Thanks 

[v-lili6-msft]

hi @Anonymous 

To use RLS in your scenario, you need to import all the datasource into power bi,

then add a tag column and append all the table into one table, Now set RLS for this report.

For your case, I would also suggest you use PBIT file to create the same report for different datasouce easily

https://powerbi.microsoft.com/en-us/blog/deep-dive-into-query-parameters-and-power-bi-templates/

Regards,

Lin