Forum Discussion
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...
🔹 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.
FBergamaschi
Super User
Super UserWhat issue are you encountering with Dataflows?
If this helped, please consider giving kudos and mark as a solution
me in replies or I'll lose your thread
Want to check your DAX skills? Answer my biweekly DAX challenges on the kubisco Linkedin page
Consider voting this Power BI idea
Francesco Bergamaschi
MBA, M.Eng, M.Econ, Professor of BI