Forum Discussion
Filter report based on user acess
Hi,
Can we have a login page in powerbi report and filter the reports based on the user logged in?
If not is there any workaround to achieve this:
Consider the situation:
I have a report for all stores and i have to restrict users access to only see data of stores they have access.
ie.. If user1 has access to storeA then,
when user1 accesses the report the entire report should be filtered to show only data for storeA.
Is there anyway this can be achieved for a powerbi report?
P.S: Iam not sure under which title in the forum this question should be posted. If this is something to be posted under
Report Server or Service. Please let me know
Anonymous , I think RLS - Row Level security, should help you in this case
https://community.powerbi.com/t5/MBAS-Gallery/Microsoft-Power-BI-Unleash-row-level-security-patterns-in-Power/td-p/712613
https://radacad.com/dynamic-row-level-security-with-organizational-hierarchy-power-bi
https://www.blue-granite.com/blog/using-dynamic-row-level-security-with-organizational-hierarchies
1 Reply
- amitchandak
Super User
Anonymous , I think RLS - Row Level security, should help you in this case
https://community.powerbi.com/t5/MBAS-Gallery/Microsoft-Power-BI-Unleash-row-level-security-patterns-in-Power/td-p/712613
https://radacad.com/dynamic-row-level-security-with-organizational-hierarchy-power-bi
https://www.blue-granite.com/blog/using-dynamic-row-level-security-with-organizational-hierarchies