Forum Discussion
Solution SpecialistPower 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 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
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 ZhouIf this post helps, then please consider Accept it as the solution to help the other members find it more quickly.
13 Replies
abc_777yes, 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
Solution Sage
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.
- 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
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
can't i hide power bi report sheet. I dont want to show full report to user. only some specific sheet
- 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 !!!
- 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?
- abc_777
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
