Dynamic Row Level Security with CUSTOMDATA in Azure Analysis Services Tabular

[vee_jess]

Hello everyone,

I need some help getting dynamic row level security to work in AAS Tabular using CUSTOMDATA being passed in from a Power BI embedded portal. The Power BI reports have live connection to the AAS Tabular.

A snippet of the CUSTOMDATA is as below and I need to filter table-A by country and region.

<Roles>RLS_String</Roles>
<EffectiveUserName>serviceaccount@email.com</EffectiveUserName>
<CustomData>CompanyA_#joe.blog@email.com_#SA_#AED_#SQM_#Country_#US,UK,Australia_#Region_#RegionA,RegionB</CustomData>

Table-A

PK	Country	Region
1	US	RegionA
2	US	RegionB
3	US	RegionC
4	UK	RegionA
5	UK	RegionB
6	UK	RegionC
7	UK	RegionD
8	Australia	RegionA
9	Australia	RegionF

How can I grab all the countries and regions from the CUSTOMDATA code then filter my table with those values?

Thank you in advanced.

[vee_jess]

Any help on this will be much appreciated please.