Create Filtered Dashboards without Showing the filter

[iqb]

I have a report (pbix) which include around 30 pages. I published this report and created a dashboard which I can call it Global Dashboard and share this dashboard with relevent peoples.

Now I wanna create the same dashboard again but with filtered data and share with relevent stakeholders. So, each stakeholder should only have permission to view his data.

For example, I have a report with all department data. I have created a dashboard with all department data and shared with relevant peoples. Now, Department A (let's say) also wanna see same dashboard but filtered with Department A data. Similarly, Department B wanna his own dashboard with thier data and so on.

Do I need to create seprate reports (or pages) for each depertment that filter thier data and then create dashboard from this or there is any easy way?   

[Shaurya · Accepted solution]

Hi @iqb,

You need to implement Row Level Security in your reports. Creating multiple dashboards with filters is not the best possible solution. Here's a link for your reference: 

https://learn.microsoft.com/en-us/power-bi/enterprise/service-admin-rls

Did I answer your question? Mark this post as a solution if I did!
Check out this blog of mine: How to Export Telemetry Data from Azure IoT Central into Power BI