There should be a way to use the SSAS Tabular Connector without AD Sync, e.g. by using CustomData on the connection string.
I am running in to a problem due to the fact that even though our company has turned on DirSync and we have associated our Office 365 tenant with our AAD account, our AAD account and our on-prem account are still two *different* accounts. Our AAD account uses a suffix that is publicly routable, but our on-prem account uses a non-routable account. Therefore our UPNs are different and the EffectiveUserName that is passed to SSAS on-prem appears as an invalid UPN/account to our on-prem server. Granted, I would like our organization to clean up the mismatch and make our on-prem UPN match the AAD UPN, but that is a massive undertaking. So I'm interested in alternative options that help us easily work around this. Maybe an alternative AAD attribute that would contain our on-prem UPN string could be something we configure in the connector setup. I'm not looking for the ability to put a single, trusted account into the string. I really want individual users to be authenticated. I just need the proper on-prem UPN to be passed through.
