web
You’re offline. This is a read only version of the page.
close
Skip to main content

Announcements

News and Announcements icon
Community site session details

Community site session details

Session Id :
Power Platform Community / Forums / Power Automate / Run query query agains...
Power Automate
Unanswered

Run query query against a dataset based on RLS

(0) ShareShare
ReportReport
Posted on by 109

Hi

 

I don't want to turn on global permissions of my dashboard to allow data export, just from one table on one page my dashboard that has less sensitive information.

 

Just to give some context, I have department managers who have access based on the department code, but also team leaders/managers who have access based on who reports to them. Both sets of managers need a report of incomplete online modules so they can inform staff to complete.

 

Is there a way to have a data export based on what has been provisioned to them in RLS? 

Also, I'm hoping to do this in a way that doesn't require the saving of a file, so a formatted CSV table in the body of an email would be prefferable. 

 

I know there are many videos/guides on how to add an export button in Power BI dashboard, was hoping to do this 

 

A) Based on RLS 

B) Table Data formatted in body of an email rather than CSV exports

 

 

Is this version of the export excel button on a Dashboard possible?

Categories:
  • lbendlin Profile Picture
    8,726 Super User 2026 Season 1 on at

    yes, that pretty much describes the essence of RLS.  All exports are restricted by the RLS rules.

Under review

Thank you for your reply! To ensure a great experience for everyone, your content is awaiting approval by our Community Managers. Please check back later.

Helpful resources

Quick Links

Season of Sharing Community Challenge Winners!

Congratulations to our community stars!

Kudos to our 2025 Community Spotlight Honorees

Expanding mentorship, skilling, and AI innovation

Leaderboard > Power Automate

#1
11manish Profile Picture

11manish 315 Super User 2026 Season 2

#2
Mohsin Ali Profile Picture

Mohsin Ali 267

#3
Henil Profile Picture

Henil 115

Last 30 days Overall leaderboard