Power Automate for export report pagined

Sylvine_Wyz 

. Make Sure RLS is Set Up in Your Dataset

• Go to your dataset in Power BI service.

• In Dataset Settings → Security, define your RLS roles and assign users to each role.

• RLS must be defined and active before subscriptions will respect it.

2. Upload Your Paginated Report (.rdl)

• Upload your .rdl file to Power BI Service → Paginated Reports section.

3. Create a New Subscription

• Open the paginated report in Power BI Service.

• Click on the “Subscribe” button at the top.

• In the subscription panel:

  • Choose email recipients.

  • Select report format (PDF, Excel, etc.).

  • Configure the schedule.

🔐 Important: Enable RLS in Subscription

In the subscription panel, look for a checkbox like:

"Use my credentials and apply row-level security filters"

Or: "Send report content based on each user's permissions"

👉 Make sure this box is checked if you want Power BI to apply RLS rules per user.

Hi Sylvine_Wyz,

Power BI subscriptions cannot apply RLS for external users outside your organization. That’s why you’re not seeing the “Apply RLS” option in the subscription panel. This feature is only available for internal users with proper licensing and RLS role assignments.

To meet your need--sending a personalized XLSX paginated report to external users, we recommend using Power Automate with the “Export to File for Paginated Reports” action. This method lets you:

• Loop through a list of recipients and their filter values (e.g., region, email)
• Export the report with parameters (simulating RLS)
• Email each recipient their filtered report securely.

This requires Power BI Premium or Premium Per User (PPU).

Please Accept as solution if this meets your needs and a Kudos would be appreciated.

Thank you.