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'm setting security rules in my report by using a table which contains the countries (e.g. US, UK, DE, ...) that the user can see.
So, if a user can see more than one country, the security table will contain two rows for that user.
Since the fact I have many countries, wildcards would be very useful. For example, if the rule for a user is "*", then it would see all the countries.
Is there a way to use wildcards in LOOKUPVALUE function (I'm using that function in order to assign the rules).
Thanks.
Solved! Go to Solution.
Hi @rode,
It's not supported to use wildcard characters in LOOKUPVALUE() function.
Best Regards,
Qiuyun Yu
Hi @rode,
It's not supported to use wildcard characters in LOOKUPVALUE() function.
Best Regards,
Qiuyun Yu
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 |
---|---|
111 | |
95 | |
80 | |
68 | |
59 |
User | Count |
---|---|
150 | |
119 | |
104 | |
87 | |
67 |