Forum Discussion
Filter table based on password
Hi Topaz,
I think dynamic RLS based on username will be suitable for your requirement, perhaps you can take a look at below link:
Power BI – Dynamic Row Level Security – Tips to get it working!
Regards,
Xiaoxin Sheng
Hello
I have a table with a list of researchers names, ID's and for each researcher has it own budjet and expenses.
I want to make the table to be used in Power BI Report Server on peremises so all the reasercher can see the table.
The problem is that I want that each researcher will be able to see only his data so the table will be filtered accordingly
Is there a way to make that when each person opens the report in the reporting services he will have to enter an ID number and a password and then that the table will be filtered according to his ID number?
Thanks In advance
In general, the answer would be Row Level Security but that doesn't exactly work as you describe it. You would have to have something in your data that you could filter on to create a group for each user and then assign the users to the correct group.
