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
Join our Fabric User Panel

Join our Fabric User Panel

This is your chance to engage directly with the engineering team behind Fabric and Power BI. Share your experiences and shape the future.

June 2025 Power BI Update Carousel

Power BI Monthly Update - June 2025

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

June 2025 community update carousel

Fabric Community Update - June 2025

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

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