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
quyenduong
Helper II
Helper II

Row-Security Level works on Report but not Dataset

Dear community,

 

I set the row security level exactly following instructions and various Youtube videos. These users can see:
✔️ the Report in the correct role (for example, people from Department X can see Report only in that Department X) BUT 
 whenever they open power BI desktop or Excel > connect to Power BI dataset > they can see all of the data from everyone from other departments & all columns. What can I do now to prevent that? 

They should only see the data of their department even when they connect from Power BI Desktop or Excel! 

I set all the steps as follow:

1. On Power BI Desktop > Modeling > Manage roles

quyenduong_0-1679502517908.png

2. Publish the report on the web service

3. On the web: Dataset > Security > put emails of corresponding people to these rows

quyenduong_1-1679502659773.png

4. Click on the Report > Manage permissions > then put emails of corresponding people

quyenduong_3-1679502851660.png

 

Thank you so much

2 ACCEPTED SOLUTIONS
GilbertQ
Super User
Super User

Hi @quyenduong 

 

Are those people also members in the app workspace?

 

If they are remove them from all App workspace roles and try again?





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

Hi @GilbertQ , 

 

I checked and these people I share the Report with are NOT members of the workspace :(( I still do not understand where did it go wrong.

View solution in original post

2 REPLIES 2
GilbertQ
Super User
Super User

Hi @quyenduong 

 

Are those people also members in the app workspace?

 

If they are remove them from all App workspace roles and try again?





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

Proud to be a Super User!







Power BI Blog

Hi @GilbertQ , 

 

I checked and these people I share the Report with are NOT members of the workspace :(( I still do not understand where did it go wrong.

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