Forum Discussion
datasource access error to SSAS
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.
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.
12 Replies
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
- Hi there,
Do you have a screenshot of the error?
And when you deploy the report does it say it successfully connected to the Gateway?Yes it does says successfully deployed.
