cancel
Showing results for 
Search instead for 
Did you mean: 
Reply
stixenstonz
New Member

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

Hi,


I have a simple 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

 

stixenstonz_0-1638360969781.png

 

However, whenever I define the RLS section

stixenstonz_1-1638361075730.png

 

stixenstonz_2-1638361128787.png

 

This in theory should work as per the post : https://www.mssqltips.com/sqlservertip/6993/power-bi-email-reports-power-automate-rls/

 

Then I get the following message :

stixenstonz_3-1638361224032.png

 

 

Is this functionality of RLS in the Paginated Reports really not supported? If so, then it makes me surprised why you can input those values in the box 😉 so I'm wondering if there is any workaround or suggestion what can I do to further investigate and deblock the subject.

 

Thanks in advance

Stan

 

1 ACCEPTED SOLUTION
stixenstonz
New Member

So basically it turns out you need to fill in only the username. Resolved!

View solution in original post

1 REPLY 1
stixenstonz
New Member

So basically it turns out you need to fill in only the username. Resolved!

View solution in original post

Helpful resources

Announcements
Power BI December 2021 Update_carousel 768x460.jpg

Check it Out!

Click here to read more about the December 2021 Updates!

Jan 2022 Dev Camp 768x460 copy.png

Power BI Dev Camp- January 27th, 2022

Mark your calendars and join us for our next Power BI Dev Camp!

UG GA Amplification 768x460.png

Launching new user group features

Learn how to create your own user groups today!

Top Kudoed Authors