Dynamic Filtering

[ms]

Hi,

we are currently doing an assessment of an existing set of SAP BO reports with a view to migrate them to PowerBI.

Most of these can be migrated as per our assessment till now. However there are a few in there that are what in SAP BO is know as 'Publication'.

Let me explain: Take a use case where a manager is shown his team members who are due to complete an important training in the next 30 days. In SAP BO they have created a generic report that has ManagerName, team member name, training name,department name, training due by date etc for the entire company etc. But with the SAP BO Publication feature applied to this report, the manager sees only his team members status , not of any other employee.

How can we achieve a similar feature in PowerBI i.e create a generic report but then filter it on the loggedon user? Is this possible at all?

Thanks

[v-danhe-msft]

Hi @ms,

Could you please tell me if your problem has been solved? If it is, could you please mark the helpful replies as Answered?

Regards,

Daniel He

[v-danhe-msft · Accepted solution]

Hi @ms,

Based on my research, you could use the RLS function in Power BI, it can be used to restrict data access for given users. Filters restrict data access at the row level, and you can define filters within roles. 

Reference:

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

Regards,

Daniel He