Filter table based on password

[Topaz]

Hello

I have a table that contains a list of researchers, their ID's and details of budjet and expenses.

I want to use the table using the Power BI Reporting services on permises so all the reasercher will be able to see the table

The problem is that I want that every researcher will be able to see only his private data so the table will be filltered by the ID

Is there a way to make that when someone goes to the report in the reporting services he'll need to put his ID an password and then that the table will be filltered accordingly?

Thanks In Advance

[Anonymous · Accepted solution]

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!

RLS with UserName()  

Regards,

Xiaoxin Sheng

[sokg]

Hello @Topaz

I think you must use the USERNAME function

Here is the documentation

https://msdn.microsoft.com/en-us/library/hh230954.aspx

Also read this article from Adam

https://powerbi.microsoft.com/en-us/documentation/powerbi-admin-rls/

[Topaz]

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

[Greg_Deckler]

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.