there was a data source access error.please contact the gateway administrator

[anujgarg]

Hello,

I want to create one report with SSAS (hosted on our own server). using Live connection. I've configured the on premises gateway. I have tried all the things which I found related to this. I am geeting "there was a data source access error.please contact the gateway administrator" error.

Cinfigureation I have:

• Server where SSAS is configured.
• Admin User (has admin user of the srever as well as added in SSAS as admin: "anujgarg")
• Enterprises on premises gateway configurwed with my email and Gateway servicve account is "anujgarg") and emailID say anuj@garg.com
• I have tried configureing datasource with customdata as well as with the EffectiveUserName. I have logged in as anuj@garg.com

Error: https://prnt.sc/hmEUN5D5k0CK

https://prnt.sc/C9AYQhuWh9ax

Please help me in get it work I assume I am missing some small peice which is causing this.

Thanks.

Anuj Garg

[GilbertQ]

Hi @anujgarg 

Is your SSAS On-Premise connected to an Active Directory domain?

In order for it to work it needs to be connected and signed into a Active Directory domain

[anujgarg]

Hi @GilbertQ 

No it’s not connected to the Active Directory Domain. It is necessary to be connected and signed into a Active Directory domain? Is there any way to work it with AD?

Thanks,

Anuj Garg