Skip to main content
cancel
Showing results for 
Search instead for 
Did you mean: 

Get certified in Microsoft Fabric—for free! For a limited time, the Microsoft Fabric Community team will be offering free DP-600 exam vouchers. Prepare now

Reply
darentengdrake
Resolver II
Resolver II

RLS and Export Underlying Data

Hi,

 

I have created an RLS that disables some users from viewing a measure (which is made out of 2 columns) in a chart. However, when the person exports underlying data, they are able to see the 2 columns, even if they could not see the measure, which defeats the purpose of RLS in the first place. However, if I add another feature that disables them from seeing the 2 columns, other calculations made from the 2 columns will be unavailable.

 

E.g.

  • Measure A uses Column 1 Column 2. RLS prevents some users from seeing Measure A, but when exporting underlying data, Column 1 and Column 2 is visible, which is not wanted
  • Measure B uses Column 1 Column 2 and Column 3.
  • If another RLS is written to prevent people from seeing Column 1 and Column 2, Measure B will be incorrect

 

Is there a way just to make the 2 columns invisible in RLS, even when exporting underlying data, but the data is still taken into all other calculations?

 

1 ACCEPTED SOLUTION
v-diye-msft
Community Support
Community Support

Hi @darentengdrake 

 

That's the limiatation of RLS. https://docs.microsoft.com/en-us/power-bi/desktop-rls#faq

001.PNG

Community Support Team _ Dina Ye
If this post helps, then please consider Accept it as the solution to help the other members find it more
quickly.

View solution in original post

2 REPLIES 2
v-diye-msft
Community Support
Community Support

Hi @darentengdrake 

 

That's the limiatation of RLS. https://docs.microsoft.com/en-us/power-bi/desktop-rls#faq

001.PNG

Community Support Team _ Dina Ye
If this post helps, then please consider Accept it as the solution to help the other members find it more
quickly.
Greg_Deckler
Super User
Super User

I'm pretty sure your are out of luck on this one. 



Follow on LinkedIn
@ me in replies or I'll lose your thread!!!
Instead of a Kudo, please vote for this idea
Become an expert!: Enterprise DNA
External Tools: MSHGQM
YouTube Channel!: Microsoft Hates Greg
Latest book!:
Power BI Cookbook Third Edition (Color)

DAX is easy, CALCULATE makes DAX hard...

Helpful resources

Announcements
OCT PBI Update Carousel

Power BI Monthly Update - October 2024

Check out the October 2024 Power BI update to learn about new features.

September Hackathon Carousel

Microsoft Fabric & AI Learning Hackathon

Learn from experts, get hands-on experience, and win awesome prizes.

October NL Carousel

Fabric Community Update - October 2024

Find out what's new and trending in the Fabric Community.

Top Solution Authors
Top Kudoed Authors