Forum Discussion

laganlee's avatar
laganlee
Icon for Helper II rankHelper II
3 years ago

Row level security RSL in Paginated Reports.

Hi

I'm stuck on creating Row Level Security for a paginated report.

 

I've followed this:

Set up row-level security in Power BI paginated reports - Power BI | Microsoft Learn

 

 

I set up the query:

 

 

 

 

Which loads the data:

 

 

Which runs the report ok:

From the instructions of the Microsoft website:

I set up the Filters:

 

 

Next, I add the parameters:

I got stuck at this bit:

 

As my query is this:

So I changed "Beer" to @UserID

And I get this error when validating:

 

So I added a parameter:

 

However, when I run the report, I get this error:

 

 

 

So would anybody know how to set up RSL for Paginated Reports?

 

Many thanks for looking

No RepliesBe the first to reply