Register now to learn Fabric in free live sessions led by the best Microsoft experts. From Apr 16 to May 9, in English and Spanish.
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
Solved! Go to Solution.
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.
Proud to be a Super User!
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.
Proud to be a Super User!
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?
Covering the world! 9:00-10:30 AM Sydney, 4:00-5:30 PM CET (Paris/Berlin), 7:00-8:30 PM Mexico City
Check out the April 2024 Power BI update to learn about new features.
User | Count |
---|---|
114 | |
99 | |
83 | |
70 | |
61 |
User | Count |
---|---|
149 | |
114 | |
107 | |
89 | |
67 |