I’ve got a query that has both UserArn (for RLS) and UserName (for dynamic parameter default values) columns. There are some exceptions due to certain folks being tied to wrong buildings so I have to manually manipulate so that they can be NULL to receive all the data.
I’m trying to avoid needing to have two separate datasets where I’d need to copy/paste the exceptions in two separate locations but came across this error: This permissions dataset has conflicting key column formats. You can use either names (UserName, GroupName) or ARNs (UserArn, GroupArn) in key columns, but not both in the same permissions dataset. Learn more
Any work around? Anyway I can tell RLS that I want it to ignore UserName column?