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

Learn from the best! Meet the four finalists headed to the FINALS of the Power BI Dataviz World Championships! Register now

Reply
Balaraju
Helper III
Helper III

The report can't be viewed because the underlying dataset uses row-level security(RLS)

Hi guys,

 

I have an error in my Report "The report can't be viewed because the underlying dataset uses row-level security(RLS)". I have given workspace access as viewer to the particular user but he is not able to see the report. He is having above error.

 

could you please help me out on this.

 

Thanks,

Bala.

5 REPLIES 5
Energykeith
Frequent Visitor

Make sure that the user is in the security access table.

neoannqi
Frequent Visitor

Hello, I am using the UserPrincipalName() but I receive this warning as a Viewer of the Workspace that I can't view the data due to the underlying RLS. Do I need to do anything?

amitchandak
Super User
Super User

@Balaraju , In the workspace, on the rows of the dataset, using the 3 dots go to security and assign a role to the user, after the viewer will be able to see some data

 

How to use Row Level Security (RLS): https://youtu.be/NfdIA0uS6Nk

Share with Power BI Enthusiasts: Full Power BI Video (20 Hours) YouTube
Microsoft Fabric Series 60+ Videos YouTube
Microsoft Fabric Hindi End to End YouTube

@amitchandak 

 

I was getting the same error but this worked for me.  I really appreciate your guidance.  Thank you!!!

I am facing a similar issue. The idea of using [EMail] = userprincipalname() is so you don't have to add individual users one by one to the report RLS. So there must be another issue as to why the 

[EMail] = userprincipalname() is not working. I have my report in premium workspace - but still get the RLS error as well. Any help appreciated.

Helpful resources

Announcements
Join our Fabric User Panel

Join our Fabric User Panel

Share feedback directly with Fabric product managers, participate in targeted research studies and influence the Fabric roadmap.

February Power BI Update Carousel

Power BI Monthly Update - February 2026

Check out the February 2026 Power BI update to learn about new features.

FabCon Atlanta 2026 carousel

FabCon Atlanta 2026

Join us at FabCon Atlanta, March 16-20, for the ultimate Fabric, Power BI, AI and SQL community-led event. Save $200 with code FABCOMM.