Power Automate for export report pagined

[Sylvine_Wyz]

Hello every body,

I want to send a pagined report automatly by email with RLS
But I don't know that : 

can you help me please ?

thanks in advance

have a nice day

[johnbasha33 · Accepted solution]

@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.

[Sylvine_Wyz]

@johnbasha33 
In fact, I created a paginated report from a dataset that includes RLS.
I must send the pagined report in xlsx by email to users external to the organization every month.
But users need to see their data only.

[v-sgandrathi · Accepted solution]

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.

[Sylvine_Wyz]

Hello @v-sgandrathi 

Thanks for your return.
I try to make this in power automate.
But in my screenshot, i don't know that i must to writte in "IdentityBlob Valeur BLOB - 1"

What is this ? 

Thanks in advance.

Have a nice day

[v-sgandrathi]

Hi @Sylvine_Wyz ,

Sure! In the "IdentityBlob Valeur BLOB - 1" field, you need to paste a valid OAuth2 access token for SQL Azure. This token allows Power Automate to authenticate and apply Row-Level Security (RLS) when exporting the paginated report. You can generate this token using Azure AD credentials.

Thanks for reaching out! If this answer was helpful, please consider marking it as Accepted Solution and giving a Kudos, it helps the community!

[v-sgandrathi]

Hi @Sylvine_Wyz ,

May I ask if you have gotten this issue resolved?

If it is solved, please mark the helpful reply or share your solution and accept it as solution, it will be helpful for other members of the community who have similar problems as yours to solve it faster.

Thank you.

[v-sgandrathi]

Hi @Sylvine_Wyz,

Has your issue been resolved?If the response provided by the community member addressed your query, could you please confirm? It helps us ensure that the solutions provided are effective and beneficial for everyone.

If yes, kindly accept the useful reply as a solution and give us Kudos. It would be appreciated.

Thank you for your understanding!

[Sylvine_Wyz]

Bonjour, 

Non, je n'ai toujours pas résolu mon problème de RLS sur les rapports paginés 😞

[v-sgandrathi]

Hi @Sylvine_Wyz,

Paginated report subscriptions in Power BI do not natively support Row-Level Security (RLS) as standard reports do, which is why the enablement option is unavailable.
For internal users with Power BI Premium or Premium Per User (PPU) licenses, you can set up RLS roles within the dataset, publish the paginated report to a Premium workspace, and subscriptions will adhere to those roles.
However, for external users or environments without Premium, RLS through subscriptions is not available. In these cases, you can design your paginated report to use parameters such as region, email, or user ID, and leverage Power Automate’s “Export to File for Paginated Reports” action.
This allows you to iterate through your recipient list, apply the appropriate parameter for each user, and send them a personalized report, thereby replicating RLS functionality.

Thank you.

[johnbasha33 · Accepted solution]

@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.

[Sylvine_Wyz]

Hello @johnbasha33 
thanks for your return

I don't find the case for to active the RLS :