Skip to main content
cancel
Showing results for 
Search instead for 
Did you mean: 

To celebrate FabCon Vienna, we are offering 50% off select exams. Ends October 3rd. Request your discount now.

Reply
elfzanajahabara
Frequent Visitor

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

Hi everyone,
I have a 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

elfzanajahabara_0-1687927475871.png
Thank you T.T

 

2 REPLIES 2
elfzanajahabara
Frequent Visitor

Thank You.
I can export if i not have RLS but I want to export filter data each employee and send email by employee.

AmosHersch
Microsoft Employee
Microsoft Employee

Hi @elfzanajahabara ,

 

As far as I know you can't export a paginated report which has a PBI Dataset as a data source when the dataset has RLS (requires identity). There's some security concern regarding this scenario. Without passing the effective identity for the dataset I believe it should work.

Helpful resources

Announcements
September Power BI Update Carousel

Power BI Monthly Update - September 2025

Check out the September 2025 Power BI update to learn about new features.

August 2025 community update carousel

Fabric Community Update - August 2025

Find out what's new and trending in the Fabric community.