Forum Discussion
Power Automate for export report pagined
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
. 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
.rdlfile 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.
10 Replies
. 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
.rdlfile 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,
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!
Bonjour,
Non, je n'ai toujours pas résolu mon problème de RLS sur les rapports paginés 😞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
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.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.
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
