Forum Discussion
Dataset security
Hi PhillieB69,
From this document, if you share dataset and report to app workspace members who have edit permissions, the RLS roles will not be applied to them. That is to say users will be able to see all underlying data records.
Regards,
Yuliana Gu
Hi Yuliana,
Thanks for the reply, clear.
So any thought on a possible solution/ workaround? How can we distribute different dataset to different business units? Would it involve apps, content packages or import datasets iso query etc? Or is it simply not possible?
Kind regards,
Philip
- v-yulgu-msft8 years agoMicrosoft Employee
Hi PhillieB69,
Per my knowledge, I didn't find any valid solution or workaround to achieve RLS on dataset. As of now, it look like impossible to achieve such a requirement.
Regards,
Yuliana Gu
- Jawed8 years agoHelper III
I am not an expert so excuse if that makes absolutely no sense. Depending on the size of the data, you should be able to create a new column for each department/unit/function and ask it to only bring the data if the department/unit/function equals X otherwise, "blank".
If the data is huge, it may slow the system but at least that could be a possibility.
- PhillieB698 years agoFrequent Visitor
The column you are referring to is indeed available. The thing is that in the end the whole dataset is available whereas we'd like to share only the data that is relevant to the different departments/ companies. So how to build multiple filtered datasets from a single central dataset