Forum Discussion
jasonbakersd
Helper I
Helper IPower BI RLS with SSAS 16 Tabular model. Need to have a 1:many filter
Hi all, we're in the process of moving an Import based Power BI model to a LiveConnect to SSAS Tabular Model and i'm having issues with the DAX to replicate our user security from the Import Model. ...
GilbertQ
Super User
Super UserHi there,
It should work if the lookup is based on just the username. This is because it will return all rows where the username is found
It should work if the lookup is based on just the username. This is because it will return all rows where the username is found
jasonbakersdHelper I
Helper II've made some progress.
This works as expected in SSAS, in that the users get filtered as expected.
I'm using a simple filter where the user security table is filtered by the USERNAME() function.
Still doesn't work in Power BI.
I'm working with my network group as this might be a Kerberos issue. as I noticed the NT Canoniacle User Name (has the domian on it) isn't getting passed when I connect to Power BI Service.