Row level security RSL in Paginated Reports.

[laganlee]

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