RLS work scenario Differences between PowerBI Service and SSAS

[Anonymous]

Hello All,

Can someone please give a detailed explanation about how exactly RLS works

under SSAS and PowerBi Service.

Is there any differences or not.

If it is, then what is the correct procedure to follow it.

Thanks,

Mohan V

[v-jiascu-msft · Accepted solution]

Hi @Anonymous,

Please refer to the documentations below for how RLS works. It's hard to explain it with a few words.

RLS in Power BI:

1. https://docs.microsoft.com/en-us/power-bi/service-admin-rls

2. https://docs.microsoft.com/en-us/power-bi/desktop-rls

RLS in SSAS:

1. https://docs.microsoft.com/en-us/power-bi/desktop-tutorial-row-level-security-onprem-ssas-tabular

2. https://docs.microsoft.com/en-us/sql/analysis-services/supplemental-lesson-implement-dynamic-security-by-using-row-filters

Please note on-premises RLS with Power BI is only available with live connection. And we have to apply the RLS in the on-premises when it's a live connection to the SSAS.

Best Regards,

Dale