Is it possible to export Paginated Report from Logic App enforcing Row Level Security

Bhavya Shah 25 Reputation points
2025-01-06T14:55:11.91+00:00

Hello,

I am trying to export a Paginated Report (Power BI) from Azure Logic App. I am using the Export To File for Paginated Reports Logic App Action for this. I am able to export the report without enforcing RLS. But I want to export the report by enforcing RLS.

Export To File for Paginated Reports supports Identity.

I want to achieve something similar to what has been described here: https://learn.microsoft.com/en-us/power-bi/developer/embedded/paginated-reports-row-level-security#use-userid-as-a-filter-at-report-or-query-level

So, I create an access token using the Generate Token REST API endpoint passing my desired filter in the username. I get token in the response. I pass the same token to the Identity.username in the Export To File for Paginated Reports Action. But it gives an error "User not found in the organization".

Identity.Username documentation states: The effective username within a token that applies row-level security rules.

Not Monitored
Not Monitored
Tag not monitored by Microsoft.
40,928 questions
{count} votes

Your answer

Answers can be marked as Accepted Answers by the question author, which helps users to know the answer solved the author's problem.