Is there a way to restrict viewing rights for specific users?

[Anonymous]

I am now building a report for budgeting purposes. The dataset contains all the data for all the different cost centers, and I would like to restrict access so that only the manager of any specific cost center can see their data. 

The way we did it in the past was with a huge excel file and a lot of copy pasting. I know I could just create a few different reports, but I do not find it an elegant solution. 

Is this possible?

[amitchandak · Accepted solution]

@Anonymous , Have already explored RLS?

RLS - Row Level security
https://community.powerbi.com/t5/MBAS-Gallery/Microsoft-Power-BI-Unleash-row-level-security-patterns-in-Power/td-p/712613
https://radacad.com/dynamic-row-level-security-with-organizational-hierarchy-power-bi
https://www.blue-granite.com/blog/using-dynamic-row-level-security-with-organizational-hierarchies

[Anonymous]

Thanks, that is what I need 🙂