This is best Fabric, Power BI, SQL and AI community event. How do we know? The last event sold out! Save €200 with code FABCMTY200.
Register nowThe Fabric community is now in read-only for platform upgrade. Learn more
Hello Community Experts,
I am trying to create a report where users see there own data and no one elses. Trying to use RLS with UserPrincipleName. The role equation is [Email] = USERPRINCIPLENAME (). Attempts to save this statement gets a Filter Error -
I checked with the local Power BI SME as well as on the web, but we could not come up with a solution. If quotes are added around USERPRINCIPLENAME (), the error message goes away, but I don't think that is the right syntax. Any help is appreciated. Thanks in advance
Solved! Go to Solution.
That seems like a weird error to get try just copying and pasting this in. USERPRINCIPALNAME ()
That seems like a weird error to get try just copying and pasting this in. USERPRINCIPALNAME ()
Join us in Barcelona for FabCon and SQLCon, the Fabric, Power BI, SQL, and AI community event. Save €200 with code FABCMTY200.
| User | Count |
|---|---|
| 23 | |
| 22 | |
| 14 | |
| 14 | |
| 13 |
| User | Count |
|---|---|
| 47 | |
| 39 | |
| 24 | |
| 20 | |
| 20 |