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

We've captured the moments from FabCon & SQLCon that everyone is talking about, and we are bringing them to the community, live and on-demand. Starts on April 14th. Register now

Reply
JoeHeraty
Frequent Visitor

RLS and Parameters Issue

Hi everyone,

I’m running into an issue with a visual in my Power BI report that uses RLS (Row-Level Security) and parameters.

The report includes a table of email addresses (used as the principal user field), which connects correctly to two other data tables. RLS is working as expected across the report—except for one bar chart visual that uses parameters in the axis.

Here’s the setup:

  • The X-axis uses a parameter to switch between different measure fields.

  • The Y-axis uses another parameter for slicer-based values.

  • Both parameters are also available as slicers so users can control how the chart displays.

The issue: When a user selects a value from a parameter that isn’t related to user identity, the visual shows totals for all users instead of just their own data. This breaks the RLS logic and exposes data they shouldn’t see.


I’ve tried applying filters at the visual, page, and report level, but nothing seems to restrict the visual to only the RLS-filtered data. It seems like the parameters may be overriding or bypassing the RLS filtering somehow, but I’m not sure why.


Has anyone experienced this before or have any ideas on how to resolve it?

Thanks in advance!

1 ACCEPTED SOLUTION

I managed to fix it through tweaking the relationships from my tables

View solution in original post

3 REPLIES 3
lbendlin
Super User
Super User

When a user selects a value from a parameter that isn’t related to user identity

What does this have to do with RLS?  Shouldn't you implement OLS for that?

I managed to fix it through tweaking the relationships from my tables

I faced the same issue and had it fixed by checking the "Apply security filter in both directions"-box in the relationship editor! 

Helpful resources

Announcements
New to Fabric survey Carousel

New to Fabric Survey

If you have recently started exploring Fabric, we'd love to hear how it's going. Your feedback can help with product improvements.

Power BI DataViz World Championships carousel

Power BI DataViz World Championships - June 2026

A new Power BI DataViz World Championship is coming this June! Don't miss out on submitting your entry.

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.

March Power BI Update Carousel

Power BI Community Update - March 2026

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