A global variable usable by several reports

[bboy2025]

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 to repeat this rule for each report, and since the value might change, it would necessitate updating it across all 10 reports.

Therefore, I would like to find a way to parameterize this so that it can be utilized by multiple reports. If a change occurs, I could simply update this global variable, and all reports would reflect the change.

I'm considering using Dataflow in Power BI Service for this, but so far, I haven't found a solution

Someone has a tip ?

[Shahid12523 · Accepted solution]

🔹 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]

What 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