Forum Discussion

amoore5156's avatar
amoore5156
Frequent Visitor
10 years ago
Solved

Alter Report Filters Based On Recipient

Is there any functionality in Power BI that can filter reports based on the reciever of a given report/dashboard? For example, lets say I am working with clients A through Z and I create a master rep...
  • samdthompson's avatar
    samdthompson
    10 years ago

    Yes. you can use the row level security.

     

    1. use the RSL in service version (click elipsis on dataset then security). This is super easy but the RSL is still beta and will be overridden on data refresh.

    2. use DAX function username() as a filter. This works if your table contains all your users ID's assigned to the correct regionalities. Then just join region[reagion_name] to fact[region_name] (or whatever it might be).

     

    However make sure in your user table you have email address of a user as username() in power bi desktop will return domain\username while in power bi service it will return email address of logged in user

     

     

samdthompson's avatar
samdthompson
Memorable Member
10 years ago

Yes. you can use the row level security.

 

1. use the RSL in service version (click elipsis on dataset then security). This is super easy but the RSL is still beta and will be overridden on data refresh.

2. use DAX function username() as a filter. This works if your table contains all your users ID's assigned to the correct regionalities. Then just join region[reagion_name] to fact[region_name] (or whatever it might be).

 

However make sure in your user table you have email address of a user as username() in power bi desktop will return domain\username while in power bi service it will return email address of logged in user