What Role is active

[Anonymous]

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

[GilbertQ]

Hi there,

When you are talking about Roles, is this for Row Level Security?

[Anonymous · Accepted solution]

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]

That sounds like it will work

[Anonymous]

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....