Forum Discussion
Power BI Service Account
Hi,
I have a dashboard that accesses 2 different tables. The public has access to the 1st table, but not all users can access the 2nd table so its report will be restricted.
How do we approach this case?
Can we only have 1 service account? Or can we have multiple service account with different access levels?
Thanks so much for the help.
Regards,
Wyeth
Thank you so much Aniya!
The issue was solved using rls and ols. Your solution also led me to object level security (ols).
Thanks once again.
2 Replies
Hi , wmanacay
As far as I know, according to your requirements description, the row-level security (RLS) feature in Power BI can perfectly meet your needs, you can set an RLS role, define the role of public as "Table2=False()", and ensure that the public user has only read-only permissions on this dataset in the service and no permissions above "Viewer" in the workspace. And add the public user to the RLS's set role. This ensures that all public users see only their corresponding tables and data.
Row-level security (RLS) guidance in Power BI Desktop - Power BI | Microsoft Learn
Row-level security (RLS) with Power BI - Power BI | Microsoft Learn
Thank you for your time and sharing, and thank you for your support and understanding of PowerBI!
Best Regards,
Aniya Zhang
If this post helps, then please consider Accept it as the solution to help the other members find it more quickly
Thank you so much Aniya!
The issue was solved using rls and ols. Your solution also led me to object level security (ols).
Thanks once again.
