Reply
anujgarg
Regular Visitor

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 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

 

2 REPLIES 2
GilbertQ
Super User
Super User

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





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

Proud to be a Super User!







Power BI Blog

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

avatar user

Helpful resources

Announcements
July 2025 community update carousel

Fabric Community Update - July 2025

Find out what's new and trending in the Fabric community.

July PBI25 Carousel

Power BI Monthly Update - July 2025

Check out the July 2025 Power BI update to learn about new features.

Top Solution Authors (Last Month)
Top Kudoed Authors (Last Month)