Row Level Security with Paginated Report on Power BI Dataset

[Anonymous]

I was looking at RLS in paginated Report.
I have a Power BI Dataset that feeds as a data source to Paginated report.
I like to asked where would RLS sit? In the Power BI Dataset or Paginated Report.

I also want to let you know that the RLS is based on Userid  and this Userid is link to Group Product. For example, Furniture, Machine and Food. I have a table called user which consist of userid, username and the Group Product the users reside - as shown below

My question are:

1. where do RLS sit (Power BI dataset or Paginated Report)?

2. how to configure the group product using userid when user log on power bi services?

[MallikarjunaBan]

Hi @Anonymous  is the userid working with out any issues so it picks the name from power bi service properly please share some supporting docs with proper info thank you and help would be very much appreciated

[Anonymous · Accepted solution]

Hi @Anonymous,

Please review the following links, hope they can help you achieve your requirement.

RLS in Paginated Reports - User cannot view

1. Create a dataset and set RLS in Power BI Desktop

2. Connect to the dataset with Power BI Report Builder

Row Level Security on a Paginated report

RLS is now only available on the report server or database side; it is not possible to use RLS on a paginated report. We can embed the paginated report here, and you can control which data is displayed when you embed a paginated report. This allows for user-specific information to be presented. If you have a Power BI paginated report with global sale data, for example, you may embed it so that only the sale results from a certain region are displayed.

This feature allows you to display a subset of data in a secure manner without compromising the rest of the data. It's similar to the Row Level Security feature in Power BI reports (that aren't paginated), dashboards, tiles, and datasets, which gives a secure manner of showing data.

You must give a Perameter to the UserID attribute when providing row-level security to a Power BI paginated report. Before the report is embedded, this parameter will limit the data collected from the dataset.

Implementing row-level security in embedded paginated reports

Best Regards