question Row Leve Security and multiple reports.

[Anonymous]

I have 3 Power Bi reports that I am trying to maintain.  All three reports use the same datasource for the original data.  The three reports are basically the same, the Lite only has 1 page of the normal report.  Export is the same as Normal, but with exporting the visuals enabled

Currently, I have 3 Power Bi reports each with a seperate dataset.  Each report has a RLS setup with the same roles,  Right now, I update each report separately from a data standpoint and a visual standpoint.  

What I am wondering is can I combine all three of the row level security lists into 1 list and use that list for all three reports with the same dataset.

Current setup
Report		RLS		Dataset
Lite		Lite		Lite
Normal		Normal		Normal
Export		Export		Export

Desired Setup
Report		RLS		Dataset
Lite		Combined File		linked to Normal Dataset
Normal		Combined File		Normal
Export		Combined File		inked to Normal Dataset

[Anonymous · Accepted solution]

Hi @Anonymous 

If you want to apply one RLS to multiple reports, you can consider to use SSAS as a data souce and set the RLS in SSAS,then use live connection to connect to the data source, then the RLS you set in SSAS can work and you don't need to create multi RLS, it different from the RLS created in Power BI Desktop, if you want to edit or modify the RLS, you need to edit in SSAS, you can refer to the following link.

Dynamic row-level security with Analysis services tabular model - Power BI | Microsoft Learn

Row Level Security with SSAS Tabular Live Connection in Power BI - RADACAD

Best Regards!

Yolo Zhu

If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.

[Idrissshatila]

hello @Anonymous ,

the thing is that each row level security is defined in each report to each dataset, so it should be done separately per dataset.

[Anonymous]

If I am using a common dataset for all three reports, how would it work?