Tenants in PBI Reports

[Julian_H]

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

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

[Julian_H]

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 ?

[Julian_H]

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

[Julian_H]

Cool thank you, I will take a look

[Julian_H]

Sorry ignore I have duplicated my request