Limit system users to see only their content in PowerBI embedded report

[CyberiX]

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?

[CyberiX]

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.

[v-jiascu-msft]

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

[CyberiX · Accepted 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.