Set up row-level security in Power BI paginated reports

APPLIES TO: Power BI Report Builder Power BI Desktop

This article explains how to set up row-level security (RLS) for paginated reports in Power BI. If your paginated report is based on a Power BI dataset, the article Row-level security (RLS) with Power BI provides a solid background.

To use RLS in a paginated report, you first create parameters in that report. Then you take advantage of the built-in field UserID:


License requirements for Power BI paginated reports (.rdl files) are the same as for Power BI reports (.pbix files).

  • For row-level security (RLS) to work in Power BI Report Builder, You need at least a Viewer role in the dataset workspace, and Build permission for the dataset. Read about roles in workspaces.
  • You create paginated reports using the SQL Server Reporting Services engine, and not the Power BI (Analysis Services) engine, so you set up RLS filtering in Power BI Report Builder.

Create a parameter using UserID

To apply row-level security to a Power BI paginated report, the first step is to create a parameter and assign the built-in field UserID. See the article Create parameters if you need help creating them.

Then you use this parameter with UserId in a filter or in a query to the data source.

Use UserID in a filter

  1. In the Dataset Properties window, from the left pane, select Filter.

    Screenshot of the Power BI Report Builder filter.

  2. From the Expression dropdown menu, select the parameter you want to use for filtering the data.

    Screenshot shows the value Color selected from the Expression menu.

  3. Select the Value function button.

    Screenshot shows Power BI Report Builder value.

  4. In the Expression window, from the Category list, select Built-in Fields.

    Screenshot shows the Expression window with Built-in Fields selected as Category and ExecutionTime selected as Item.

  5. From the Item list, select UserID > OK.

    Screenshot shows Power BI Report Builder UserID.

  6. In the Dataset Properties window, verify that the expression is your selected parameter = UserID.

    Screenshot shows Power BI Report Builder dataset properties.

  7. Select OK.

Use UserID in a query

  1. In the Dataset Properties window, from the left navigation pane, select Parameters, then select Add.

    Screenshot shows Power BI Report Builder parameters.

  2. In the Parameter Name field enter @UserID, and in the Parameter Value add [&UserID].

    Screenshot shows Power BI Report Builder parameter name.

  3. From the left pane, select Query. In Query, add the UserID parameter as part of your query.

    This screenshot uses the color parameter as an example *(WHERE FinalTable.Color = @UserID)*. If needed, you can create a more complex query.

    Screenshot shows Power BI Report Builder queries edit.

  4. Select OK.

Next steps

Power BI Report Builder