Forum Discussion
datasource access error to SSAS
It was resolved by our IT dept. We had corporate domain which was different from our development domain and accorging to them they modified some forwarding settings . And I modified the effective user setting under manage gateway to map the email to an actual domain account.
I ran the profiler and I think we are on to something. Thank you so much . I get an error in profiler "The following system error occurred: The user name or password is incorrect."
I verified that
1. The upn have the same email address that I use to login to PBI service
2. The gateway is running under the same AD account associated with the PBI login email.
4. SSAS have roles added with full privilege to the AD account.
In addition the report and dataset are deployed using the same AD account. So where is the credential mis match. Is there any way to identify which account it is using to login and is failing.
Thank you so much for the help so far.
When you go into the Mange Gateways, then the data source. If you click on Users and then Map Usernames, what settings does it have in there?
I think that you are possibly going to have to map it from a UPN to a domain login where it is set to "Effective UserName", so for example if my UPN was [email protected], I would then map it to FOURMOO\Gilbert