Forum Discussion
Row level Security not working with SSAS Tabular DB - Need Help
Hi All, I followed the step provided in some other blog to implement SSAS Tabular DB Row level security, but its not working. Can someone please help. Below are the steps I followed 1. Create...
Austine, Most of the vedios are referring to PowerBI Analytics Service Connector, but I believe its not available anymore right?
I have setup PowerBI Enterprise Gateway, which should do same right?
Mind that I am able to connect and query the SSAS tabular DB, its only that the roles are not working as expected, even after setting a role for a specific user he is able to see all data.
In Power BI, all security set in data source will not be taken. To limit the access, you have to set the Row-Level Security(RLS) on Power BI Service, you can add those users as membership and apply DAX filters. It's similar to Tabular Row-Level Security. Just click the ellipsis of dataset, select "SECURITY".
Reference:
Row-level security
Regards,