With the latest updates Microsoft has released a series of new features for the role management with regard to “Power BI Desktop”. In particular it is also possible for PowerPivot / power bi models manage roles to filter at the row level.
The following article aims to explain how to create and manage roles.
we start from a simple model. in my case i used a test model with some data about Formula 1.
ON power BI desktop:
ON power bi deskto we have to create the roles. The first step is open the manage role window:
- Open Creation model tab
- Selec Manage Roles
To create role:
- Click create
- Define a name fore role
- Select the table that you want to filter
- Add filter:
- hide all the row
- hide the rows based on specific dax formula
- Write the formula
- click save
After the creation of all your roles the final step is publish the power bi desktop model on power bi site.
Power BI site
On power bi site you have to map you power bi user with the new roles. The steps are:
- select “…” in power bi online in the dataset tab on the specific dataset
- click secutiry tab
- Select Roles
- Insert email address
- Click save
After save that you have complete the role creation an now your user can view and use a filter dataset. It’s work with power bi and Analyze in Excel.