Earn a 50% discount on the DP-600 certification exam by completing the Fabric 30 Days to Learn It challenge.
Hello all, I have a question about content filtering.
So, I have users in my system (each User record has uuid, unique email and other non-unique fields like user name etc). I have different content which was created by these users. I'd like to build different reports for them, but they have to see only their records. I saw such thing as RLS, but I don't have roles in my system or I can threat all users as User role. How can I filter content in accordance with their uuids or emails?
Solved! Go to Solution.
Hi, I have App-own-data.
I solved this question in this way - due to that fact that I have relations between user records and their data I simply apply basic filter from application when report finishes initialization.
I think that also possible solution is connect data table to the table with relations between users and data and filter relations table by user uuid.
Hi @CyberiX,
How did you embed your contents? The App-own-data or User-own-date? The RLS will be applied in different ways for different scenarios. Please refer to developer/embedded-row-level-security and service-admin-rls.
Best Regards,
Dale
Hi, I have App-own-data.
I solved this question in this way - due to that fact that I have relations between user records and their data I simply apply basic filter from application when report finishes initialization.