Forum Discussion
Connect with Dynamic Data source
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
1 Reply
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
