Forum Discussion
Gateway: UPN mapping everyone to the same admin user
Been stuck on this for hours, if anyone has a clue it'll be much appreciated!
I have the On-Premesis Data Gateway setup and connected to my Analysis Server and Database.
I've remapped user names i.e.
Custom Data
Replace: @mydomain.com With: @mydomain.intra
I've published a report to my App Workspace and published the App. I've noticed my roles don't seem to work and everyone has access to everything. I added a USERNAME() measure to the report and sure enough it reports everyone as being logged in as MYDOMAIN\admin
I've tried various combinations to no avail.
Solved this, for anyone else who has this error.
When creating the SSAS connection use a fully qualified domain name. I.e. I was using MYDOMAIN which connected without issue, but the Effective User Name wouldn't map until I altered the SSAS connection to use mydomain.intra.
Hadn't come across this before.
4 Replies
Solved this, for anyone else who has this error.
When creating the SSAS connection use a fully qualified domain name. I.e. I was using MYDOMAIN which connected without issue, but the Effective User Name wouldn't map until I altered the SSAS connection to use mydomain.intra.
Hadn't come across this before.
I was referring to the Data Source Settings, see the pictures below. Even though the standard domain will connect to the database you should use the fully qualified domain, then you can map the effective user name as usual. I haven't had this issue before but it worked for me.
