Showing results for 
Search instead for 
Did you mean: 

Fabric is Generally Available. Browse Fabric Presentations. Work towards your Fabric certification with the Cloud Skills Challenge.

Regular Visitor

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



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



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



Anuj Garg


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?


Anuj Garg

Helpful resources

PBI November 2023 Update Carousel

Power BI Monthly Update - November 2023

Check out the November 2023 Power BI update to learn about new features.

Community News

Fabric Community News unified experience

Read the latest Fabric Community announcements, including updates on Power BI, Synapse, Data Factory and Data Activator.

Power BI Fabric Summit Carousel

The largest Power BI and Fabric virtual conference

130+ sessions, 130+ speakers, Product managers, MVPs, and experts. All about Power BI and Fabric. Attend online or watch the recordings.

Top Solution Authors
Top Kudoed Authors