Register now to learn Fabric in free live sessions led by the best Microsoft experts. From Apr 16 to May 9, in English and Spanish.
Hi all,
I know it's still in preview, but I tried to get row-level security to work for my datamart, and it works just fine using Power BI reports!
It is also quite easy to assign the role to a domain user, which automatically adds the user to the datamart: exciting!
It also enables the domain user to access the SQL Azure DB using tools like SSMS or Azure Data Studio, that's also great! But I can't get the row-level security to work in the SQL database, the filters are simply not filtering anything. Is it just me, does it work for anyone?
Is this actually a planned feature? Will it be using the Row-Level Security from SQL Server using security policies, and auto-generate the table-valued function you need for this type of security?
Grateful for any information,
Markus.
Hi, @markusr
Please refer to the following link, hope it can help you.
https://satoricyber.com/sql-server-security/sql-server-row-level-security/
https://www.sqlshack.com/sql-server-data-security-feature-rls-row-level-security-and-gdpr/
Best Regards,
Community Support Team _Charlotte
If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.
Hi @v-zhangti ,
thanks for pointing out these links, which explain SQL Server RLS nicely! Now I know how to implement this myself manually. I was only hoping that Power BI Datamarts would do this for me, when I define Roles (including filter conditions) in my datamart! Is this included or planned, or am I mistaken here?
Yours,
Markus.
Covering the world! 9:00-10:30 AM Sydney, 4:00-5:30 PM CET (Paris/Berlin), 7:00-8:30 PM Mexico City
Check out the April 2024 Power BI update to learn about new features.