Official documentation for Row-Level security with Power BI https://docs.microsoft.com/en-us/power-bi/admin/service-admin-rls Row-Level Security with Power BI Embedded https://docs.microsoft.com/en-us/power-bi/developer/embedded/embedded-row-level-security Row-Level Security Guidance in Power BI Desktop https://docs.microsoft.com/en-us/power-bi/guidance/rls-guidance USERPRINCIPALNAME() https://dax.guide/userprincipalname/ Power BI Security Whitepaper https://docs.microsoft.com/en-us/power-bi/admin/service-admin-power-bi-security
RLS generally only works with people/groups that are Viewers. With Many-to-Many implementation of RLS, you need to select Cross filter direction Both and click the checkbox Apply security filter in bot directions.
https://social.msdn.microsoft.com/Forums/sqlserver/en-US/2498739e-46ba-4d2a-adb3-a98183e8fa94/can-connect-to-my-azure-tabular-model-in-power-bi-but-not-excel?forum=sqlanalysisservices PowerBI uses the ADOMD provider (which is included in the PowerBI install). Excel uses the MSOLAP provider installed on your machine. So you could try downloading and installing the latest MSOLAP provider from here: https://docs.microsoft.com/en-us/analysis-services/client-libraries?view=azure-analysis-services-current Also Power BI has Analyze in Excel which will provide the download.