Exporting matrix data to EXCEL (with RLS)

Question

Hi,&nbsp;I would like my end users to be able to export matrix data to EXCEL file.&nbsp;&nbsp;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.&nbsp;Is this option currently unavailable? Or am I missing something?&nbsp;Thank you.&nbsp;

amitchandak · Answer

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

anonymous · Answer

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.&nbsp; I was looking at a chart visual which doesn't allow for exporting in this manner which makes sense. Matrix performs as expected.

bcdobbs · Answer

Have you tested it with an actual end user? RLS is ignored for anyone who has direct access to the workspace above Viewer.&nbsp;
See the purple notes box in
https://docs.microsoft.com/en-us/power-bi/collaborate-share/service-roles-new-workspaces#workspace-roles

Forum Discussion

Exporting matrix data to EXCEL (with RLS)

3 Replies

Related content

Exporting a matrix visualization layout to Excel

schedule excel export

Error When Exporting Matrix Table in Excel

Powerbi Export to Excel Option

Export In Excel