Advanced use (RLS + Token)

Regarding RLS, you can replicate it on our playlists.

Keep in mind that using RLS with PowerBI Robots requires service principal and PowerBI Embedded capacity or Premium.

Depending on the type of Role (static or dynamic) you'll need to fill in the values for the Row-level:

If you are using a static role, where the filter value is always the same (see example):

You just need to fill in only the 'Row-level Role' the value for the Role (eg. ManagerCanada or ManagerJapan). Automatically the data will be filtered to that Role.

If you are using dynamic roles, where the input value can vary (eg. using the function userprincipalname( ) to filter the data for each user account):

You'll need to fill in both Row-Level Role and Row-Level User:

Row-Level Roles is the Role name (eg. shown is UserRole), and on Row-Level User you need to input the value.

Note: You can use the default token #RECIPIENT_EMAIL# to dynamically replace the values for the Row-Level Users, with the playlist recipients' email.

Also, you can use custom tokens on the Row-Level Roles and/or on the Row-Level Users.

And replace them where you desire:

Token on Page/Report Filter:

In this case, a default token was used to filter the page for the current year - token #YEAR# which always returns the current year.

To use them simply click on Token and apply the selected token where you want.

Custom tokens can also be used.

Token use on Playlist:

You can reuse tokens anywhere in the playlist configuration. Filename, Email Subject, Email message: