Join us at FabCon Atlanta from March 16 - 20, 2026, for the ultimate Fabric, Power BI, AI and SQL community-led event. Save $200 with code FABCOMM.
Register now!The Power BI Data Visualization World Championships is back! Get ahead of the game and start preparing now! Learn more
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
Solved! Go to 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.
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.
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....
The Power BI Data Visualization World Championships is back! Get ahead of the game and start preparing now!