Power RLS

[abc_777]

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  but on left side I see all my other tables are showing.

see now viewing as : rsl desktop (that is my row level security)

but on left side I have other tables showing. and when i give permission to user he also can see those other table.

I dont want user to see those other table

[abc_777]

@ALLUREAN 

Thanks for your reply,

I have gone whole process and at the end it says to click security on data set and then give access to user. I have done same. but when i log in as user i cant see the report pages. as user.

should i have to upload data aset to user power bi service as well? please help me out

[abc_777]

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]

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]

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?

[v-rzhou-msft · Accepted solution]

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]

@v-rzhou-msft ,

thank you, great help. Lastly, it's working. Thanks, rico.

I can now give a page-level filter to the user and can also by-product zone so he can only see that page and zone. thanks 

[abc_777]

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 user1@xxx.com, for example, should user1@xxx.com 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

[v-rzhou-msft]

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.

user1@xxx.com is the sample userprincipalname. When  user1@xxx.com 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.

[abc_777]

can't i hide power bi report sheet. I dont want to show full report to user. only some specific sheet

[abc_777]

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

[abc_777]

yes, thats right. I dont want user to see my table. I have tried many ways but filtering that i have created on row level secrurity is working but all my tables are showing to users and user can see report as well by clicking

[ALLUREAN]

In your case maybe you can try using OLS (Object Level Security) to hide the table. You need to download (if not having it) Tabular Editor to achieve OLS.

[ALLUREAN]

Hi, @abc_777 

If I understand you want to hide a table using RLS?