Forum Discussion

abc_777's avatar
abc_777
Solution Specialist
4 years ago
Solved

Power RLS

I have created a ROw level Security in Power Desktop then check and its working fine in desktop then I publish it to power bi service and go to data set then check it view as on power bi service  bu...
Need Help
  • Anonymous's avatar
    Anonymous
    4 years ago

    Hi abc_777 ,

     

    ALLUREAN 's blog is incomplete. You need to hide all your pages and set your blank botton as "Page Navigation" in Botton Action.

    For reference: Page-Level Security workaround in Power BI

    My Test:

    All sets are configured and By default:

    User1 could only see the navigation for Page1 and Page 3. 

    Select Page1 and Ctrl +left Click. We will be navigated to Page1

    If your user still could see all navigation, please check whether their roles in workspace has build permission. If they have build permission, RLS won't work.

    For reference: Using RLS with workspaces in Power BI

     

    Best Regards,
    Rico Zhou

     

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

abc_777's avatar
abc_777
Solution Specialist
4 years ago

my appology. its not table. it should be report sheet that i have created in power desktop.

i want to share per user as per require sheet then on that sheet i want to make RLS

 

for example:

a user1 can see quantity which is in my power bi report sheet 1 and then that user can see north side there i can use RLS

 

another user2 need to see sales (amount ) which is in my power bi report sheet 2 and then that user can see south side see sales (amount ) there i can use RLS

 

so user 1 can not see sheet 2 and user 2 can not see sheet 1

 

so please help me out

ALLUREAN's avatar
ALLUREAN
Solution Sage
4 years ago

Hi, abc_777 

Check this article https://www.solution-tailor.com/post/powerbi-tab-level-security

At the end it is suggested that you can combine this approach with your existing RLS. I think you can set a RLS filter to NORTH/SOUTH to the pages.

 

Did I answer your question? Please Like and Mark my post as a solution if it solves your issue. Thanks.

Appreciate your Kudos !!!

https://allure-analytics.com/

https://www.youtube.com/channel/UCndD_QZVNB_JWYLEmP6KrpA

https://www.linkedin.com/company/77757292/

  • abc_777's avatar
    abc_777
    Solution Specialist
    4 years ago

    Hi,

     

    I have triend many times by giving one user to see few sheet or tab and other user to see other tab or sheet. but for me its not working. it shows all sheet for both of them. but my RLS is working for other filter. any suggession for sheet or tab level security?

    • Anonymous's avatar
      Anonymous
      Not applicable
      4 years ago

      Hi abc_777 ,

       

      ALLUREAN 's blog is incomplete. You need to hide all your pages and set your blank botton as "Page Navigation" in Botton Action.

      For reference: Page-Level Security workaround in Power BI

      My Test:

      All sets are configured and By default:

      User1 could only see the navigation for Page1 and Page 3. 

      Select Page1 and Ctrl +left Click. We will be navigated to Page1

      If your user still could see all navigation, please check whether their roles in workspace has build permission. If they have build permission, RLS won't work.

      For reference: Using RLS with workspaces in Power BI

       

      Best Regards,
      Rico Zhou

       

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

      • abc_777's avatar
        abc_777
        Solution Specialist
        4 years ago

        Hi Rico,

        would please tell me what exactly will happen when I publish your power bi desktop to power bi service and log in as [email protected], for example, should [email protected] see only Home, Page1 and Page 3 or he can see all list of pages but can't access them except Home, Page1 and Page 3

         

        I have uploaded your file to power bi service to a (view only) user and then see the home page but when click the button they do not taking me to that selected page. moreover, there is an edit button on top of the power bi service page, when click edit all my sheet are showing to the user