Find everything you need to get certified on Fabric—skills challenges, live sessions, exam prep, role guidance, and more.
Get startedGrow your Fabric skills and prepare for the DP-600 certification exam by completing the latest Microsoft Fabric challenge.
Hey Eason,
Thanks for the reply.
For an ISV, PowerBi's RLS is rubbish. Any data system will have security measures in place and the expectation to replicate that in a separate reporting system is a complete waste of time, unless of course you're paid by the hour.
Direct Query PowerBI reports from SQL Server with credential pass-through WILL and DOES honour the user's security settings IF you publish "correctly", as per my original post.
My question is why is there a difference? And secondly, should there be a difference? I would think that publishing a report from PowerBI desktop to Powerbi.com via ANY of the mechanisms Microsoft provide should be a consistent experience with consistent end results, surely?
Or is that not what I should be expecting? Happy to be wrong but would love to understand why.
Hi, @MFoo
Row-level security (RLS) with Power BI can be used to restrict data access for given users.
Typically, you need to add user accounts as workspace "Viewer" and add them to the RLS roles you create. RLS does not apply to workspace members who are assigned Admin, Member, or Contributor.
Using RLS with workspaces in Power BI
If you publish your Power BI Desktop report to a new workspace experience in the Power BI service, the RLS roles are applied to members who are assigned to the 'Viewer role' in the workspace. Even if Viewers are given Build permissions to the dataset, RLS still applies. For example, if Viewers with Build permissions use Analyze in Excel, their view of the data will be protected by RLS. Workspace members assigned Admin, Member, or Contributor have edit permission for the dataset and, therefore, RLS doesn’t apply to them. If you want RLS to apply to people in a workspace, you can only assign them the Viewer role. Read more about roles in the new workspaces.
Best Regards,
Community Support Team _ Eason
Join the community in Stockholm for expert Microsoft Fabric learning including a very exciting keynote from Arun Ulag, Corporate Vice President, Azure Data.
Ask questions in Eventhouse and KQL, Eventstream, and Reflex.