cancel
Showing results for 
Search instead for 
Did you mean: 
Reply
karthikvalluri Regular Visitor
Regular Visitor

Power BI Reporting server:- Access data relevant to windows user/AD login

Hi All,

 

I would be using a SQL Server table which has all the necessary measures along with dimensions( it also has a column that says which windows login user id it belongs to). Now I need to pull this in PBIRS and display rows based on this column(windows_login user)  How do I achieve this in PBIRS?  Is this is what RLS is about? Can I not implement it at PBIRS level?

 

TableA:

Sales Department Login

100    cccc            abc\dmn

60      ddd            xyz\dmn

30      cccc            abc\dmn

 

So, when abc logins into PBIRS he should see 2 rows(130-Total sales)  from Table A.