cancel
Showing results for 
Search instead for 
Did you mean: 
Reply
Highlighted
Helper II
Helper II

Power BI Row Level Security - Using Login E-mail ID - Report Server

Please find the below screen shots.

I have two tables (Portfolio Details & Department Manager) - Relationship with Department Name.

Given the Row Level Security to Department Manager table using the login email Id mapped to DepartmentChief e-mail ID column.

My aim is when a Department Chief view the report, he should be able to view the Portfolio details of his department only. This works well when we test the Desktop file uisng View as roles. 

However not sure what need to be done in Report server. Once we upload the report to server, the RLS doesn't work. Not sure what to be done in the Row Level security option available in the report server.

 

1.png2.png3.png

 

 

Helpful resources

Announcements
August 2020 Community Challenge: Can You Solve These?

August 2020 Community Challenge: Can You Solve These?

We're excited to announce our first cross-community 'Can You Solve These?' challenge!

Community Blog

Community Blog

Visit our Community Blog for articles, guides, and information created by fellow community members.

Community Summit Australia – Join Online!

Community Summit Australia – Join Online!

Be a part of the leading Microsoft Business Applications digital event, curated for the APAC community.

Top Solution Authors
Top Kudoed Authors