Assigned Roles missing from datamart after scheduled refresh

[mz_1122]

Did anyone experience missing assgined roles from datamart after refresh? This happened to me 3 days in a row. On day 1 post refresh i thought i missed out the assign step and turned out to seems to be a bug.

I have 4 datamart, this happen to 2 of my datamarts, every morning after the refresh, end user will come looking for me asking why they are not able to access the report, turn out their email are no longer in their assigned roles under the  'Manage security roles' -->'Assign'  in datamart.

I even make sure the succesfully assigned message is out til i assign the next role. But yet still missing the following day after scheduled 

[v-yangliu-msft]

Hi  @mz_1122 ,

In general, if your RLS is set up using Username(), then this should not happen, and you can check the following questions.

Have you added any other sources in your model?

The affected user's Active Directory account appears to have changed; you can have your administrator write a Power Shell script to view the AD properties of that user.

Get-ADUser (ActiveDirectory) | Microsoft Learn

You can also check for restrictions:

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

Best Regards,

Liu Yang

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