cancel
Showing results for 
Search instead for 
Did you mean: 
Reply
karthikvalluri Helper I
Helper I

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.

 

Helpful resources

Announcements
Announcing the New Spanish Forum

Announcing the New Spanish Forum

Do you need help in Spanish? Check out our new Spanish community section.

April 2020 Community Highlights

April 2020 Community Highlights

Info on our Super Users, MBAS content and badges, and updates to our support articles. - Read the full Community Highlights.

MBAS Gallery 2020

MBAS Gallery 2020

Watch Microsoft Business Applications Summit sessions on-demand.

Top Kudoed Authors