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.
