Forum Discussion

bboy2025's avatar
bboy2025
New Member
1 year ago
Solved

A global variable usable by several reports

Hi everyone,   I have 10 reports that require RLS (Row-Level Security) configuration. In the RLS rules, I need to specify a value (e.g., Column 1 = 'France').   The challenge is that I would have...
Need Help
  • Shahid12523's avatar
    Shahid12523
    1 year ago

    🔹 Create a Dataflow with a table like RLS_Config containing your target value (e.g., 'France').
    🔹 Connect each report to this Dataflow and use DAX to pull the active value
    VAR SelectedCountry =
    LOOKUPVALUE(RLS_Config[Country], RLS_Config[IsActive], TRUE)
    RETURN Table[Column1] = SelectedCountry


    🔹 Update the Dataflow once, and all reports will reflect the change on refresh—no need to edit each report individually.

Shahid12523's avatar
Shahid12523
Community Champion
1 year ago

🔹 Create a Dataflow with a table like RLS_Config containing your target value (e.g., 'France').
🔹 Connect each report to this Dataflow and use DAX to pull the active value
VAR SelectedCountry =
LOOKUPVALUE(RLS_Config[Country], RLS_Config[IsActive], TRUE)
RETURN Table[Column1] = SelectedCountry


🔹 Update the Dataflow once, and all reports will reflect the change on refresh—no need to edit each report individually.