Forum Discussion
RLS in Power BI and Excel
Hello,
When I create a report in Power BI Desktop and use RLS by creating roles with the USERNAME () function,
Then I share this report in Service Power Service BI and also share it with different users
If user exports the data from visualization to an Excel file, will he only see this data ??
Thank's
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.
2 Replies
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.