Forum Discussion
Helper IPermissions in the Role Manager with DAX
Hello, thanks for your input. It's an App owns Data scenario, but I got it to work.
First, I included 2 fields in the bridge table so I don't need the Users and permissions tables anymore:
Username and Branch_name.
Then, the following DAX that I found did it:
[Data_table_branch_column]
IN CALCULATETABLE (
VALUES ( 'bridge_table'[Branch_name] ),
FILTER (
ALL ( 'bridge_table' ),
[Username] = USERNAME ()
|| [Username] = USERPRINCIPALNAME ()
)
)
Microsoft EmployeeHi coriben,
1. Establish proper relationships.
2. Create roles like below.
[User_ID] = 1
3. Assign the role to users.
What's your scenario? App owns data or User owns data?
Best Regards,
Dale
Helper IHello, thanks for your input. It's an App owns Data scenario, but I got it to work.
First, I included 2 fields in the bridge table so I don't need the Users and permissions tables anymore:
Username and Branch_name.
Then, the following DAX that I found did it:
[Data_table_branch_column]
IN CALCULATETABLE (
VALUES ( 'bridge_table'[Branch_name] ),
FILTER (
ALL ( 'bridge_table' ),
[Username] = USERNAME ()
|| [Username] = USERPRINCIPALNAME ()
)
)
Hello
Can I use user permission on the Power BI Desktop (Optimized for Power BI Report Server), if yes how?