Forum Discussion
Filtering Based on a Parameter
michaelb I have worked in very large implementation where they want to compare their data with other institutes but still with RLS they were able to see their own data but other data was kept for comparison. it was a very complex implementation but very successful. All of this was achieved by designing a smart data model and complex DAX measure.
The only challenge I see in your case is that you have multiple datasets whereas the project I worked on they have only one large dataset that server all of their customers.
Having said that, in nutshell, this all can be achieved but need a lot of work, it is not as simple an answer as you expect here. A lot of planning needs to be done to make it work, it is going to mix of the data model and DAX measures.
Just my 2 cents.
Hi parry2k ,
I don't believe RLS will work for us as we are using PowerBI Embedded for a multi tenant application.
Each tenant has their own dataset (all the same schema) and their own login which is used by embedded reports available to all of their indivudal users. It would not be feasible for us to set up RLS for each individual user across all datasets.