Forum Discussion

Anonymous

Not applicable

8 years ago

Solved

What Role is active

Hello,

Is there a way to find out what role is active when loging in on PBI.com.

We have several roles defined and i've noticed that sometimes they behave differently in Excel(Started in VS2017) than in PBI.com.

I would like to see what role is active for the user.

Kr, harry

Anonymous
8 years ago
I've found a simple solution with a role table, and in each role on the role table if added the RLS as =roletable[id]=1 (in the first) 2/3/4.
So I could see what role a user was having.
I messed up a bit with my own user being admin in the SSAS Azure server.
Have it clear now.

4 Replies

GilbertQ
Super User
8 years ago
Hi there,

When you are talking about Roles, is this for Row Level Security?
- Anonymous
  Not applicable
  8 years ago
  Yes it was, but I have found a quite simple (silly) solution but it works.
  Just defined a small table with the 4 roles into it, in each role I hardcoded =roleid=(testroles[id]=1) (or 2...4) and I could see what role was getting the user.
  Because I noticed that some changes are not always directly ... I still have to dig a bit into this.
  Main problem was probably that my normal user was also admin on the server, so I took it out and now I get it working, but was too late last night to continue....
- Anonymous
  Not applicable
  8 years ago
  I've found a simple solution with a role table, and in each role on the role table if added the RLS as =roletable[id]=1 (in the first) 2/3/4.
  So I could see what role a user was having.
  I messed up a bit with my own user being admin in the SSAS Azure server.
  Have it clear now.
  - GilbertQ
    Super User
    8 years ago
    That sounds like it will work