Forum Discussion

GAC's avatar
GAC
New Member
2 years ago
Solved

RLS on Semantic Model

Hi team,    I have a model semantic published on PBI Service where  8 reports are using this model with base. I need apply RLS just on one report, how can I do this? I'm developing RLS rules onde P...
Data Protection
General Comment
Need Help
  • lbendlin's avatar
    lbendlin
    2 years ago

    After you connect to the semantic model, add your RLS table to that report's data model and wire it in.

  • Anonymous's avatar
    Anonymous
    2 years ago

    Hi lbendlin ,thanks for the reply, you are on the right track！

    Hi GAC ,

    Regarding your question, it is possible to create an additional table in power bi desktop that stores the user information, link it to the data table and later publish it to the power bi service. For reports that do not require RLS, they can be created through the semantic model in the power bi service. For reports that require RLS, connect the previously published semantic model in power bi desktop. Create measure and use ‘USERPRINCIPALNAME’ function to filter the data based on the user information stored in the security information table. Finally, the report is published to the power bi service, and the report dynamically filters the data according to the logged-in users.

Anonymous's avatar
Anonymous
Not applicable
2 years ago

Hi lbendlin ,thanks for the reply, you are on the right track！

Hi GAC ,

Regarding your question, it is possible to create an additional table in power bi desktop that stores the user information, link it to the data table and later publish it to the power bi service. For reports that do not require RLS, they can be created through the semantic model in the power bi service. For reports that require RLS, connect the previously published semantic model in power bi desktop. Create measure and use ‘USERPRINCIPALNAME’ function to filter the data based on the user information stored in the security information table. Finally, the report is published to the power bi service, and the report dynamically filters the data according to the logged-in users.