Forum Discussion

RajaSadagopan's avatar
RajaSadagopan
Regular Visitor
2 years ago
Solved

Dynamic RLS with embedding

Hi, So I have embedded a powerbi report in another web application. To view the report, user needs to login. Now the report has data for all departments. But the logging in user belongs to some sp...
Dynamic RLS
Embedded power Bi server reports into Website
  • lbendlin's avatar
    lbendlin
    2 years ago

    RLS must control the data model. It needs to be applied to a dimension table on the outside of the star schema.

lbendlin's avatar
lbendlin
Icon for Super User rankSuper User
2 years ago
So we embed the report by Service principal

Don't do that? 

 

There are around 30000 users logging into the web application from different domain

From outside your Entra ID?

 

Is your RLS applied to one of the dimension tables? What is it based on? Mapping from userprincipalname to department?