Power BI Exchange

Please login or click SIGN UP FOR FREE to create your PowerBIUG account to join this user group.
Expand all | Collapse all

Manage Data Security in Power BI Report Server

  • 1.  Manage Data Security in Power BI Report Server

    Posted Apr 16, 2019 12:30 AM
    Edited by William L Apr 16, 2019 04:09 AM
    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
    ------------------------------
    Power Summit (bi) - Post


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

    Gold Contributor
    Posted Apr 16, 2019 04:30 AM
    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
    ------------------------------

    Power Summit (bi) - Post


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

    Posted Apr 16, 2019 09:11 PM
    Thank you for your clarification :)

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

    Power Summit (bi) - Post