Register now to learn Fabric in free live sessions led by the best Microsoft experts. From Apr 16 to May 9, in English and Spanish.
Hi All,
I have user,application,role information my table,
while user seeing a report there is a validation need to be implemneted like
if the user is Admin for particular application he can see alll data related to that application and he is other then Admin he needs to see only his related data.
for data reference i am attaching screen print.
how can i achieve this scanario,please help me on this case.
Regards
Msudulag
So there is another table which includes the user emails, which has relationship with this table?
Maybe we need to create a crossjoin table using the USER_NAME and APPLICATION_NAME columns, then create another column to identify if this row is visible to current user.
Best Regards,
Herbert
Hi @v-haibl-msft,
Can you please suggest how can i achieve this requirement.
can you give any examples.
Regards
Msudulag
Hi @v-haibl-msft,
Thanks for your reply,
Actuyally these are three tables(Users,Applications and Role),i have combined and made it one,now i need to check the conditiondtion from here only.
I am attaching screen print of my model,Please verify once ,
let me know if you need any information.
Regards
Msudulag
Covering the world! 9:00-10:30 AM Sydney, 4:00-5:30 PM CET (Paris/Berlin), 7:00-8:30 PM Mexico City
Check out the April 2024 Power BI update to learn about new features.
User | Count |
---|---|
111 | |
100 | |
80 | |
64 | |
58 |
User | Count |
---|---|
148 | |
111 | |
93 | |
84 | |
66 |