Register now to learn Fabric in free live sessions led by the best Microsoft experts. From Apr 16 to May 9, in English and Spanish.
I have a report with a table that defines store numbers/store owners and emails. I have created role level security to look up in a table:
in modeliing in desktop I have this-
UPPER([emailaddress1]) = UPPER(USERNAME())
then on the dataset security I've defined the group.
this works great.
I want to add a role for corporate to basically ignore any role level security as they should be able to view report and see everything. Do I create the role and basically define no DAX expression? or how do I do that?
I saw someone else ask similar and a person said to do DAX1=1. I have no idea what this means, they didn't elaborate.
Solved! Go to Solution.
Hi @electrobrit ,
>>Do I create the role and basically define no DAX expression?
We can do that, this role will see all data, then we can add users to this role.
The result will like below:
Best Regards,
Teige
Hi @electrobrit ,
>>Do I create the role and basically define no DAX expression?
We can do that, this role will see all data, then we can add users to this role.
The result will like below:
Best Regards,
Teige
Covering the world! 9:00-10:30 AM Sydney, 4:00-5:30 PM CET (Paris/Berlin), 7:00-8:30 PM Mexico City
Check out the April 2024 Power BI update to learn about new features.
User | Count |
---|---|
114 | |
99 | |
82 | |
70 | |
60 |
User | Count |
---|---|
149 | |
114 | |
107 | |
89 | |
67 |