Skip to main content
cancel
Showing results for 
Search instead for 
Did you mean: 

Find everything you need to get certified on Fabric—skills challenges, live sessions, exam prep, role guidance, and more. Get started

Reply
Kashinoda
Advocate I
Advocate I

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.

1 ACCEPTED SOLUTION
Kashinoda
Advocate I
Advocate I

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.

 

View solution in original post

4 REPLIES 4
Kashinoda
Advocate I
Advocate I

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.

 

Hi,

I am facing the same issue. What do you mean by SSAS connection. 

Is this datasource conncection to cube in power serive or while accessing retrieving the data from SSAS tabular model(Visual studio).

Can you please provide some detail information. Thanks !

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.

 

 

Untitled.pngUntitled2.png

Thanks @Kashinoda

In my case its working after relacing firstname.lastname@mydomain.com to networkid@mydomain.local

Helpful resources

Announcements
Europe Fabric Conference

Europe’s largest Microsoft Fabric Community Conference

Join the community in Stockholm for expert Microsoft Fabric learning including a very exciting keynote from Arun Ulag, Corporate Vice President, Azure Data.

July 2024 Power BI Update

Power BI Monthly Update - July 2024

Check out the July 2024 Power BI update to learn about new features.

July Newsletter

Fabric Community Update - July 2024

Find out what's new and trending in the Fabric Community.