cancel
Showing results for 
Search instead for 
Did you mean: 
Reply
Highlighted
jerish Regular Visitor
Regular Visitor

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.

1 ACCEPTED SOLUTION

Accepted Solutions
jerish Regular Visitor
Regular Visitor

Re: datasource access error to SSAS tabular please contact administrator

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 12
jerish Regular Visitor
Regular Visitor

datasource access error to SSAS tabular please contact administrator

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.

Super User
Super User

Re: datasource access error to SSAS

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?

Did I answer your question? Mark my post as a solution!

"Proud to be a Datanaut!"
Super User
Super User

Re: datasource access error to SSAS tabular please contact administrator

@jerish Is the user that deployed the report an approved user for the data source in the gateway?

Near SE WI? Join our PUG Milwaukee Brew City PUG
jerish Regular Visitor
Regular Visitor

Re: datasource access error to SSAS

Yes it does says successfully deployed.CapturePBI.PNG

jerish Regular Visitor
Regular Visitor

Re: datasource access error to SSAS tabular please contact administrator

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

Super User
Super User

Re: datasource access error to SSAS tabular please contact administrator

Are both the domains on the same name?

Eg. Bob@toys.com and Toys\bob?


Did I answer your question? Mark my post as a solution!

"Proud to be a Datanaut!"
jerish Regular Visitor
Regular Visitor

Re: datasource access error to SSAS tabular please contact administrator

If you are asking about the SSAS DB and Gateway, then they are now on the same machine to eliminate the odds. 

Super User
Super User

Re: datasource access error to SSAS tabular please contact administrator

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.

Did I answer your question? Mark my post as a solution!

"Proud to be a Datanaut!"
jerish Regular Visitor
Regular Visitor

Re: datasource access error to SSAS tabular please contact administrator

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.