https://community.fabric.microsoft.com/t5/Developer/How-to-configure-UPN-mapping-CustomData-for-Azure-Analysis/m-p/658323#M18966 <P>So I finally figured this out, as far as I can tell UPN mapping is enabled by default.</P><P>&nbsp;</P><P>In my specific case I ended up using the `CustomData` option as per <A href="https://docs.microsoft.com/en-us/power-bi/developer/embedded-row-level-security#using-the-customdata-feature" target="_self">the docs</A>. Initially this wasn't behaving as expected because on my Azure Analysis Services Database I had two row filters, one on the main data table that was comparing the user's email against the <A href="https://dax.guide/userprincipalname/" target="_self">`USERPRINCIPAL()`</A> DAX function, then the filter that I added against the user table comparing the user's email against <A href="https://dax.guide/customdata/" target="_self">`CUSTOMDATA()`</A> DAX function.</P><P>&nbsp;</P><P>To get this to work I ended up removing my own filter against the user table and replacing the use of the `USERPRINCIPAL()` function in the initial filter with `CUSTOMDATA()` - I verified this change with our BI guy and he was happy with it.</P><P>&nbsp;</P><P>I hope this saves someone else the trouble I had.</P> Sun, 31 Mar 2019 22:26:14 GMT MattStannett 2019-03-31T22:26:14Z https://community.fabric.microsoft.com/t5/Developer/How-to-configure-UPN-mapping-CustomData-for-Azure-Analysis/m-p/651472#M18889 <P>Similar to <A href="https://stackoverflow.com/questions/50468992/rls-in-power-bi-embedded-app-owns-data-with-azure-analysis-service-live-connec" target="_self">this question</A>.</P><P>&nbsp;</P><P>I have a .Net Core Web App that embeds a PowerBI report, this report needs has Row Level Security applied at the data level in **Azure Analysis Services** using an on-premises data gateway.</P><P>&nbsp;</P><P>I have configured the <A href="https://docs.microsoft.com/en-us/power-bi/developer/embedded-row-level-security#applying-user-and-role-to-an-embed-token" target="_self">`EffectiveIdentity`</A>&nbsp;to pass through the UPN using the <A href="https://docs.microsoft.com/en-us/power-bi/developer/embedded-row-level-security#using-the-customdata-feature" target="_self">`CustomData`</A>&nbsp;option, I have also setup a role and DAX query on the role to filter the rows.</P><P>I have also setup the SQL Server Profiler as per <A href="https://www.kasperonbi.com/using-customdata-and-ssas-with-power-bi-embedded/" target="_self">this post</A>&nbsp;and can confirm that the values being set inside `CustomData` are being passed through to Analysis services.</P><P>&nbsp;</P><P>In the non-Azure version of Analysis Services, you can configure the data gateway inside the PowerBI web portal to <A href="https://docs.microsoft.com/en-us/power-bi/service-gateway-enterprise-manage-ssas#map-user-names" target="_self">map usernames</A>. Since someone else setup the gateway (in Azure), and Azure Analysis Services is not a supported Data Source Type (<A href="https://imgur.com/07nhmC9" target="_self">not an option in the dropdown</A>).</P><P>&nbsp;</P><P>I need to know if it is possible to view/change the <A href="https://docs.microsoft.com/en-us/power-bi/media/service-gateway-enterprise-manage-ssas/gateway-enterprise-map-user-names_02.png" target="_self">Effective User names/CustomData setting</A>.</P> Sun, 31 Mar 2019 22:24:00 GMT https://community.fabric.microsoft.com/t5/Developer/How-to-configure-UPN-mapping-CustomData-for-Azure-Analysis/m-p/651472#M18889 MattStannett 2019-03-31T22:24:00Z https://community.fabric.microsoft.com/t5/Developer/How-to-configure-UPN-mapping-CustomData-for-Azure-Analysis/m-p/658323#M18966 <P>So I finally figured this out, as far as I can tell UPN mapping is enabled by default.</P><P>&nbsp;</P><P>In my specific case I ended up using the `CustomData` option as per <A href="https://docs.microsoft.com/en-us/power-bi/developer/embedded-row-level-security#using-the-customdata-feature" target="_self">the docs</A>. Initially this wasn't behaving as expected because on my Azure Analysis Services Database I had two row filters, one on the main data table that was comparing the user's email against the <A href="https://dax.guide/userprincipalname/" target="_self">`USERPRINCIPAL()`</A> DAX function, then the filter that I added against the user table comparing the user's email against <A href="https://dax.guide/customdata/" target="_self">`CUSTOMDATA()`</A> DAX function.</P><P>&nbsp;</P><P>To get this to work I ended up removing my own filter against the user table and replacing the use of the `USERPRINCIPAL()` function in the initial filter with `CUSTOMDATA()` - I verified this change with our BI guy and he was happy with it.</P><P>&nbsp;</P><P>I hope this saves someone else the trouble I had.</P> Sun, 31 Mar 2019 22:26:14 GMT https://community.fabric.microsoft.com/t5/Developer/How-to-configure-UPN-mapping-CustomData-for-Azure-Analysis/m-p/658323#M18966 MattStannett 2019-03-31T22:26:14Z