Forum Discussion

vipinkmathews's avatar
vipinkmathews
Advocate III
8 years ago
Solved

data level security

Dear All   I have to prepare a report with the sales details, sales variance of few managers.  Lets assume that it's a column chart with manager names on X axis and Sales Total on Y axis. When I ...
Need Help
  • v-yulgu-msft's avatar
    v-yulgu-msft
    8 years ago

    Hi vipinkmathews,

     

    Suppose there is a [ManagerName] field in fact table, then, you could create role for each of them.

     

    After publishing the report to service, select the ellipse (…) for this dataset, select security, add each manager to corresponding role you created in Power BI Desktop.

     

    For more detailed steps, please see Row-level security (RLS) with Power BI

     

    Best regards,

    Yuliana Gu

v-yulgu-msft's avatar
v-yulgu-msft
Microsoft Employee
8 years ago

Hi vipinkmathews,

 

Suppose there is a [ManagerName] field in fact table, then, you could create role for each of them.

 

After publishing the report to service, select the ellipse (…) for this dataset, select security, add each manager to corresponding role you created in Power BI Desktop.

 

For more detailed steps, please see Row-level security (RLS) with Power BI

 

Best regards,

Yuliana Gu