Skip to main content

Power BI

Under Review

SSAS Tabular Connector without Active Directory Sync?

Vote (214) Share
Teo's profile image

Teo on 21 Dec 2014 22:36:29

There should be a way to use the SSAS Tabular Connector without AD Sync, e.g. by using CustomData on the connection string.

Administrator on 22 Dec 2014 14:34:34

Thanks for the suggestion, Teo! Is anyone else in a position where they can't use the SSAS Connector because they aren't using AD Synchronization? If so, please add your vote here!

Comments (35)
Teo's profile image Profile Picture

Josh Weight on 05 Jul 2020 23:09:19

RE: SSAS Tabular Connector without Active Directory Sync?

I'm more interested in having the ability to use both upn mappings to effective user and then have customdata rules as well. Right you can you do one or the other.

Teo's profile image Profile Picture

Patrick P on 05 Jul 2020 22:41:17

RE: SSAS Tabular Connector without Active Directory Sync?

Our rather large organization is moving away from pure AD in favor of Virtual Directory Services and we've been told that AD will likely be gone within 3 years, so especially for these cloud based services, MS needs to define some alternative authentication methods or we'll also be seeing an end to the use of things like SSAS. :(

Teo's profile image Profile Picture

sreinman on 05 Jul 2020 22:38:42

RE: SSAS Tabular Connector without Active Directory Sync?

This is resolved with the Map User Name setting in the enterprise gateway. See here: https://powerbi.microsoft.com/en-us/blog/tech-tip-thursday-user-principal-name-upn-mapping-in-power-bi/

Teo's profile image Profile Picture

Power BI User on 05 Jul 2020 22:22:23

RE: SSAS Tabular Connector without Active Directory Sync?

With the forced use of AD it is useless for us.

Teo's profile image Profile Picture

jerome P on 05 Jul 2020 22:18:10

RE: SSAS Tabular Connector without Active Directory Sync?

what's the status for this problem?
having a simple option where I can put the domain name instead of the O365 one can dop the job for me.

like: replace user@publicdomain.com to: user@localdomain.com
as I have the same login names on both O365 and my local AD, this simple find / replace is enough.

Teo's profile image Profile Picture

Power BI User on 05 Jul 2020 22:16:43

RE: SSAS Tabular Connector without Active Directory Sync?

Can we please accelerate this requirement. it is a real need for ISV's

Teo's profile image Profile Picture

Alistair on 05 Jul 2020 22:15:35

RE: SSAS Tabular Connector without Active Directory Sync?

Any update on this? Unfortunately this is becoming an urgent requirement - we might have to look at another product if this does not get resolved soon.

Teo's profile image Profile Picture

Nitin on 05 Jul 2020 22:14:37

RE: SSAS Tabular Connector without Active Directory Sync?

Hi,
I have Users who are out of my domain. So now those can't be sync with AD.
So they can't have live connection.

Definitely a required feature.

Teo's profile image Profile Picture

Art Tennick on 05 Jul 2020 22:09:08

RE: SSAS Tabular Connector without Active Directory Sync?

I wish this one had more votes! It is really a fundamental requirement

Teo's profile image Profile Picture

Sam Loud on 05 Jul 2020 22:08:12

RE: SSAS Tabular Connector without Active Directory Sync?

Yes, we very much have this problem, and this would be a huge help for us.