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

Earn a 50% discount on the DP-600 certification exam by completing the Fabric 30 Days to Learn It challenge.

Reply
Razorbx13
Post Patron
Post Patron

RLS Security Issue in Service

Hi all, hopefully you can help me with this issue.  Maybe I missed a step.  I have a simple table with a Security Key and a Username.  Username is email.  I setup a Role to this table and filter as Username = USERPRINCIPALNAME().  In the desktop I us "View as Role" and it works fine.  Filters for my email/username.  I publish to Service and associated my email in the security for the dataset and then Test the Role.  Works fine.  Exit and then go create a report on this dataset.  NO SECURITY APPLIED.  Should it not be working?  Did I miss a step?  This is about as simple as it gets, and is Step 1 in my security process.  Thanks in advance!

1 ACCEPTED SOLUTION
GilbertQ
Super User
Super User

Hi @Razorbx13 


The reason you see all the data is because you created the dataset. And a creator of a dataset will ALWAYS see all the data (or is the administrator of the data)

 

Try and do this with a user who either has viewer role in the app workspace or share it via an App or report and it will apply the RLS.





Did I answer your question? Mark my post as a solution!

Proud to be a Super User!







Power BI Blog

View solution in original post

2 REPLIES 2
GilbertQ
Super User
Super User

Hi @Razorbx13 


The reason you see all the data is because you created the dataset. And a creator of a dataset will ALWAYS see all the data (or is the administrator of the data)

 

Try and do this with a user who either has viewer role in the app workspace or share it via an App or report and it will apply the RLS.





Did I answer your question? Mark my post as a solution!

Proud to be a Super User!







Power BI Blog

Gilbert, thanks this worked!  So for RLS to work, you cannot make the user have Member or Contributor access?  Has to be viewer access?  If so, I assume then Analyze in Excel is out of the question too?

Helpful resources

Announcements
RTI Forums Carousel3

New forum boards available in Real-Time Intelligence.

Ask questions in Eventhouse and KQL, Eventstream, and Reflex.

MayPowerBICarousel

Power BI Monthly Update - May 2024

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

LearnSurvey

Fabric certifications survey

Certification feedback opportunity for the community.

Top Solution Authors
Top Kudoed Authors