Forum Discussion
Problems with security when using Live connection to SSAS Tabular
Hi Anonymous,
If you implement RLS on SSAS Tabular, once the report has been published, the dynamic row level security that was defined in the on-premises Analysis Services tabular model has been successfully reflected and observed in the Power BI service. Then Power BI uses the effective username property to send the current Power BI user credential to the on-premises data source to run the queries. So it should work seamlessly without problems.
Regards,
Frank
Hi v-frfei-msft,
you wrote that "It is more effective to implement RLS in Power BI" - but now my doubt is, if i implement RLS on SSAS Tabular, and then move the reports to PBI Service, what will be the one that should be working, or will it work seamlessly without problems?
Regards
Community SupportHi Anonymous,
If you implement RLS on SSAS Tabular, once the report has been published, the dynamic row level security that was defined in the on-premises Analysis Services tabular model has been successfully reflected and observed in the Power BI service. Then Power BI uses the effective username property to send the current Power BI user credential to the on-premises data source to run the queries. So it should work seamlessly without problems.
Regards,
Frank
I'm finding that the RLS we built on the SSAS model (live connection) is not working in the PBI Service and users are able to see everything. While it should be using the effective user name - it seems to be bypassing the RLS entirely. The users are set up as viewers only - so it's not an admin issue. Looking for insights on what we are missing
