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

Enhance your career with this limited time 50% discount on Fabric and Power BI exams. Ends August 31st. Request your voucher.

Reply
Giorgi1989
Advocate II
Advocate II

Exporting matrix data to EXCEL (with RLS)

Hi,

 

I would like my end users to be able to export matrix data to EXCEL file. 

 

I have that option enabled, but the problem is that when I click on the 'Export data' and then choose 'Data with current layout', all of the data in its totality gets exported. I have RLS settings for this particular report (visuals, including the matrix), and I want only the filtered fields to be exported.

 

Is this option currently unavailable? Or am I missing something?

 

Thank you. 

3 REPLIES 3
bcdobbs
Community Champion
Community Champion

Have you tested it with an actual end user? RLS is ignored for anyone who has direct access to the workspace above Viewer. 

See the purple notes box in

https://docs.microsoft.com/en-us/power-bi/collaborate-share/service-roles-new-workspaces#workspace-r...



Ben Dobbs

LinkedIn | Twitter | Blog

Did I answer your question? Mark my post as a solution! This will help others on the forum!
Appreciate your Kudos!!
Anonymous
Not applicable

I'm getting this same behavior on some reports but not all. Doesn't matter on the visual type. I do not have RLS enabled.
edit: I'm retracting this.  I was looking at a chart visual which doesn't allow for exporting in this manner which makes sense. Matrix performs as expected.

amitchandak
Super User
Super User

@Giorgi1989 , data export should take care of RLS. If not then it is an issue.

Share with Power BI Enthusiasts: Full Power BI Video (20 Hours) YouTube
Microsoft Fabric Series 60+ Videos YouTube
Microsoft Fabric Hindi End to End YouTube

Helpful resources

Announcements
July 2025 community update carousel

Fabric Community Update - July 2025

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

July PBI25 Carousel

Power BI Monthly Update - July 2025

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