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

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

 

 

Anonymous's avatar
Anonymous
Not applicable
4 years ago

Hi abc_777 ,

 

As I mentioned before, we need to hide other pages exclude Home Page. Here I add a Back button in other pages.

[email protected] is the sample userprincipalname. When  [email protected] login in Power BI Service and he could only see  Home, Page1 and Page 3 in Home page, he can select the Page he want to see in slicer and then click the Navigation button to link the page. Here I change these sample name to real Power BI account and have a test.

After we do all steps as the blog, we can publish the report to Power BI Service. Here I add three users into Roles in Dataset Security.

Stephen and Admin are viewer in workspace.

View as Admin.

View as Stephen

They can only Click above button to the link page and go back to home page by back button.

You can change the userprincipalname in user table as your end users' and have a try.

 

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.