Forum Discussion
How to configure UPN mapping/CustomData for Azure Analysis Services and PowerBI Embedded
So I finally figured this out, as far as I can tell UPN mapping is enabled by default.
In my specific case I ended up using the `CustomData` option as per the docs. 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 `USERPRINCIPAL()` DAX function, then the filter that I added against the user table comparing the user's email against `CUSTOMDATA()` DAX function.
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.
I hope this saves someone else the trouble I had.
So I finally figured this out, as far as I can tell UPN mapping is enabled by default.
In my specific case I ended up using the `CustomData` option as per the docs. 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 `USERPRINCIPAL()` DAX function, then the filter that I added against the user table comparing the user's email against `CUSTOMDATA()` DAX function.
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.
I hope this saves someone else the trouble I had.