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)
RE: SSAS Tabular Connector without Active Directory Sync?
Yes, being able to specify different domain in the connection is key for us.
RE: SSAS Tabular Connector without Active Directory Sync?
Even I am also getting error while using connector without ADsync. It would be great if we can connect on premise SSAS tabular models without AD sync on azure.
RE: SSAS Tabular Connector without Active Directory Sync?
Absolutely - and the need is greater than that. A proxy account may be required by designed, so passing user credentials may not help. Consider the scenario where I have an SSAS model that has no per-user security requirements - it's homogeneous to the entire organization. Managing users on that model could be cumbersome, and an unnecessary step. Or I may be an ISV running a reference model...... I may want to make it available to everyone - much like the way the demo dashboard is done in the current Power BI Preview.
RE: SSAS Tabular Connector without Active Directory Sync?
Trying with SQL Server 2014 Dev on same machine. Getting 400 error after entering friendly name.
RE: SSAS Tabular Connector without Active Directory Sync?
Great suggestion Teo. I agree this would simplify deployment of the Power BI AS Connector in some scenarios. I think this problem is common for demo environments, but not as common for real production environments. That being said, if it's complicated to setup a demo, the deployment may never get to production.
I described a workaround here, but it's still quite a bit more involved than it would be with CustomData.
http://www.artisconsulting.com/blogs/greggalloway/Lists/Posts/Post.aspx?ID=27