Central NJ Power BI User Group

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

Row Level Security simple example

  • 1.  Row Level Security simple example

    Gold Contributor
    Posted Feb 26, 2019 08:21 AM
    Edited by Jerome Scriptunas Feb 26, 2019 02:37 PM
    Here is a simple example of using Row Level Security to display a PBI report that displays only the items that a user entered in a SharePoint Online list and not items entered by other users.

    1) Create a Role in Power BI Desktop.
    Go to the Modeling ribbon and click Manage Roles
    thumbnail image
    2) Publish the report to the PBI service.
    Under DATASETS (left panel) click the ... to the right of the dataset you are working with and select "Security".
    Then add the people or groups to the Role.
    thumbnail image

    3) Example of items entered by the user "youth"
    thumbnail image

    Example of items entered by the user "demo"
    thumbnail image



    ------------------------------
    Jerome Scriptunas
    Central NJ PUG
    ------------------------------