Power BI Apps without Explore Tab

1) Apply RLS so users only ever see their own rows

2) Precompute global averages in:

• Power Query
• SQL
• Dataflow

3) Store them in a separate table not affected by RLS

4) Use that table for the “global averages” visuals

Hi Ignacio_Arjona 

You apply RLS so users can only ever see their own detailed rows, which fully protects the dataset from Explore, exports, and other access paths. Global averages are then calculated upstream (in SQL, Power Query, or a dataflow) and stored in a separate, pre-aggregated table that is not affected by RLS. That table is used exclusively for overall or benchmark visuals, while the RLS-protected table is used only for personal views. This clean separation between secure detail data and safe aggregated data is the only supported way to meet both privacy and reporting requirements.