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 deployed ssas tabular from VS 2017 to Analysis Services 2016 and created a report from PBI Desktop using Live connection which all works great. Published it to a PBI workspace and when trying to access the report, it give the datasource access error.
The gateway is installed on the same SSAS Server and the service is running under a domain account. Firewall is also turned off here.
From the manage gateway option the datasource displays connection is successful. Also verified that the UPN matches between the login and the domain.
Also roles are created in SSAS with admin privileges.
I tried to run a report in Excel Pivot table from this SSAS database and it works fine.
Any help is appreciated.
jerish Is the user that deployed the report an approved user for the data source in the gateway?
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.
