Get certified in Microsoft Fabric—for free! For a limited time, the Microsoft Fabric Community team will be offering free DP-600 exam vouchers. Prepare now
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
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
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
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....
The first user name should similar with the below "hualong.liu". please ignore my mistake. Thanks
Check out the October 2024 Power BI update to learn about new features.
Learn from experts, get hands-on experience, and win awesome prizes.