Forum Discussion
Assigned Roles missing from datamart after scheduled refresh
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 ...
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.