Forum Discussion
page level security
Hi Anonymous , There is no official default way to have Page level security in Power BI. While I did say we can use a workaround where we can use measures to restrict access and use page navigation, that was based on my general experience in Power BI and I am sorry if that misled you, wasn’t my intention. I have tried to do this but found not only that this isn’t possible, but the only sure workaround is also what I already gave you in the .pbix file with landing page and page navigation (using bookmarks).
I improved on that workaround by changing it a bit. Now there is a Main page with buttons for Admin and Manager. When you click on Admin, you can view the buttons for pages that admin has access to (all of them in this scenario) and when you click on Manager, you can view the buttons for pages that Manager has access to. There you can use those buttons to navigate to the respective pages. You can base this to build your own report as needed.
Please check the .pbix for your reference.
thanks for response
said bookmarks and measures. but in powerbi file there are no bookmarks and measures. can you confirm
Regards
yukta
Hi Anonymous ,I understand the confusion. In my earlier response, I provided a detailed and complex solution based on my experience. However, when I was reproducing it in Power BI, I realized that such complexity was unnecessary. Therefore, I have given you the .pbix file with a simpler, more straightforward solution that does use bookmarks but not measures. It should resolve your issue as it is the only reliable workaround.
Thank you.
thanks for response
i think this is RLS and not PLS. when i trying to login as admin and manager it was performing RLS can you please check
Regards
Yukta
Hi Anonymous , Thank you for reaching out to the Microsoft Community Forum.
Please refer to the below links:
Page Level Security in Power BI - Microsoft Fabric Community
Page level security with RLS - Microsoft Fabric Community
Object-level security (OLS) with Power BI - Microsoft Fabric | Microsoft Learn
Solved: Row-level security and Page Level Security in one ... - Microsoft Fabric Community
Solved: Page level security in Power BI(Sensitive & Non-Se... - Microsoft Fabric Community
If this helped solve the issue, please consider marking it “Accept as Solution” and giving a ‘Kudos’ so others with similar queries may find it more easily. If not, please share the details, always happy to help.
Thank you.thanks for response
but what ever you shared powerbi file. it was not was working as PLS.
can you make changes and re-share powerbi file. what ever show in this link
Page Level Security in Power BI - Microsoft Fabric Community.
Regards
Dilip