Microsoft Fabric Community Conference 2025, March 31 - April 2, Las Vegas, Nevada. Use code MSCUST for a $150 discount.
Register nowThe Power BI DataViz World Championships are on! With four chances to enter, you could win a spot in the LIVE Grand Finale in Las Vegas. Show off your skills.
I have a table which has a region field. I created a table as access with username, region, useradmin.
I want to filter region on main table based on the username and region from access table. Useradmin's should able to see all the regions and should not filter anything.
I tried below roles but it did not work.
[username] = USERPRINCIPALNAME()
if ( [username] = USERPRINCIPALNAME(), true(), [useradmin]=USERPRINCIPALNAME())
Solved! Go to Solution.
Hi @gsk135
Assign something like as the filter on your security table
To test click Modelling | View As then under Other user enter the name to test. Also tick the security role you created here mine is untitled
If you are happy with this answer please mark as a solution for others to find !
Kudos are always appreciated! Check out our free Power BI video courses.
Hi @gsk135
Assign something like as the filter on your security table
To test click Modelling | View As then under Other user enter the name to test. Also tick the security role you created here mine is untitled
If you are happy with this answer please mark as a solution for others to find !
Kudos are always appreciated! Check out our free Power BI video courses.
User | Count |
---|---|
141 | |
70 | |
69 | |
53 | |
52 |
User | Count |
---|---|
208 | |
94 | |
64 | |
60 | |
57 |