Power BI Exchange

Expand all | Collapse all

Manage Data Security in Power BI Report Server

  • 1.  Manage Data Security in Power BI Report Server

    Posted 6 days ago
    Edited by William L 6 days ago
    Hi everyone,
    What is the best practice to manage data security using Power BI Report server?

    What I am trying to do is to implement RLS to the table (referring to Row-level security (RLS) in Power BI Report Server - Power BI) in the following table.:

    Region;User
    -------------------
    America;User1
    Asia;User1
    Europe;User2

    When I uploaded the pbix to the report server and opened the report via browser, User1 could only see America and Asia; but when I choose to download pbix, I could see all Regions' data, since I have the option to manage the Roles.

    Is it an expected behaviour, or is there a way to restrict User1 from viewing all Regions in the downloaded pbix?

    ------------------------------
    W
    ------------------------------


  • 2.  RE: Manage Data Security in Power BI Report Server

    Gold Contributor
    Posted 6 days ago
    you cannot restrict user on downloaded file or at desktop. User will view all the data.
    If you want to restrict it .

    - Deploy the report on Server.
    - Add user as "Browser" role so that user cannot download the file.

    A restricted user should not download PBIX, this should be the default behavior. :)

    ------------------------------
    Farhan Ahmed
    Senior Business Intelligence Consultant
    Xerva
    karachi
    3452523688
    ------------------------------



  • 3.  RE: Manage Data Security in Power BI Report Server

    Posted 5 days ago
    Thank you for your clarification :)

    ------------------------------
    W
    ------------------------------