RLS Working But Visuals Show Blank Until Location Manually Selected

Hey nimishrao ,

I admit I didn't read it all, but already the problem is here:

The Problem:

1. When users log in with RLS, the location slicer shows a previously selected value (or is blank)
2. All visuals show blank/no data until the user manually clicks their location in the slicer
3. Once clicked, everything works perfectly - data appears and filters correctly

If you save a report on default specific selection, every user will start from that point. Since you filter on location by RLS, just keep it without any selection, then it cannot happen that pre-selected location is different then user's assigned RLS one.

Also, please rebuild this:

• FACT_SALES → DIM_DATE (active, both directions)

Both directions for the calendar is not great idea, you will lose all advantages of built in time intelligence, just keep it Date -> Fact One To Many , single.

Hi nimishrao ,

What’s happening here is pretty common the slicer can hang onto a saved selection that doesn’t match what the user’s RLS permissions allow, so the visuals show up blank at first. RLS only lets users see their permitted locations, so if the slicer is set to a spot they can’t access, nothing shows until they pick a valid location themselves. Easiest fix: save the report with no location selected in the slicer, so RLS handles what’s visible when someone opens the report.

Also, double-check your model relationships. Bidirectional filters on date tables can make things messy and unpredictable, especially when you’ve got multiple fact tables like sales and budget.

It’s usually best to keep the relationships one-way from the date table to the fact tables. To make sure sales and budget both follow the same RLS rule, connect them through a shared location dimension instead of linking each one separately to the RLS table. That way, you can apply RLS to the location dimension and filter both tables together.

If you can’t update the model just yet, you could use USERELATIONSHIP in your measures to temporarily activate the link between the RLS location table and the budget fact table. But for the long run, switching to a shared location dimension and single-direction relationships is the way to go. Once you’ve made those tweaks and cleared any slicer preselection, your visuals should load right away for users under RLS no extra clicks needed.

Thank you.