Forum Discussion

ToddChitt's avatar
ToddChitt
Icon for Super User rankSuper User
6 years ago

Row Level Security question

Hello all, I have a model with 2 columns in the Client table: [Primary] and [Secondary], both have email addresses of the Sales Person. I have two security roles defined for each column with stateme...
Need Help
v-frfei-msft's avatar
v-frfei-msft
Icon for Community Support rankCommunity Support
6 years ago

Hi ToddChitt ,

 

We cannot use the function USERNAME to create calculated column.We can create roles like that.

 

Also you can refer to the online document.

 

If it doesn't meet your requirement, Kindly share your sample data and excepted result to me if you don't have any Confidential Information. Please upload your files to One Drive and share the link here.

 

 

 

 

 

ToddChitt's avatar
ToddChitt
Icon for Super User rankSuper User
6 years ago

I am well versed in RLS in Power BI. 

To state the problem another way:

I have a large user population with access to the app so the dashboards need to be dynamic.

Any one user may have 'rights' to 'see' any one row in the major table by virtue of the fact that there are TWO different Roles and each Role secures the table via a DAX Filter statement on one of TWO different fields, I want to default the Dashboard tiles to show only the data that is attached to rows where the ONE role is in play.

 

IF the USERNAME() function could be used in a Column definition, then I would be all set. So I'm asking if anyone has done this before and if anyone has suggestions.

 

Unfortunately, this is proprietary data AND is in an on-premise SSAS Tabular database so cannot be shared. It can only be described, sorry.