Sharing pre-filtered dashboard

[SFeldmann]

Hi, I have a challenge with the following use case and I'm hoping somebody could help me. I created an employee scorecard report, that contents all necessary data for all approximately 100 people. The goal is providing every single employee its own (filtered) dataset in a dashboard. At the moment my only - very time consuming- idea is, setting a report filter for each employee, uploading each report to Power BI Service and creating a single dashboard for the employee. Is there any trick or different approach providing a same structured dashboard based on the same dataset for different employees instead of copying pre-filtered reports 100 times? Thanks in advance 🙂 Stefan

[Seth_C_Bauer · Accepted solution]

@SFeldmann Setting a report filter won't be a secure way of only showing each individual their information, they can still interact with the filters.

You should look into Row Level Security, this would allow you to build 1 model/reports for all users.

[mshelar]

Seems the solution only works for Direct query reports .

Is there any solution for Commit querries

I need to show reports by customers and the customer should not be able to see data for other customer.

Any suggestion

[Alexis]

Hi

I have a similar use case except the data is not sensitive so I do not want to use Row Level Security.

Mine is a sales report, where each branch manager will need their own pre-filtered dashboard. Branch managers report to Region Managers, who need their own version.

Probably looking at about 175 dashboards!! Not ideal!!

I don't want to use RLS as a workaround because it's not the right solution for this use case.

Is there another option?

Any help would be very much appreciated!!