Embedded for "User Owns Data" and Role Level Security

[shaunwilks]

Any help that can be provided here would be helpful.

We have written an API working well using the User Owns Data model. 

We pass the solution the PBI user name and password, the clientId etc and teh report name and can view the report without any issues.

Now we are wanting to extend the API and pass the "Role Name" to the API - but it would appear we are unable to ....

Row-level security (RLS) can be used to restrict user access to data within dashboards, tiles, reports, and datasets. Different users can work with those same artifacts all while seeing different data.

Embedding supports RLS. If you're embedding for non-Power BI users (app owns data), which is typically an ISV scenario (Not Us), then this article is for you! Configure the embed token to account for the user and role.

(US) If you're embedding to Power BI users (user owns data), within your organization, RLS works the same as it does within the Power BI service directly. There's nothing more you need to do in your application. For more information, see Row-Level security (RLS) with Power BI.

What I am wanting to provide the flexibility is that when I open my Reports from my PBI account I wish to pass a ROle that filteres the report. I wish to have different options from the menu that essentially replicate the "View As Role" feature in PBI but I pass it programattically before the report options to apply pre-configured filters.

What I want to avoid is having to publish the same report dozens of times under different names that has the filters applied.

The reports are all for my use and I dont want to have to select filters inside the report.

Id like to preset the filters in RLS and then pass role names to the report via the User Owns Data model.

Can the community be of any assistance to assist me in this endeavour ?

Why would it work with one model and not another ?

[v-diye-msft]

Hi @shaunwilks 

“What I am wanting to provide the flexibility is that when I open my Reports from my PBI account I wish to pass a ROle that filteres the report. I wish to have different options from the menu that essentially replicate the "View As Role" feature in PBI but I pass it programattically before the report options to apply pre-configured filters.”

Do you mean below option? 

Dataset>Security:

"Id like to preset the filters in RLS and then pass role names to the report via the User Owns Data model."

Did you try to set the dax function in the data model when setting RLS?

[shaunwilks]

No not quite. Im familiar with RLS and can setup multiple Roles etc.

This is specifc to the PowerBI API.

The API opens the report for the user - If using embedded reports where the User Owns data you cannot pass the role name (which in turn filters the report). Instead it relies on the user opening the report.

I was seeking an alternative option within the API that presets "Report" level filters so to avoid having to change options in the filter tab each time