Forum Discussion

Anonymous's avatar
Anonymous
Not applicable
3 years ago
Solved

RLS doesn't work with data-export

Hi together,   I have faced the following issue. One user is part of an RLS role and the role works if the user uses the report within an app on PowerBI Service workspace (visuals etc.) But i...
  • v-yueyunzh-msft's avatar
    3 years ago

    Hi , Anonymous 

    Based on my research and understanding on your current issue met, the RLS can be applied to your end-user in the report viewing but lost control when your end-user export the visual to .csv/xlsx file, if I'm understanding correctly, this should be mentioned as by-design in this official documentation:

    Allow users to export data: Even users with the Viewer role in the workspace can export data if they have Build permission on the datasets in that workspace. Read more about:
    Build permission for shared datasets - Power BI | Microsoft Learn

    If you want to avoid the data lost control for the end-users with RLS restricted, here are two methods you can follow,
    One is to remove the build permission for the dataset for this end-user because they can be applied RLS as long as they are "Viewer" access to your Power BI workspace

    Another is to go to the source .pbix file of this report, disable the "Export summarized data" option for this current report and publish the report to the Power BI service again:

    Start in Power BI Desktop.

    1.From the upper left corner, select File > Options and Settings > Options.
    2.Under CURRENT FILE, select Report settings.

    3.Make your selection from the Export data section.

    Please detailed refer to this official documentation:

    Export data from a Power BI visualization - Power BI | Microsoft Learn

     

    Thank you for your time and sharing, and thank you for your support and understanding of PowerBI! 

     

    Best Regards,

    Aniya Zhang

    If this post helps, then please consider Accept it as the solution to help the other members find it more quickly