Forum Discussion

skusulja's avatar
skusulja
Frequent Visitor
6 years ago

Filter by user logged in

Hello everyone, This is yes or no question, probably really simple one.   I have report which contains data about employees. How much cases they solved, how many hours they spent resolving certa...
Need Help
skusulja's avatar
skusulja
Frequent Visitor
6 years ago

I do not want row level security (RLS) as a feature. I need that all data is visible to others. Just default that it is filter (visualization) to a particular user.

I have thought to add new DAX column to my Users table with expression:

CurrentUser = IF(USERPRINCIPALNAME()=Employees[SystemUser.UserName],TRUE(),FALSE())
 
However, I have error:
CUSTOMDATA, USERNAME, USERCULTURE and USERPRINCIPALNAME functions are not supported in calculated tables/columns. These functions may only be used in Measures or in the AllowedRowsExpression.
 
Ok, but is there any other way to set default filter on visualization to a current user?
 
Pragati11's avatar
Pragati11
Super User
6 years ago

Hi skusulja ,

 

  • If you are planning to share a single dashboard to multiple users then Row-Level security is the approach that should adopt.
  • If you are planning to distribute multiple dashboards for individual users than you can go with filter on Username. But, this approach is not the right way to go forward with.

 

Thanks,

Pragati

  • hkusulja's avatar
    hkusulja
    Frequent Visitor
    6 years ago

    This is simple question about using Power BI Report in web.

    Example is Sales report, where Filter (on page for example or visualization) persists, and should be default set to current user.
    But user should be able to change this filter and see other sales performance in power bi report for other users.
    It is just a question on setting value to a current filter (page filter or visualization filter) for which user to display the data.

    It does not have nothing with Power BI Dashboards, nor Row level security