Power BI is turning 10! Tune in for a special live episode on July 24 with behind-the-scenes stories, product evolution highlights, and a sneak peek at what’s in store for the future.
Save the dateEnhance your career with this limited time 50% discount on Fabric and Power BI exams. Ends August 31st. Request your voucher.
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.
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
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.
User | Count |
---|---|
25 | |
11 | |
8 | |
6 | |
6 |
User | Count |
---|---|
30 | |
13 | |
11 | |
9 | |
6 |