Forum Discussion
vee_jess
6 years agoNew Member
Dynamic Row Level Security with CUSTOMDATA in Azure Analysis Services Tabular
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>[email protected]</EffectiveUserName>
<CustomData>CompanyA_#[email protected]_#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.
1 Reply
- vee_jessNew Member
Any help on this will be much appreciated please.