Forum Discussion

PhillieB69's avatar
PhillieB69
Frequent Visitor
8 years ago

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's avatar
v-yulgu-msft
Icon for Microsoft Employee rankMicrosoft Employee
8 years ago

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

  • PhillieB69's avatar
    PhillieB69
    Frequent Visitor
    8 years ago

    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-msft's avatar
      v-yulgu-msft
      Icon for Microsoft Employee rankMicrosoft Employee
      8 years ago

      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's avatar
        Jawed
        Icon for Helper III rankHelper III
        8 years ago

        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.