Forum Discussion
PhillieB69
8 years agoFrequent Visitor
Dataset security
Hi, Within our company we work with different Business Units. Therefore data should only be visible within that Business unit. We currently have created a report and published it from deskto...
v-yulgu-msft
8 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
Jawed
8 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.