topic Re: Dynamic Row Level Security with CUSTOMDATA in Azure Analysis Services Tabular in Developer https://community.fabric.microsoft.com/t5/Developer/Dynamic-Row-Level-Security-with-CUSTOMDATA-in-Azure-Analysis/m-p/1209524#M24654 <P>Any help on this will be much appreciated please.</P> Wed, 08 Jul 2020 14:56:37 GMT vee_jess 2020-07-08T14:56:37Z Dynamic Row Level Security with CUSTOMDATA in Azure Analysis Services Tabular https://community.fabric.microsoft.com/t5/Developer/Dynamic-Row-Level-Security-with-CUSTOMDATA-in-Azure-Analysis/m-p/1205716#M24613 <P>Hello everyone,</P><P>&nbsp;</P><P>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.</P><P>A snippet of the CUSTOMDATA is as below and I need to filter table-A by country and region.</P><P>&nbsp;</P><P>&nbsp;</P><P>&nbsp;</P><LI-CODE lang="markup">&lt;Roles&gt;RLS_String&lt;/Roles&gt; &lt;EffectiveUserName&gt;serviceaccount@email.com&lt;/EffectiveUserName&gt; &lt;CustomData&gt;CompanyA_#joe.blog@email.com_#SA_#AED_#SQM_#Country_#US,UK,Australia_#Region_#RegionA,RegionB&lt;/CustomData&gt;</LI-CODE><P>&nbsp;</P><P>&nbsp;</P><P>&nbsp;</P><P>Table-A</P><TABLE border="1"><TBODY><TR><TD>PK</TD><TD>Country</TD><TD>Region</TD></TR><TR><TD>1</TD><TD>US</TD><TD>RegionA</TD></TR><TR><TD>2</TD><TD>US</TD><TD>RegionB</TD></TR><TR><TD>3</TD><TD>US</TD><TD>RegionC</TD></TR><TR><TD>4</TD><TD>UK</TD><TD>RegionA</TD></TR><TR><TD>5</TD><TD>UK</TD><TD>RegionB</TD></TR><TR><TD>6</TD><TD>UK</TD><TD>RegionC</TD></TR><TR><TD>7</TD><TD>UK</TD><TD>RegionD</TD></TR><TR><TD>8</TD><TD>Australia</TD><TD>RegionA</TD></TR><TR><TD>9</TD><TD>Australia</TD><TD>RegionF</TD></TR></TBODY></TABLE><P>&nbsp;</P><P>How can I grab all the countries and regions from the CUSTOMDATA code then filter my table with those values?</P><P>&nbsp;</P><P>Thank you in advanced.</P> Tue, 07 Jul 2020 08:06:40 GMT https://community.fabric.microsoft.com/t5/Developer/Dynamic-Row-Level-Security-with-CUSTOMDATA-in-Azure-Analysis/m-p/1205716#M24613 vee_jess 2020-07-07T08:06:40Z Re: Dynamic Row Level Security with CUSTOMDATA in Azure Analysis Services Tabular https://community.fabric.microsoft.com/t5/Developer/Dynamic-Row-Level-Security-with-CUSTOMDATA-in-Azure-Analysis/m-p/1209524#M24654 <P>Any help on this will be much appreciated please.</P> Wed, 08 Jul 2020 14:56:37 GMT https://community.fabric.microsoft.com/t5/Developer/Dynamic-Row-Level-Security-with-CUSTOMDATA-in-Azure-Analysis/m-p/1209524#M24654 vee_jess 2020-07-08T14:56:37Z