Forum Discussion

Anonymous's avatar
Anonymous
Not applicable
3 years ago
Solved

Urgent - Issue with RLS when updating dataset

Hi all,

 

We have a report that is used by different departments in the company. In this report we have different user dimension tables that we use to manage RLS where TableDep[email] = username().

 

Just today we changed the dataset for the report, the underlaying data is the same, we made sure of having same names, relationships, etc (although steps in transform data are different). But the source has moved to dataflows instead of excel/sql.

 

After updating the dataset (we uploaded with same name so the old one would be replaced), the users cannot see any data at all. We are guessing it's because something 'broke' regarding rls but we cannot find anything weird.

Has anyone experience something similar? Any ideas of what could be happening?

 

Much appreciated, thanks!

Need Help
  • Anonymous's avatar
    Anonymous
    3 years ago

    Hi Anonymous ,

     

    After passing my tests, when I update the data source, the rls rules will disappear, even though the role is still saved.
    Please check that the RLS rules in Desktop and the rules in Service still exist after you update the dataset.
    If it doesn't exist, refer to the documentation to reconfigure and publish on dsektop and then assign on the service.

     

    Best Regards,

    Neeko Tang

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

4 Replies

  • Anonymous's avatar
    Anonymous
    Not applicable
    3 years ago

    That seemed to work! Thanks!

  • Anonymous's avatar
    Anonymous
    Not applicable
    3 years ago

    Hi Anonymous ,

     

    After passing my tests, when I update the data source, the rls rules will disappear, even though the role is still saved.
    Please check that the RLS rules in Desktop and the rules in Service still exist after you update the dataset.
    If it doesn't exist, refer to the documentation to reconfigure and publish on dsektop and then assign on the service.

     

    Best Regards,

    Neeko Tang

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

  • Anonymous's avatar
    Anonymous
    Not applicable
    3 years ago

    Hi Anonymous , thanks a lot for your reply. I can confirm that the rules still exist in desktop and that the user's email are still aded in the rls online.

    Should we try deleting and reapplying the rules?