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. S...
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