Skip to main content

    Power BI

    Under Review

    SSAS Tabular Connector without Active Directory Sync?

    Vote (213) 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

    c5e37295 6660-48c5-93ee-d5c868f93660 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

    1fed91f2 9af9-4d90-8b76-5b73990dbe36 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

    b39cb521 94b5-48f8-81ff-9cf730d3b8f7 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

    aa5f7b29 7052-4473-b3ed-aee2001d8163 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

    e18056d8 a20a-4d16-b49c-aec37d9aeb68 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

    7c5eeece aae8-44e5-a425-df4112708b90 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

    77a84312 0efa-4adf-8549-dfdb2f5a92d8 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

    66f0b0f3 236b-4150-9bb5-4d495c7e08e0 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

    edb58ab3 6a52-4d80-b902-1813a22a9d9a 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

    701fd5de 79f1-4766-81e3-eb279b5edce8 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.