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.
Yes. I can create and report fromExcel Pivot table with no issues. I myself deployed the SSAS and the gateway is also running under my account. So I am sure it is not a privilege issue to the dataset
If you are asking about the SSAS DB and Gateway, then they are now on the same machine to eliminate the odds.
- HI there
If you can have Query Profiler running on your SSAS server and then try and access the report. It will give you an error when trying to connect.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.