Forum Discussion

shaunwilks's avatar
shaunwilks
Icon for Helper V rankHelper V
7 years ago

Embedded for "User Owns Data" and Role Level Security

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 an...
Need Help
v-diye-msft's avatar
v-diye-msft
Icon for Community Support rankCommunity Support
7 years ago

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's avatar
    shaunwilks
    Icon for Helper V rankHelper V
    7 years ago

    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