Forum Discussion
Composite Model - Access Restrictions Problem
Hi Anonymous
Thanks for the response.
The model had been created exactly as you wrote:
- Connected to Power BI Dataset (Direct Query)
- Added a table through inserting data (the mode had changed to Mixed)
As for desktop version it is the latest one.
Reading the documentation you refer to I wander how the RLS inheritance really behaves?:
“RLS rules will be applied on the source on which they are defined, but will not be applied to any other datasets in the model.”
Ho does it relate to information got when trying to test security status:
“Any previously defined RLS security is no longer working. You will need to re-create RLS in Power BI Desktop.”
Does ‘not working’ refer only to the new tables in composite model? If so, is there any way to give an access to the summary report based on source report for users who have RLS restrictions set in the source report?
I have the same issue.
This seems like the key question:
"Does ‘not working’ refer only to the new tables in composite model?"
If the existing RLS is transferred, then it is a bit weird that there is no information about it here. But I hope it is. Did you get to test this on your data?
Indeed there is no information about any inherited RLS roles. The manage roles pane is blank:
You can only create the new roles, and only for a newly added tables (not from source model):
In the service, when getting into security option, there is such an information:
All in all, quite confusing.
Regards,
Dariusz
Hi Dariusz
Actually in our case, we have just finished a test of whether the RLS from the original is transferred despite the above message. And our test showed that it was.
So I believe the above message is just the one you get before you add any RLS. And we get it, because we have not added RLS in the tables that was added to the original dataset to create the composite model (we do not need RLS on those). But the message does not mean that the RLS from the original (main) dataset does not work for the composite model. It does.
They could give some more information, but in conclusion, it does actually work. So the answer to "Does ‘not working’ refer only to the new tables in [the] composite model?" is actually "Yes".