Forum Discussion
Microsoft EmployeeShare your thoughts on DirectQuery for Power BI datasets and Azure Analysis Services (preview)
Hi,
I've a scenario where we've country master dataset where row level security is applied to restrict data based on the user's location. We've using this master dataset as a source for another dataset using direct query but the RLS applied isn't getting propagated. Is this by design or a limitation of this feature?
- jeroenterheerdt
RLS does not flow from the remote to your local model. This is by design. Thanks for providing the feedback, though.
Thanks for the prompt reply. So in a use case like this, I assume using dataflows might be the next best option? Also, are there plans of introducing RLS from remote models to local in the pipeline?
- jeroenterheerdt
we are looking at the RLS to local thing, but it's a lot of work and to be honest, not a lot of people have asked for it. Please vote on it on ideas if you want this to happen. Dataflows could be a option for you.
Set up RLS on each individual model and everything will function as you are expecting.
I don't get the option to apply RLS on country table (coming from remote model/dataset) in my composite model. The table name doesn't appear when defining RLS rules in Power BI desktop. I'm not sure if I'm missing anything?
