Forum Discussion
datasource access error to SSAS
- 7 years ago
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.
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.