Error in Flow with Export Paginated Report to email fails when using RLS

[stixenstonz]

Hi,

I have a simple flow to export a Paginated Power BI Report (using PBI Dataset on dedicated capacity).

I am able to perform the plain export and sending via e-mail, it goes successfully

However, whenever I define the RLS section

This in theory should work as per the post : https://www.mssqltips.com/sqlservertip/6993/power-bi-email-reports-power-automate-rls/

Then I get the following message :

Is this functionality of RLS in the Paginated Reports really not supported? If so, then it makes me surprised why you can input those values in the box 😉 so I'm wondering if there is any workaround or suggestion what can I do to further investigate and deblock the subject.

Thanks in advance

Stan

[GiorgiPBI]

Hello, did you solve it? got the same issue.

[JoswinPowerBi]

I follow your steps but it give me this error:

"code": "InvalidRequest", "message": "Exporting a paginated report with an effective identity with datasets is not supported"

}

[stixenstonz · Accepted solution]

So basically it turns out you need to fill in only the username. Resolved!

[Prateek97]

I am unable to export paginated reports when RLS is applied on the dataset. Does anyone has any idea?