Forum Discussion
RLS in Power BI and Excel
Yes it should only give them what they can see. When you export to Excel from a visual, you're not exporting the records behind the calculations in the visual; you're exporting the specially created table of values and labels that generate the visual itself. So for instance if you have a count of sales receipts by day plotted on a line chart, and you export to Excel from that chart, you won't get a table of receipts by date. You'll get a table of dates with count values.
Export also inherits any other temporary filters in play. So if you have a category slicer on the page and you make a selection there, exporting from that same line chart will only give you the sliced result. RLS is really just a fancy slicer on the back end of your data model, so it should work the same way.
Yes it should only give them what they can see. When you export to Excel from a visual, you're not exporting the records behind the calculations in the visual; you're exporting the specially created table of values and labels that generate the visual itself. So for instance if you have a count of sales receipts by day plotted on a line chart, and you export to Excel from that chart, you won't get a table of receipts by date. You'll get a table of dates with count values.
Export also inherits any other temporary filters in play. So if you have a category slicer on the page and you make a selection there, exporting from that same line chart will only give you the sliced result. RLS is really just a fancy slicer on the back end of your data model, so it should work the same way.
Old post, but I have a similar issue.
I have implemented RLS, and when users export underlying data (not summarized) they get access to ALL data. Any ideas?