Forum Discussion

anujgarg's avatar
anujgarg
Regular Visitor
2 years ago

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

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 [email protected]
  • I have tried configureing datasource with customdata as well as with the EffectiveUserName. I have logged in as [email protected]

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

 

Gateway Connections

2 Replies

  • GilbertQ's avatar
    GilbertQ
    Icon for Super User rankSuper User
    2 years ago

    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's avatar
      anujgarg
      Regular Visitor
      2 years ago

      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