Forum Discussion

gk124's avatar
gk124
Frequent Visitor
2 years ago

Row Level security not working in power bi service while its working in desktop version

Hi All,   I have created a dashboard which shows the number of covers given to each person while they are on leave and the report is getting RLS function working while checking the view role option...
Need Help
Show and Tell
aj1973's avatar
aj1973
Icon for Community Champion rankCommunity Champion
2 years ago

Hi,

Technically End users can't be added to a workspace. End users should consume reports or dashboards in Apps environment and given access permission to dataset on a read only.

 

gk124's avatar
gk124
Frequent Visitor
2 years ago

You mean to say that I should delete the access granted to these people in below image from RLS ?

  • aj1973's avatar
    aj1973
    Icon for Community Champion rankCommunity Champion
    2 years ago

    Not from RLS, but from the workspace.

    As Anonymous said you might want to create a new workspace and use App environment for end users

     

    • gk124's avatar
      gk124
      Frequent Visitor
      2 years ago

      Hi,
      As per your instructions I have created a new workspace and have added the end user in the RLS options but its not working. The user is able to view the data for all the organisation.
      Moreover the dashboard is designed for users within organisation no any external parties will have access to it.

      • aj1973's avatar
        aj1973
        Icon for Community Champion rankCommunity Champion
        2 years ago

        My doubt is now more focused on the role you have created

         

         

        Something is wrong in the Role ! is Guha exist in the 2 columns defined in the role? 

         

        Please change || by && in the role.