Power BI is turning 10! Tune in for a special live episode on July 24 with behind-the-scenes stories, product evolution highlights, and a sneak peek at what’s in store for the future.
Save the dateEnhance your career with this limited time 50% discount on Fabric and Power BI exams. Ends August 31st. Request your voucher.
Hi team,
I am in need of guidance relating a scenario we have in one of our recent execution.
We have dynamic RLS implemented in Power BI datasets (models basically) and hosted in PBI Service. Now within the organisation there exits two levels of user groups,
We have user information as part of the dataset to lookup and filter only data relating to them, this seems perfectly all right for Viewer audience. But for the intermediate Super User (author basically) who connects to these datasets either by downloading raw .pbix from the PBI Service or use web capability to author a report will still have access to all information available as part of the extract. How can this restrictions maintained even for these Super Users?
Please let me know if I miss something and any directions on this would really help.
Thanks in advance.
Pradeep
Thank you @v-lionel-msft , I understand RLS is only applicable for viewers role.
But here is a spcecial requirement where user needs to use shared dataset to build report and re-publish it,
but they should be able to see their own data and not the complete data from shared datasource.
Is there any way to achieve this requirement ?
Best Regards,
Jyoti Pawar
Hi @Anonymous ,
Unfortunately, the current version does not support users to have both ‘edit permission’ and ‘RLS’ in the workspace.
Therefore, for data security, it is necessary to clearly distinguish what each user should do. Things like creating and publishing should be left to the report developer rather than the viewer.
Best regards,
Lionel Chen
If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.
Hi @SPradeep ,
In the workspace of PBI Service, RLS can not take effect on roleswith editing permission (Admin, member, contributor) .
Best regards,
Lionel Chen
If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.
Check out the July 2025 Power BI update to learn about new features.
User | Count |
---|---|
6 | |
6 | |
3 | |
2 | |
2 |