We are trying to implement Row Level Security for the datasets associated with our embedded dashboard using ‘User-based’ rules’. For that I created a sample file with ‘Username’ and ‘location_country’ as columns and with one row of data:
- username ='firstname.lastname@example.org; and location_country =‘United States’
Then used this file as the RLS file for a custom dataset with two columns (application_id, location_country) - Created an analysis using this custom file - created a table with location_country as column. Also, location_country has country values like United States, China, India
When I applied the RLS security using this file to the custom dataset and logged in using ‘email@example.com’ to view the analysis created, I expected to see only the rows associated with United States but I couldn’t see any data. (Refer screenshot)
So, my question is:
- Am I missing any particular step in here?
- Can user based rules be used for embedded dashboards?
Let me know if you need more information to debug this.