Forum Discussion
Page level security
- 2 months ago
Hi powerbiexpert22 ,
There is no direct option to have a page level security you can do a mix and match between page navigation with dynamic dax and rls.
Check the blog post below:
https://medium.com/microsoft-power-bi/control-page-level-access-for-users-in-power-bi-a20e9759da65
https://www.youtube.com/watch?v=GqQh_XE5eCs
But be aware that depending on how you make the access this is not 100% secure.
In this case taking into consideration that Excecutives should only Overview and Sales manager should only see analysis page and the detail to the operational I would do 3 thin reports with the different pages and the use an app and audiences this would allow you to have a complete control over who sees what and 100% assurance that they would only access that specific report.
- 2 months ago
Hi,
As far as I know, Power BI doenst have page level secueirity,
i have runinto a smililar requirement before and ended up creating seprate reports for different user group.
I can help you in this regard, i have personnaly implemented RLS in more than 100 BI user in my Organization.
In my organizar we have same issue so i make copy of main PBIX file and implement RLS.
In my organizarion hierarchy is as below:
Sr. GM Sales
RSM North and South
7 ZSM
25 BSM
75 ASO
all are using Power BI Reports and Dashboards.
I have developed 3 report groups.
1. Sr. GM Sales, RSMs and Head Office
Planning Staff
2. ZSMs and BSMs
3. ASO
Same report for ZSMs but they can only view their relevent zone data and analysis, same for ASOs, with the help of RLS.
SO My suggestion please make copy of main report and implement RLS.
Below are screen shot of RSL securithy:
BI DESKTOP:
BI Service:
Hi powerbiexpert22,
Thank you for posting your query in the Microsoft Fabric Community Forum, and thanks to the 123abc ,MFelix for sharing valuable insights.
Could you please confirm if your issue has been resolved using the suggested approach? This will help other community members facing similar scenarios.
Thank you for being part of the Microsoft Fabric Community.