Forum Discussion
Row Level Security w/SecurityTable
Hello Power BI Masters! I have a question about Power BI RLS. I am struggling to find a working solution to provide security around our data using RLS in the Service. Currently, we use Power BI ...
Anyone? lol
- How does the condition in your RLS role look like?
I assume you use the USERNAME() function.
Try creating 2 measures with like "username = USERNAME()" and "up = USERPRINCIPLENAME()".
See what these measures return in power BI Desktop and in the cloud.
I guess u need to add a column "userprinciplename" to your security table and use the email address instead. then update the role to use the new column and userprinciplename () function. This may not work in power bi desktop depending on your alternative upn settings of your local AD account.
