How to set up permission control(RSL) when different BUs have the same department

[soldier_rong]

Dear All,

Have you encountered the following scenario? I have access control table as the below:

user name	Company	BU	Remark
soldier	AMC;IT	GZ;HZ;CD	The guy can see the data of GZ under the AMC & HZ, CD under the IT(company AMC and IT both contains GZ BU...)

After conversion
user name	Company	BU
hualong.liu	AMC	GZ
hualong.liu	AMC	HZ	unexpected
hualong.liu	AMC	CD	unexpected
hualong.liu	IT	GZ	unexpected
hualong.liu	IT	HZ
hualong.liu	IT	CD
Expectation, actually I can make the access form like that directly
user name	Company	BU
hualong.liu	AMC	GZ
hualong.liu	IT	HZ
hualong.liu	IT	CD

So, how to set up permission control(RSL) when different BUs have the same department - BU?

Meanwhile, if the guy need to access all BU, how you set it? put * in BU column? Thanks for any suggestions

Best Regards,

Soldier

[v-chenwuz-msft]

Hi @soldier_rong ,

Did you mean RLS?

Row-level security (RLS) with Power BI - Power BI | Microsoft Learn

Best Regards

Community Support Team _ chenwu zhu

[soldier_rong]

Hi @v-chenwuz-msft ,

I believe you are Chinese? If so, could we have a short call for this case even though I already came up the solution. Thanks in advance. xiexie.

 BR,

Soldier

[soldier_rong]

Hi @v-chenwuz-msft ,

Thanks for your reply. However, the slution as your mentioned, which can't covert this situation as we have the below scenario.

soldier

AMC;IT

GZ;HZ;CD

The guy can see the data of GZ under the AMC & HZ, CD under the IT(company AMC and IT both contains GZ BU...) split by ";" and change to row.

Based on it, we dont want to let the guy to see the HZ data under AMC. Because the above access setting will show 6 records.... 

[soldier_rong]

The first user name should similar with the below "hualong.liu". please ignore my mistake. Thanks