Forum Discussion
Filter data by text
Hi
i have dataset with 4 columns :
account. division. sales. password.
i want to use filter where i can type manually, the password and i'll get the data for this specific account.
i tryed to use "Text filter" , the problam is that i need each account to see only his data, and in this filter if i clear averything, then i get all data for all accounts, or if i write for example in the text filter -"1001" and one account have password "1001A" and one have "100B" it will give me both accounts.
what i need is, that every account will have the option to see only hisone data
can i do this?
Thank you!
2 Replies
- VahidDMSuper User
Hi oren
Have you tried to set RLS to restrict data access for given users?
Check this links:
Row-level security (RLS) with Power BIRestrict data access with row-level security (RLS) for Power BI Desktop
And this video:
https://www.youtube.com/watch?v=MxU_FYSSnYU
If this post helps, please consider accepting it as the solution to help the other members find it more quickly.
Appreciate your Kudos!!
- orenHelper III
i am not sure this is good solustion if i have 200 passwords..
this mean i need to do this 200 times and have 200 reports.. (if i untersted right)
and just to clarify - this report supposed to go out of the organization as an html.