Row Level Security with Paginated Report on Power BI Dataset

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