Forum Discussion

amarsale85's avatar
amarsale85
Helper II
6 years ago

Effective username doesn't change

Hi Experts,   I am using SSAS tabular model to show/hide column for specific users. So i defined 2 Roles in this SSAS DB, Client 1 and Client 2. I added myself in role of Client 1 and added a colle...
Need Help
amarsale85's avatar
amarsale85
Helper II
6 years ago

By Direct query to mean "Connect Live" ? I don't remember what i selected because i thought it didn't matter. 

Should i create new report using "Connect Live" ?

 

Regards,

Amar

amarsale85's avatar
amarsale85
Helper II
6 years ago

Selecting Live connection or Import doesn't help. It still sending my username as EffectiveUsername when my colleague is refreshing the dataset through his account.

I am still dealing with why this is not working also, i did a trick in "Map Users" section of my Gateway connection settings in Power BI service, where i replaced my user name with my colleague's and the SQL profiler shows this update when i refresh the dataset. But I still don't see the change. I don't get why.

So now i see 2 issues,

1) Passing appropriate Effective Username to SSAS server when refreshing dataset

2) And SSAS server displaying only permitted columns to the user based on the Effective Username passed.

 

Please help.