Filter data by text

[oren]

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!

[VahidDM]

Hi @oren 

Have you tried to set RLS to restrict data access for given users?

Check this links:
Row-level security (RLS) with Power BI

Restrict 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!! 

LinkedIn | Twitter | Blog | YouTube 

[oren]

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.