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 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 ?

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.

2 Replies

  • 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.