Find everything you need to get certified on Fabric—skills challenges, live sessions, exam prep, role guidance, and more.
Get startedGrow your Fabric skills and prepare for the DP-600 certification exam by completing the latest Microsoft Fabric challenge.
Out of hundreds of users, typically needing access to one region or sub-region, we have two users that need access to two sub-regions. I tried creating this role:
NA Canada East:
[%GeoKeyForSecurity] = "NA|CAN" || "NA|EAS"
But when the user tried to go into the Power BI Report, all the visuals have x's and when he clicks on "see details" he receives the following error message:
"Cannot convert value 'NA|EAS' of type Text to type True/False."
Any ideas why this will not work? Seems like it should logically.
Solved! Go to Solution.
I think I figured it out. I've made this mistake before in regular expressions. For the OR statement to work, I need to show two complete statements.
[%GeoKeyForSecurity] = "NA|EAS" || [%GeoKeyForSecurity] = "NA|CAN"
Seems like it will work.
I think I figured it out. I've made this mistake before in regular expressions. For the OR statement to work, I need to show two complete statements.
[%GeoKeyForSecurity] = "NA|EAS" || [%GeoKeyForSecurity] = "NA|CAN"
Seems like it will work.
User | Count |
---|---|
92 | |
86 | |
66 | |
62 | |
58 |
User | Count |
---|---|
150 | |
113 | |
95 | |
80 | |
72 |