Find everything you need to get certified on Fabric—skills challenges, live sessions, exam prep, role guidance, and more.
Get startedGrow your Fabric skills and prepare for the DP-600 certification exam by completing the latest Microsoft Fabric challenge.
Hi,
I have a report that has all ours sales advisers details on , however we need to allow each sales adviser to see the report but only see their details and not all the advisers details
Is there away of tenantting the data so it uses e.g. login to show the correct information.
Thank you
Solved! Go to Solution.
Hi @Julian_H ,
You can use row level security to achieve this.
https://docs.microsoft.com/en-us/power-bi/enterprise/service-admin-rls
Did I help you today? Please accept my solution and hit the Kudos button.
Hi @Julian_H ,
You can use row level security to achieve this.
https://docs.microsoft.com/en-us/power-bi/enterprise/service-admin-rls
Did I help you today? Please accept my solution and hit the Kudos button.
Hi,
I have tried the procedure in the document but it doesnt do what I require.
The tabs in my PBI report come from various tables so what I need is that when the user opens PBI they only see their data and not everyone elses as well.
Any ideas ?
I keep getting errors like
I have mutiple joins as I need to use userrelationship in my measures as a manager can be in multiple group types
Cool thank you, I will take a look
Sorry ignore I have duplicated my request
User | Count |
---|---|
84 | |
80 | |
72 | |
71 | |
55 |
User | Count |
---|---|
108 | |
106 | |
93 | |
85 | |
67 |